MySQL DBA - Tips and Techniques Magazine

14 Oct 2014

Restoring a backup to new server

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