How do you guys backup your database ? Any good Cron Job Script for CPANEL ?

Can anyone please share the script you use in backing up your database on phpmyadmin via cpanel using cron jobs. Any one who can share? Thanks.

 

The way we do our client backups is from server to server. We have plans for a power shell script which will connect to the FTP server and download the backups to another local based location. So you could follow the same route but with a cron job that could backup all the sites.

 

http://www.percona.com/doc/percona-xtrabackup/

Also, a 3rd party GUI like navicat makes it really easy to backup on a schedule and you don't need to rely on anything on the server to get a full backup.

 

I backup it manually.

 

Only use hosting that does backups and you don't need to worry. This is a lesson hard learned by many that search out cheap hosting. They wonder why they get hacked all the time, learn nobody did backups for them and wonder why their sites are slow. Invest in good hosting before beginning any online venture. It's the foundation for all your hard work.

I learned this almost 9 years ago when I had to rebuild a website 3 times in 5 months. Now I run a hosting service (no pms please) and nobody on my servers get hacked, lose data or have slow websites. My inventory is on these same servers so they fall under my umbrella of security I invested in for my own websites.

Get good hosting and forget about doing your own backups and such.

 

mysqldump -udb_user -pdb_pass -hdb_host --opt --add-drop-table --quote-name db_name > somename.sql

 

If your hosting company allows PHPmyAdmin, you can just click "Export" and save it to your computer.

 

Database backup is easy with Cpanel just go to backups then click on the database it downloads immediately.

But if you need to do it daily you may use a php backup script to backup and upload to a ftp or email to you, if you use wordpress there are plugins who do that.

Plus most of the hosting companies do take backups daily so you really don't need to care.

 

Listen, your hosting co should be doing this, but have you considered going a little further and backing up your valuable content on your personal pc,laptop? I just found this and it solved my problems and gave me access to my files anywhere anytime from my phone or any computer. http://track.mypcbackup.com/?hash=68daf8bd It is also an income opportunity.

 

If you have access to crontabs, then you should be able to schedule a command with mysqldump. Wordpress also has some plugins that will do this for you.

 

If you have root access the below should work,

for i in `mysql -e "show databases" | awk '{print$1}' | egrep -v ^Database$ | grep -v information_schema`
do
echo dumping $i
mysqldump $i > $i".sql"
done