Restoring your MySQL Database
Above we backup the Tutorials database into tut_backup.sql file. To
re-create the Tutorials database you should follow two steps:
EASY!
How to Back Up and Restore a MySQL Database
Above we backup the Tutorials database into tut_backup.sql file. To
re-create the Tutorials database you should follow two steps:
- Create an appropriately named database on the target machine
- Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
example:
$ mysql -u username -pTHISISTHEPASSWORD DATABASENAME < DATABASENAMEBKP.sql
EASY!
How to Back Up and Restore a MySQL Database
No comments:
Post a Comment