Archive > April 2009

Moving MySQL to a new server (Ubuntu Server 8.10)

This short guide will help you move all users, databases, tables, etc from server1 (current server) to server2 (new server).
Stop the mysql service on both servers:
sudo /etc/init.d/mysql stop
Setup a temporary directory in the home folder of your user on server2.  (This is because we don’t have root access remotely.)
mkdir ~/varlibmysql
On server1:
sudo rsync -axv –progress –stats [...]

Continue reading