|
Installation:
1. Place the
"mysql_monitor200.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_monitor200.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_command200.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.
|
