Installation:
1. Place the "mysql_monitor300.pl"
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_monitor400.htm"
and "mysql_monitor_help.htm" pages into your chosen HTML
document directory.
Use:
1. Run the script from your browser,
such as:
http://www.myserver.com/cgibin/mysql_command400.pl
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.
|