Database Menu
Super Admin Database Commands
Additional Help Topics
-
Manage Database
-
This command opens a database manager for the current site database in a new window. It is a very powerful tool which allows you to view or edit all the Exponent tables and entries. The application requires the user already be logged into the site and only allows access to the current site database. It operates similar to phpMyAdmin and includes in-place editing by a ctrl-click on the field, and other nice features. ...
-
Restore Database
-
This command allows you to import archived data to restore the site database. This will overwrite existing tables in the database. ...
-
Backup Database
-
This command allows you to export the site database (content) so it can later be used to restore the site. ...
-
Update Tables
-
This command updates the database structure by checking and adding any new features. It is often required after installing an upgrade or a new extension. ...
-
Optimize Database
-
This command attempts to remove any overhead in the database and compact it. ...
-
Repair Database
-
This command attempts to perform some simple repairs to the Exponent database. It will attempt to resurrect files missing from the 'recycle bin,' re-establish missing modules that should be displayed in the "aggregation' windows, and a few other fixes by checking missing information against other tables. ...
-
Fix Table Name
-
This command attempts to rename any of the mixed-case table names which may have inadvertently changed to lower-case on a windows server. The BEST fix is to add a 'lower_case_table_names=2' setting to the [mysqld] section of the mysql ini file. ...
-
Remove Unneeded Table Columns
-
This command attempts to update the table definitions like the 'Update Tables' command, however, it will also remove any unneeded columns from tables. ...
-
Remove Unused Tables
-
This command removes any database tables marked as obsolete as a result of a site upgrade or extension installation. ...