|
|
MySQLMate - Tables Manager
Requirements
This script requires the mySQL.pm module on a UNIX server. If you do not know if your server has the mysql.pm module installed, download our free E-Vars Script to find out. E-Vars will let you know which modules are installed. You're looking for "mysql".
Configuration
Before attempting any configuration, upload the script to an executable folder, CHMOD to 755 and load it in a browser. Upload the mysql.jpg image you received in the zip file, to a folder names "images" off your web root folder. Nine times out of 10, that is all that's required. If you'd like to place the image elsewhere, or would like any back ups you create located in a specific folder, you may edit the variables on lines 10 - 22 of the mysql.cgi script. If you can not load the log in screen, make sure the path to Perl on the first line of the script is correct.
Getting Started
MySQL Mate will not create databases for you. You should contact your host and ask them to set you up as a user. To connect, you will need a database name, username and password. Load the script in a web browser and enter the information. If successful you will be taken into the control area where you can view, back up and manage the database you connected to.
Backing up data tables
Multiple tables can be simultaneously backed up to flat files on the server or you may print the contents of the tables to your browser. If backing up to flat files on the server, they will be located in the folder specified in the $backPath variable of the script. By default, this path is "/sqlbacks" and is auto created at the time of back up.
To back any number of tables, select the tables by clicking on them in the table list menu situated on the right hand side of the control panel. Hold down the control key while selecting to select multiple tables. Select an option from the drop down menu (right hand side) and then press the "Back up" button.
The back up data is generated in a format that allows you to easily restore the data should you ever need to. Each record is backed up as a mysql command. To restore that data, you may use the "Execute manual query" box. Copy the data in to the textarea/box, remember to select "Multiple queries" and press the "Execute manual query" button. Each query will be processed sequentially. Any errors, such as duplicate records, will appear in bold red text.
More information
More information about mySQL is available. We have a basic tutorial as well as a dedicated FAQ that we plan to continually develop. If you have any questions at all about mySQL, or MySQL Mate, please Submit a Question. For a comprehensive guide to mySQL, see the official mySQL documentation.
|
|
|
