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