We accept safe and secure Credit Card and PayPal Payments.
 
Perl Scripts

All Count
Attachment Mailer
Perl Scripts Build A FAQ Plus
Perl Scripts Clock In Center
eBackup Automated
Easy Poll
eSurvey
Fetch a File
Form Maker
Mailing List Server
MySQL Mate
PDF Creation
QCart
Quick Fix
Quote of the day
Speed Search
Task Manager
Traffic Pack
Upload Plus
Upload Gold
Upload Pro
Website Manager

 
Free Perl Downloads

Free Perl Scripts Main Page
Free Perl Scripts 404 Alerter
AccessLog Viewer
Build A FAQ
PHP Scripts eBackup
Free PHP Scripts ErrorLog Viewer
eVars - Server Info
HT Pass Creator
Upload Lite
Website Manager

 
JavaScripts

Free Java Scripts Alert Boxes
Free JavaScripts Browser Sniffer
Check email
Generators
Slide Show
Sudoku
Window Maker
More...

 
Extra Utilities

ASP Scripts Ascii Codes
Free ASP Scripts Color Picker
Font Finder
HT Pass Creator
Meta Cloak
Meta Magic
Pano Zooms
SlideShow
Server Size

 
Online Tutorials

Free HTML Scripts Glossary
Free HTML Scripts HTML
JavaScript
MySQL
SSI
Build Traffic
Other

 
Miscellaneous

About Us
Graphics
Testimonials
Installations
Latest versions

 
Hawk Eye in Tennis

Should Hawk Eye replace linesmen and lineswomen at all tennis tournaments?







 
View all Polls

Run Polls on your site

Run your own Surveys

 
Store Download FAQs Contact Us Support Programming Policies  

MySQLMate - Tables Manager

Program: MySQL Mate 1.5
Cost: US$10 No Demo
Platform: Unix, Linux, Sun Solaris, FreeBSD, BSDOS Users Guide
Requires: Perl F.A.Q.

  • Requirements
  • Configuration
  • Installation
  • License and Disclaimer
  • Getting Started
  • Backing up data
  • More information
  •  


    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".

    Top of Page



    Installation - Linux/Unix/Mac Servers

    1. 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.

    2. 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.


    3. Load your Browser, point it to the mysql.cgi file. For example, in your browser, type :

      http://www.yourdomainname.com/cgi-bin/mysql.cgi
    Top of Page



    Common Installation Problems - Linux/Unix/Mac Servers

    NB: Shared Secure Servers, VPS, SBOX and Free Servers.

    1. 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.

    2. 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.
    Top of Page



    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.

    Top of Page



    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.

    Top of Page



    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.

    Top of Page

    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.

    Top of Page

    Speed Search our site
    Plesk Hosting
    Linux servers with Plesk Control Panel, cgi-bin, crontab manager, Mysql, PHP and ASP.

    Survey Software
    Create unlimited web based surveys on your website from your website

    Discounted Scripts
    Subscribe to our periodial newsletter to receive special offers.

    Bathroom Hygiene
    How often do you thoroughly clean your bathroom?








    View all Polls

    Run Polls just like this one on your website!


    About us | Contact us | Script FAQs | Script Support | Website Hosting | Our Policies | Store | Testimonials
    Subscribers log in here. Subscribe to our periodical newsletter for special offers on commercial scripts, hosting, exciting business opportunities, and industry news and events. Our Mailing List Software is powered by Consolidator    
    HTML Plain text
    ©1999 - 2015 All content Copyright PerlScriptsJavaScripts.com Proudly hosted by LinuxHostingPlans.com