Moving Servers

Sheldon Posted by Sheldon on April 7th, 2008.
Print This Post | Email to a friend | Leave a Comment

Another ‘cleaning out the hard drive post…’

This group of commands will move database and files from one server to another the fastest.

mysqldump -u dbuser -p dbname > dbname.sql
Enter password: #####
scp dbname.sql username@newserver:./dbname.sql
mysql -u dbuser -p -h localhost dbname < dbname.sql
Enter password: #####
scp -rp . username@newserver:./directory
** Change DNS to point to new server **

To Do: Add to Digg | Add to Del.icio.us | Print This Post | Email to a friend | Leave a Comment

Remotely Related: Moving to Flickr

Leave a Reply