Migrated WordPress from CORESERVER to Sakura VPS

Tadashi Shigeoka ·  Sat, October 6, 2012

I migrated WordPress from CORESERVER to Sakura VPS. Here’s a rough memo of the procedure.

WordPress | ワードプレス

■ Work on Source Server【CORESERVER】

Dump DB from the management screen (create mysql_examplecom.dump)

Next, compress the WordPress content directory under public_html/ with tar.

$ cd public_html/
$ tar zcvf example.com.tar.gz example.com/

Transfer mysql_examplecom.dump and example.com.tar.gz from CORESERVER to Sakura VPS.

■ Work on Destination Server【Sakura VPS】

Create database for WordPress use.

mysql> create database dbname;
mysql> grant all on dbuser.* to dbname@localhost identified by 'mypassword';

Import from the data dumped on CORESERVER.

$ mysql -u dbuser -p dbname < mysql_examplecom.dump
$ chown -R nginx. /var/www/vhosts/example.com

The rest is as usual.


Reference Information

CORESERVER から さくら VPS に WordPress を移行した | 暇人じゃない

さくらのVPS サーバ構築メモ 9 – データ移行 | コムギドットネット

That’s all from the Gemba.