How to create a MSDOS Batch Script to backup all mysql database into separate file for restoration
Posted on 2009-04-13
I would like to request an assistant.
My mysql database mysqldump.exe file and bin folder is located at C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin .
May i know how to create a MSDOS batch script to dump/backup hundreds of my database into a separate .sql backup file for restoration purposes ?
FYI, my database is located in C:\Program Files\SWsoft\Plesk\Databases\MySQL\data folder .
Appreciates if anybody can draw a script to backup all the database and also to restore the database on the other server.