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 [...]

Continue reading