MySQL dump & restore
- Thursday, July 29, 2010, 7:21
- Database, Linux, MySQL
- Add a comment
|
|
mysqldump to create a simple backup of database.Here we are using mysqldump to backup database ‘db‘ to dumb.sql
#mysqldump -u root -p db >dumb.sql
This will ask for root password.After entering the root password database ‘db’ dump into dump.sql
To back up all databases , we could use –all-databases option instead of dbname,so
#mysqldump -u root -p –all-databases > all_dump.sql
To restore this dump.sql back to database,we could use the following command
#mysql -u root -p db <dump.sql
Related Posts
About the Author
CoreTimer has written 31 stories on this site.
System administrator(Linux/UNIX/Windows) RHCE,MCP,CCNA
