MySQLMate - Tables Manager
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".
Installation - Linux/Unix/Mac Servers
- Setting the Path to Perl. Open mysql.cgi in a Plain Text Editor and make sure the first line of the CGI Script is the Path Perl for your server. Most Users can skip this step being the default Path to Perl shipped in the CGI Script is very common.
NB: if you do not you a Plain Text editor such as Windows NotePad or Mac Textedit (in Plain Text Mode), your Text/HTML editor will add extraneous code to the CGI Script when you save it which will result in a server 500 Error.
- Upload mysql.cgi to your cgi-bin or any cgi enabled
directory and CHMOD
it to 755. It is imperative that you upload (transfer) mysql.cgi to your server in ASCII mode.
If you forget to CHMOD all mysql.cgi, Step 3 will yield a Server 500 Error.
If you do NOT upload (transfer) mysql.cgi to your
server in ASCII mode, Step 3 will yield a Server 500 Error.
- Load your Browser, point it to the mysql.cgi file. For example, in your browser, type :
Common Installation Problems - Linux/Unix/Mac Servers
NB: Shared Secure Servers, VPS, SBOX and Free Servers.
- Server 500 Error. This most often occurs because Step 2 was not followed precisely. Make sure the CGI Scripts you are uploaded are CHMOD to 755, the folder the CGI Scripts reside in is also CHMOD to 755, and the CGI Scripts were transferred in ASCII Mode. Auto-Detect only detects the extensions you specify in your FTP client's Settings.
- We offer a very reasonably priced Custom Installation Service. We'll Setup the CGI Script for you and send you the Log in details which you can update at your own leisure. If we cannot successfully Setup the CGI Script we will refund both the Installation fee and the purchase price of the CGI Script. To Order Custom Installation, please fill in our Secure Installation Order Form.
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.
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 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.