Hi all, I am trying to backup all my mysql database in my server using
mysqldump all databases
but it seems that this operation will only backup all database into one single file.

Is there any way to backup mysql databases in separated files

Thanks

I think it is 2 ways to get it done.

1. export each of your tables by phpmyadmin.mysite4now.com
2. dump each of your tables by using Navicat

Do it programmatically in VB script.
Write a loop to dump the DB into separate files. XD



You can also seek some 3-rd party tools to do it.

Try this syntax :

mysqldump -u [login] -p[password] -h[ServerName] -r [DumpFileName] [DbName]