Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Need Help: Quickly moving MySql databases from one server to another

[StephenS]

I currently have vBulletin and photopost installed on a server, I recently purchased a new server so need to move the databases over to the new server.

Being fairly new to MySQL and what not, I have no idea how I would go about doing this.

Any help would be greatly appreciated!

Regards,
Stephen

[MaB]

/etc/rc.d/init.d/mysql(d) stop
cd /var/lib
tar -czvf mysql.tar.gz mysql

transfer mysql.tar.gz to new server into /var/lib dir

new server:
install mysql.
/etc/rc.d/init.d/mysql(d) stop
cd /var/lib;
tar -xzvf mysql.tar.gz

/etc/rc.d/init.d/mysql(d) start

[amc-james]

MaB speaks the truth. Just make sure the proper users/groups are on the new box and that the permissions/ownerships are retained.

[SkullOne]

Theres another way, but its more complicated
Just dump each database to a .sql file, and assuming you have mysql running on another syste, you can just pipe that .sql file into an already running server
mysql -u username -p -D yourdb < backup.sql

Theres also other ways, but making a tar file is probably the easiest
Some DBA's will tell you thats totaly wrong, but hey, it works.

[MaB]

I'd also make sure you install the same MySQL version on the new server as you have on the old server - just to make 100% sure that the zipped files will work...

after its running on the new server with the old sql version, install the latest mysql rpms and it will upgrade and save your data.