MySQL Monitor Help
Function
Description
Show Structure

Choose a table from the list, click this button to display the table's structure

Show Table Size(s)

This function will calculate and display the sizes of all tables in a MySQL Database or the size of a single table if one is selected from the table list.

Dump Table

Choose a table from the list, enter a file name, and click this button to dump the entire table to this file (including the CREATE command for the table). If no file name is given, the table will be dumped to the browser.

OPTION: the resultant file will be gzipped if the gzip checkbox is checked.

Load Table

Choose a file from the Load File popup menu and click this button. The table will be created from the CREATE statement from the file and all the contents will be loaded. This operation is the complement of the "Dump Table" operation.

OPTION: check the "drop table" checkbox if there is already a table with the same name.

Export Data

Choose a table from the table list, enter a file name, chose an export format and click this button. This will export all the data into a text file with the desired delimiter (comma, tab or colon). This is most useful when exporting MySQL tabular data for use with another database, such as Excel.

OPTION: the resultant file will be gzipped if the gzip checkbox is checked.

Import Data

Choose a table from the table list, chose an import format and click this button. This will import all the data from a text file with the desired delimiter (comma, tab or colon). This is most useful when importing data from other database tables (e.g. from Excel) into MySQL.

The table must have already been created before being able to use this function.

OPTION: check the "delete entries" checkbox to delete ALL entries in the chosen table before importing new values.

Convert

Converts a date to UNIX time, or vice-versa. Just fill in the field you want converted and click the Convert button.

Run Command

Select a command and edit the appropriate values (table name, etc.). Then click this button to run the MySQL command.