Today I moved this blog from a vServer to a dedicated server. The migration went surprisingly smooth. I just had to apt-get install the Debian packages apache2, mysql-server and wordpress. Afterwards only the following steps were necessary:
- dumping the old database with basically just one command:
mysqldump -u$DBUSER -p$DBPASS –lock-tables=false $DBNAME > $DBFILE
- creating the database on the new host:
CREATE DATABASE $DBNAME;
\r $DBNAME
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON $DBNAME TO ‘$DBUSER’@’localhost’ IDENTIFIED BY ‘$DBPASS’;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON $DBNAME.* TO ‘$DBUSER’@’localhost’ IDENTIFIED BY $DBPASS’;
FLUSH PRIVILEGES; - importing the dump with something like:
mysql –user=$DBUSER –password=$DBPASS $DBNAME < $DBFILE
and almost done …
Finally some fine tuning of /etc/wordpress/htaccess and access rights of a few directories to allow installation of plugins. As I wanted to clean up my wp-content-directory, I manually reinstalled all plugins instead of just copying them. Thankfully all of the important plugins store their data in the database and all settings survived the migration.