: Need suggestions for automated file and MySQL database backup on shared web host We have several websites at multiple hosting companies (all shared hosts - some using cPanel, others using Plesk)

@Odierno851

to backup your schema in MySql you can do:

mysqldump -u root -p [schema-name] > backup.sql


to backup your files:

tar cvfz site_backup.tar.gz [folder to back-up]


and if you really want to make it automatic - create a shell script that creates daily backups with rotation - and call your script from cron.

Vote Up Vote Down

@Lengel546

Hello there is a PHP script doing what you need : Website 2 Backup
It has many features, but the most important for your needs :


Backup files and databases
Avoid shared web hosting limitations (maximum execution time, limitation of upload size)
Backup to Amazon S3
Incremental files backup to use less space on storage
Automated recovery of files and databases from Amazon S3 without files manipulation.

Vote Up Vote Down

@Courtney195

I've a dozen sites on Hostgator Centos shared hosting.

I've written a shell script which I placed in crontab which runs at 3am and backups mysql db of all sites, compresses it and email it to rotating gmail or hotmail account. And weekly or so I take full cpanel backups on my hotfile.com account.

If it isn't Ecommerce or so site then this'd suffice.

Vote Up Vote Down