Create a Batch file WinXP

Hi Experts,

I would like to know if it is possible to create a script to go into MySQL, load up all the databases and then back them up individually rather than having one big file with all of the in one file.

Any help regarding this will be appreciated.

E.g.
DB1
DB2
etc..... all backed up individually.

Regards,

introlux
introluxAsked:
Who is Participating?
 
Lukasz ChmielewskiCommented:
how is the backup process done ? just copying ?
0
 
t0t0Commented:
Yes it is but first you must say what program you are using to backup your database files?
0
 
dkaislaCommented:
if you're using mysqldump, use the --databases option for every database you have
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.