mySQL

mySQL: How to backup/restore SQL databases through SSH


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /homepages/3/d98111892/htdocs/insanelabs/htdocs/wp-content/plugins/ultimate-google-analytics/ultimate_ga.php on line 524

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