Backup and Restore Mysql

Backup
 
mysqldump -u user_name -p[your_password] database_name > File_name.sql
 
This will only work IF the DATABASE does NOT already exist:
 
mysql - u user_name -p your_password database_name < file_name.sql
 
OR USING our example FROM the previous page:
 
IF your DATABASE already EXISTS AND you are just restoring it, try this line instead:
 
mysqlimport -u user_name -p[your_password] database_name file_name.sql