Heres a nice little command to backup all your database into a SQL file:
mysqldump -uusername -ppassword --all-databases --opt >/location/backup.sql
Together with a bit of cron and it should be nice a backup solution onto a remote server.
Part of the reason for this is that my MySql server is not accessible remotely and my VPS is accessible by SSH only.
Basis for this taken from, although the command posted there was missing the --all-databases flag:
http://www.pantz.org/software/mysql/mysqlcommands.html
No comments:
Post a Comment