Can i backup the mysql database automatically every week like scheduled job in local Phpmyadmin.

if possible i would like to take the each database separate file.Is this possible !

Thanks

link|improve this question
Short answer - no, even if were possible it would be a bad idea to use phpmyadmin to run this. If you want a recommendation of how you should do this then we'd need to know what OS it runs on. – symcbean Oct 31 '11 at 15:23
@symcbean:windows xp , windows 7 or Ubuntu any thing is ok – gowri Nov 1 '11 at 3:38
feedback

1 Answer

up vote 3 down vote accepted

You should not use phpmyadmin for critical maintenance tasks, as it is not reliable enough.

Instead, write a simple cron script to do this with the mysqldump utility:

#!/bin/bash
outdir="/some/large/dir"
for d IN (mysql yourdb1 yourdb2) do
 mysqldump "$d" | tar czf "${outdir}/${d}.tgz"
done
link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.