Migrating wpmu blog to new host

Posted at June 3, 2010

I have job to transfer wordpress multi user to new host. The wpmu system currently host 400+ with subdomain type.
The old host and new host use same operating system FreeBSD dedicated server but with different version.
The procedure for move wpmu to new host not different than moving ordinary wordpress blog.

Preparing and packing

1. Dumping mysql database

#  mysqldump -udtonet2 -pdotnet22008 dotnet2 > dotnet.sql

2. Packing all files to one tarball

# tar cvzf wordpress-mu.tar.gz  wordpress-mu

3. Transfer the file to new host

# scp wordpress-mu.tar.gz erau@172.88.1.8:/home/erau

Password:
wordpress-mu.tar.gz                    100%   402MB  13.9MB/s   00:03
#
4. Change dns setting

add wildcard to tinydns data file.

.batikweb.com:127.0.0.1:a:259200
.1.88.172.in-addr.arpa:127.0.0.1:a:259200
+batikweb.com:172.88.1.8:8640
+www.batikweb.com:172.88.1.8:8640
+*.batikweb.com:172.88.1.8:86400
@batikweb.com:172.88.1.11:mail.batikweb.com:10:86400

make file

# make

restart dns

# svc -t /var/service/tinydns/
# svc -t /var/service/dnscache/

check dns resolv

# dig batikweb.com

; <<>> DiG 9.3.4-P1 <<>> batikweb.com
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 15165
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;batikweb.com.                        IN      A

;; ANSWER SECTION:
batikweb.com.         8640    IN      A       172.88.1.8

;; Query time: 0 msec
;; SERVER: 172.88.1.10#53(172.88.1.10)
;; WHEN: Tue May 11 09:59:31 2010
;; MSG SIZE  rcvd: 48

#

Unpack and restoring

This steps taken in new host.
Login to server 1.8
4. Move the file

# mv /home/erau/wordpress-mu.tar.gz  /home/dotcom
# cd /home/dotcom
# tar xvzf wordpress-mu.tar.gz

Change vhost

# ee /usr/local/etc/apache22/extra/httpd-vhosts.conf

add these lines :

<VirtualHost 172.88.1.8 >
ServerAdmin alam@hostingformula.net
DocumentRoot /home/dotcom/wordpress-mu
<Directory /home/dotcom/wordpress-mu >
AllowOverride FileInfo Options
</Directory>
ServerName batikweb.com
ServerAlias *.batikweb.com
</VirtualHost>

5. Create database

# mysql -ualam -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 590411
Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input
statement.

mysql> create database wpmu;
Query OK, 1 row affected (0.01 sec)

mysql>

Grant all privileges

mysql> grant all privileges on wpmu.* to dtonet2@localhost identified by ‘dotnet22008′ with grant option;
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>

Import database

mysql> exit
Bye
#

6. Import database

# mysql -udtonet2 -pdotnet22008 wpmu < dotnet.sql

Change wp-edit.php to new host information.

#ee  wp-config.php

7. Restart Apache

# /usr/local/etc/rc.d/apache22 restart

Performing sanity check on apache22 configuration:
Syntax OK
Stopping apache22.
Waiting for PIDS: 793.
Performing sanity check on apache22 configuration:
Syntax OK
Starting apache22.
#

Check everything from browser and no problem so far.

Finish, mission accomplished.

Related Reading:

Drupal For DummiesDrupal For Dummies

Learn to set up, manage, and administer a Drupal Web site

Drupal offers unparalleled flexibility for content-managed Web sites, but most ... Read More >

Using DrupalUsing Drupal

With the recipes in this book, you can take full advantage of the vast collection of community-contributed modules that make the Drupal web framewo... Read More >

Pro Drupal Development, Second EditionPro Drupal Development, Second Edition

Widely praised for its in–depth coverage of Drupal internals, bestselling Pro Drupal Development has been completely updated for Drupal 6 in thi... Read More >

Pro Drupal 7 Development, Third EditionPro Drupal 7 Development, Third Edition

This book is geared toward professionals that need to deploy and customize Drupal. This book delves deep into the internals of the Drupal 7 system ... Read More >

Beginning Drupal 7Beginning Drupal 7

This book focuses on the nontechnical user who is responsible for building, maintaining, and managing Drupal web sites. The book covers why you sho... Read More >

Thanks for reading, if you think this post help you please consider to buy me a beer

Search Terms :

  • wordpress mu uniform server
  • changing host of wordpress mu
  • moving wpmu to root
  • mysql> grant all privileges on wpmu *
  • new wpmu site 2010
  • transfer from wpmu to server
  • wordpress 3 migrate to new host
  • wordpress mu change host
  • wordpress mu transfer blog
  • wordpressmu change dns
  • wpmu blog dir move site to internet from development
  • wpmu hosting
  • wpmu migrate
  • wpmu transfer mysql
  • wpmu transfer server
  • moving wpmu to another server
  • moving wordpressmu to a new server
  • host wpmu
  • how to transfer my wpmu site to another host
  • how to transfer wpmu from one host to another

    • Share/Bookmark
    Step By Step

    If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

    Leave Comment

    (required)

    (required)