Auto backup mysql database in phpmyadmin

Question

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

Answer 1

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