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

CC0 1.0 To the extent possible under law, the creator has waived all copyright and related or neighboring rights to this work.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.