Ali Aboosaidi Umm… Unorthodox?

mySQL: How to backup/restore SQL databases through SSH

To backup your database through SSH (create SQL dump):

mysqldump --opt -u user -p dbname > {path}/backup.sql

To restore:

mysql -u user -p dbname < {path}/backup.sql

Related posts:

1. Backup Exec: Transfer scheduled jobs, database and settings to a new backup server
2. Linux: A simple and quick way of sharing a folder with Windows systems using Samba
3. Debian: Symantec Backup Exec 12 and Debian Etch 32/64
4. Linux: vsftpd and symbolic links
5. Linux: htpasswd: command not found