Migrating a server from one computer to another?

[Piccolodmq]

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!

[Amaroth]

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.

[Steff]

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.

[schlumpf]

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

[Piccolodmq]

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).

[Piccolodmq]

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