(Bold sentences are very important)
There are many useful tools in this package, and MySQL Administrator itself has a number of uses.
Here is how to use it to schedule a regular MySQL backup, from your remote MySQL server to your local computer.
- In order to setup a backup schedule, you must setup a profile for the remote connection
* Tools -> Manage Connections -> click on New Connection
- Enter the following parameters:
* Connection - a name for your connection (e.g. yourdomain.com)
* Username - your MySQL username
* Password - your MySQL password
* Hostname - the IP address where your MySQL database resides
* Port - 3307
* Type - MySQL
(Make sure that user name, password, hostname, port matches with the names of the details what user put at the time of VtigerCRM installation.I suggest you to use user name=root, password=' ',and port=3307 and Vtiger CRM server is running)
- Click on Save connection
- You must turn on password saving under General Options
* Tools -> Options -> General Options -> Store Passwords
and also have to select obscured as password storage method.
- You must then connect using the profile you created, to set up the backup schedule
* Go to File -> Close
* Re-open MySQL Administrator, and you should see your stored connection
* Click OK to connect
- Select Backup in the left menu
- Click on the New Project Button
- Enter a name for the project
- Under the Schemata heading, you should see your database; click on Vtigercrm504 for Vtiger 5.04 or Vtigercrm503 for Vtiger 5.03 it once, then click on the right arrow button (there may be a delay here while the program connects to the database and reads in some table information - be patient)
- Eventually you will see your database tables in the right column. If you want to only backup certain tables, here is where you can specify. By default, all tables are selected.
- Clicked the Advanced Options tab
- Select the first option, InnoDB Online Backup - or choose the Full Backup Checkbox at the bottom of the list.
- You can leave all other options at their defaults.
- Click on the Schedule tab.
- Check the Schedule this Backup Project check box (at this point, you may receive a pop-up telling you to turn on Password Storage. If you haven't already done so, click on the Open button on this warning, select the General Settings item on the left, and turn on Password Storage.
- Choose a target folder on your local computer to store your backups.
- Choose a filename (note that by default, your filename will be appended with the backup date)
- Set up your desired schedule, then click on the Save Project button
- At this point, you will be prompted for your local computer's Windows logon details - this should be an administrator account on your computer. Note that if you do not have a password set for your administrator account, scheduled tasks will not run
