Mysql database backup for all databases in individual files

Ok, here is what I am trying to accomplish:

I want to backup each database on my server to a different file. I also want to be able to add databases without having to modify the script.

I have seen scripts that do a dump of all databases into one file, but I am looking for some way to do it individually so that if I need to restore a small 1M database I don't have to sift through a 1-2G db dump to find that part.


Thanks in advance.

 

 

 

 

Top