SQLyog automatically backing up the database

Reference URL: http://blog.csdn.net/kuangkunkui/article/details/7546629

 configure MySQL to automatically back up SQL files with SQLyogCategory: MySQL2012-05-08 16:02 1471 people read comments (0) favorite reports Mysqlsqlfilesessionwindows Database

1. Installing SQLyog

This is not to say, often use MySQL should know and use the tool

2. Start the service

Right-click "My Computer"-"manage"-"services and Applications"-"services", find "Task Scheduler" service, launch it;

3. Configure Automatic Backup

Open SQLyog, "Powertools"--"scheduled backs ..."

Next

Fill in the host address, login password, select the database, click Next

Select Export All Objects, next

Select Single file for all table (s), fill in the file name, select prefix filename with timestamp, Next, Next, Next, next

Select "Save&schedule Configuration"-"Save%schedule it using Windows Scheduler", set log file, Session XML file, next

Fill in specify Job file, specify schedule name, click Finish, the program window will pop up

Create a character that specifies the backup time so that it is possible.

SQLyog automatically backing up the database