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

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
Hi, have you tried this solution? https://mysqlbackupftp.com/mysql-blog/backup-phpmyadmin-automatically/ — Olek Nilson, May 10 '18 at 09:57

score 4 · Accepted Answer · answered Oct 31 '11 at 10:58

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

1 Answers1