Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Topic started by: Piccolodmq on June 23, 2017, 04:51:56 am

Title: Migrating a server from one computer to another?
Post by: Piccolodmq on June 23, 2017, 04:51:56 am

Hi there everyone.

I have my custom server in a virtual computer that I am not able to keep on paying, next month.   I want to migrate the server from that computer to mine.    It is a trinitycore compiled  3.3.5 server (January 2017),  with tons of custom stuff (DBC and DB), 

I know I can just copy the BUILD and TRINITY files, but how do I get all the DB changes...?   IS there a way to export all the DB without going one file at a time (like exporting creature_template ... into a big file, and then importing in the new server.   

What is your suggestion so I can "clone" my server easily with characters, and changes?

Thanks!

Title: Re: Migrating a server from one computer to another?
Post by: Amaroth on June 23, 2017, 09:01:24 am

Connect to your MySQL database using any table editor, like Navicat, HeidySQL, SQLYog... Right-click on database name. I'm pretty sure you'll find options how to export SQL dump file. Do this for all 3 databases, then import those 3 SQL dumps to your local MySQL server. You can find guides how to use SQL dumps online.

For example SQLYog btw can also directly copy database from one connection to another one. Yet again, you can access that option by right-clicking on a database, the very first option there is Copy Database To Different Host/Database.

Title: Re: Migrating a server from one computer to another?
Post by: Steff on June 23, 2017, 05:33:38 pm

For test servers I just use xampp and put the wow server files also in the xampp folder. So i can just copy all to external hd and move it with me. On new pc just run xampps configure script and you can start mysql and webserver for registration page in lan.

Title: Re: Migrating a server from one computer to another?
Post by: schlumpf on June 23, 2017, 11:39:14 pm

Please note that xampp is _horribly_ insecure and should _never_ be used for anything publically accessibke!

Title: Re: Migrating a server from one computer to another?
Post by: Piccolodmq on July 07, 2017, 08:02:01 am

OK so I migrated, succesfully all of my database.  How do I tell my world server and auth server to connect to a new, mysql (the portable one I made).

Title: Re: Migrating a server from one computer to another?
Post by: Piccolodmq on July 14, 2017, 06:57:50 pm

Again, by reading and reading how everything works. I figure it out.   Thanks for the help!