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
