Geek Answers Handbook

How to back up mysql db using mysql workbench

How to make automatic mysql backup using mysql workbench?

alt text

Is it possible?

+6
mysql database-backups
source share
3 answers

If you have a web server with PHP, I would suggest MySqlDumper

It supports:

  • Automatic backup
  • email backups
  • Compress backups
  • Rotate backups
  • and etc.
+5
source share

Mysql scanning is not required for automatic backups,
setting up crontab and using mysqldump (or equivalent) will do the same job and easier.

Example:

crontab -e /* backup every day at 00:00:00 */ 0 0 * * * mysqldump -u root -ppassword YOUR_DATABASE > /backup/YOUR_DATABASE.sql
+10
source share

Planned ATM backups are not planned in Workbench: http://bugs.mysql.com/bug.php?id=50074

At the same time, Workbench is designed for a powerful scripting shell, so you can try to explore which commands can be used for backup and call them directly from the shell. (But I agree that this is too general an idea):

http://dev.mysql.com/doc/workbench/en/wb-extending.html

+1
source share

More articles:


All Articles