How can I backup and restore database?

You can use mysqldump to create a simple backup of your database using the following syntax:

Backup: 

Restore:

• [username] - this is your database username
• [password] - this is the password for your database
• [databasename] - the name of your database
• [host] - this is db hostname (optional)
• [backupfile.sql] - the file to which the backup should be written/read.