[Snippet] Backup and Restore MySQL from command line

[Snippet] Backup and Restore MySQL from command line

Here is how to quickly backup a MySQL database using the command line.

Start by opening Terminal (Mac) or Putty (Win) and follow these commands.

Backing up a database

mysqldump -h hostname -u user --password=password databasename > filename


Restoring a database

mysql -h hostname -u user --password=password databasename < filename