Saturday, January 10, 2009

Too lazy to use phpMyAdmin to back up a database on a remote server?

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