I migrated WordPress from CORESERVER to Sakura VPS. Here’s a rough memo of the procedure.
■ 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.
・CORESERVER から さくら VPS に WordPress を移行した | 暇人じゃない
・さくらのVPS サーバ構築メモ 9 – データ移行 | コムギドットネット
That’s all from the Gemba.