Search code examples
mysqldatabasebackup

How to automatically backup ALL mysql databases into sql statement?

MySQL Administrator> Backup Project. It is a great tool to allow you to select databases, and schedule it.

However my issue is:

Today got a few new websites (new database created) Tomorrow got a few more new websites (new databases created)

In this case, I have to always go into Backup Project> Select those remaining schema not in the backup list...

How to make it auto check for any new databases and include in the backup schedule list?

In other word, how to automate the backup of all the mysql databases (so that we don't need to worry when there's new databases created everyday).

Any way to make it happen?

I'm using Windows 2008 server, which is not sh friendly.

Solution

  • MySQL Administrator

    With MySQL Administrator you need to manually add databases to the backup.

    mysqldump and --all-databases

    If you approach this through a dump-command, you can use the --all-databases option to include all databases into the dump.