Using_mysqldump_Backup_&_Restore_MySQL_Database

Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command.
An examples on how to use mysqldump to backup and restore

To backup:      # mysqldump -u root -p(root_password) (database_name) > filename.sql

To restore:     # mysql -u root -p (root_password) (database_name) <>

from the desk of Amit Maheshwari