Moving Servers

Monday, April 7th, 2008

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 **