Best way to backup all MySQL DBs on daily basis ?

WebHostDog

Well-Known Member
Sep 3, 2006
143
1
166
cPanel Access Level
Website Owner
Hello,
I have tried via cpanel backup app. but seems is not working with MySQL only selected (needs accounts too). Any other cool way to backup server's MySQL DBs on daily basis ?



Thanks,
 

planmysite

Registered
May 1, 2007
1
0
151
Daily Backups of MySQL DB w/ Navicat MySQL

I would recommend Navicat MySQL for daily db backups. You just need to configure your remote host access, etc. This is a great remote admin tool for mysql and is easy to use!

Here's a link to try it out:
http://www.navicat.com/download.html

Let me know what you think?
 

celliott

Well-Known Member
Jan 2, 2006
459
0
166
United Kingdom
I would suggest taking a backup of the data folder containing all the databases in /var/lib/mysql by running a cron to make an archive of that directory.
 

Scotty_B

Active Member
Mar 1, 2003
27
0
151
I would suggest taking a backup of the data folder containing all the databases in /var/lib/mysql by running a cron to make an archive of that directory.
Bear in mind that you won't get any InnoDB type tables doing that.