Connect to MySQL commandline, password will be prompted
$ mysql [ServerDomain] -u -p

Backup Database
$ mysqldump -u [username] -p[password] [databasename] < [backupfile.sql]

Declare databases to backup
$ mysqldump -u [username] -p[password] –databases Tutorials Articles Comments > content_backup.sql

Backup all databases
$ mysqldump -u [username] -p[password] –all-databases > alldatabases.sql

Backup MySQL database and zip in one line
$ mysqldump -u [username] -p[password] [databasename] | gzip -9 > [backup.sql.gz]

Restore database from commandline, no space between -p and password
$ mysql -h [host] -u [username] -p[password] [database name] < [backupfile.sql]

mysql>  create database [name];

mysql> grant all privileges on [database].* to ‘[username]‘ identified by ‘password’;