Topics

Database Menu

Super Admin Database Commands

Loading Help

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. ...