MySQL Monitor - Installation and Use


Installation and Use

Server Requirements

Release Notes

Download Software


1. Place the "" script into your server's CGI directory.

2. Edit the script, entering:

  • the full path name of your HTML directory (typically the www or htdocs directory)
  • the full path name of a "dump" directory
  • the full path name of a "load" directory
  • the full path name of an "export" directory
  • the full path name of an "import" directory
  • and your MySQL database info.

You can also set the script password and enable IP address access protection.

A typical directory structure might appear as follows:

In most cases setting the "dump", "load", "export" and "import" directory permission to "775" will let Perl scripts write into these directories. In some cases these directories must be set to "777" (due to the ownership of directories and how Perl scripts run in some environments).

3. Set the script permissions to "755".

4. Place the "mysql_monitor200.htm" and "mysql_monitor_help.htm" pages into your chosen HTML document directory.


1. Run the script from your browser, such as:

You should see the MySQL Monitor page, with a list of any active MySQL tables.

2. Select a table to dump and enter your password and click Dump Table

You should see the contents of your selected table dumped to the screen.

3. Try the other functions to see that they also work. You will have to first dump a table to a file before being able to load it. Similarly, you will have to first export a file before you can import one.

See the Help page for more information on each command and its use.