How to create a MSDOS Batch Script to backup all mysql database into separate file for restoration

Hi,

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.

Thank you.
LVL 2
smksaAsked:
Who is Participating?
 
oobaylyCommented:
You could use the vb script. It needs a file called databases.txt in the same directory which contain each database name on a new line.
It loops through each db, calling mysqldump for each one, and outputing to a names sql dump file
option explicit
 
dim shell, fso, txtDB, db, resp
set fso = CreateObject("Scripting.FileSystemObject")
set shell = CreateObject("WScript.Shell")
 
' Open the Database file
set txtDB = fso.OpenTextFile("databases.txt")
 
' Read each line
while(not txtDB.AtEndOfStream)
  db = txtDB.ReadLine()
  if (trim(db) <> "") then
     resp = shell.run("mysqldump.exe -h <host> -u <user> -pPassword " + db + " > " + db + ".sql")
  end if
wend
 
txtDB.close()

Open in new window

0
 
vinurajrCommented:
0
 
smksaAuthor Commented:
Hi,

May i know how to restore using a script to restore all the database that has been backup ?

Appreciates if you can add some notes or scripts.
0
All Courses

From novice to tech pro — start learning today.