Backup and Restore MYSQL Databases

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
 
Top
Maintained By Amit Maheshwari