Tag: ssh
mySQL: How to backup/restore SQL databases through SSH
by Ali on Oct.30, 2008, under Linux, SQL
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