MySQL :: Auto backup all newly created database
 

hi guys,

i backup my db running a simple shell script using scp and ssh. But everytime I create a new dB i have to manually create a new entry in the script so as to backup the database.

is there anyway to automate it?

Unless you want them all seperate from one another, just use the --all-databases option with mysqldump. Other than that, create a shell script to add whatever database you need to your existing script..

ah, i should have thought of that.

a shell script to update the script running the dB backup :)

but nope, don't wanna backup all my databases onto one .sql file. makes restoration troublesome. since I can't choose to restore a portion of it only, right?

Not that I know of since it's all in one large sql file.