Backing up a MySQL database
To back up a MySQL database using mysqldump, use following command on the server
It will ask you for your password and then create a backup of your database. Do not forget to replace <username> and <database> with your values. If you want to backup everything, you can use:
It will backup all databases including "mysql" database, which contains various settings like user accounts.
Restoring a MySQL database
You can restore your database using following command:
Simalary, if you want to restore everything, use:
As you may notice, only difference is the name of the input file.