0. Connect to New server
1. Ensure mysql is up and running
- ps auw | grep mysql
- ps –ef |grep mysql (LINUX)
2. Connect to mysql to make sure you can.
- mysql
- mysql –uroot -pXXXXX
3. Run Restore
- bunzip2 < MYSQL-BACKUP-FILENAME.bz2 | mysql -uroot –pXXXXXX
or
- gunzip < MYSQL-BACKUP-FILENAME.gz | mysql -uroot –pXXXXXX
No comments:
Post a Comment