[Archive] HOW TO MIGRATE A SERVER (DIFFERENT COMPUTERS)
[Archive] HOW TO MIGRATE A SERVER (DIFFERENT COMPUTERS)
Original source
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!
rektbyfaith
06-23-2017, 02:54 AM #1Archived author: piccolodmq • Posted: 2017-06-23T02:54:00+00:00
Original source
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!
Original source
Quote: On 23.06.2017 at 5:54 AM, piccolodmq said:If you're using MySQL Workbench, open your connection there and go to Server > Data Export. Then select all the schemas/databases/things and choose "Export to Self-Contained File" below.
I know I can just copy the BUILD and TRINITY files, but how do I get all the DB changes...?
On your computer, create a new connection with similar properties, and do Server > Data Import > Import from Self-Contained File
rektbyfaith
06-24-2017, 06:53 AM #2Archived author: Смердокрыл • Posted: 2017-06-24T06:53:23+00:00
Original source
Quote: On 23.06.2017 at 5:54 AM, piccolodmq said:If you're using MySQL Workbench, open your connection there and go to Server > Data Export. Then select all the schemas/databases/things and choose "Export to Self-Contained File" below.
I know I can just copy the BUILD and TRINITY files, but how do I get all the DB changes...?
On your computer, create a new connection with similar properties, and do Server > Data Import > Import from Self-Contained File
Original source
next time you better use portable MySQL
rektbyfaith
06-24-2017, 07:53 AM #3Archived author: MR.Farrarie • Posted: 2017-06-24T07:53:25+00:00
Original source
next time you better use portable MySQL
Original source
Quote: 42 minutes ago, MR.Farrarie said:Why? There is no reason for doing that. Most of MySQL table editors just give possibility to copy whole database to different connection - which is process which takes up to few minutes. And the rest of editors at least give possibility to export SQL dump and then import it to other database server.
next time you better use portable MySQL
This is kind of question which should be Googled, and its question related to editor piccolodmq is using, because each of them call such things in different manner and have them accessible in different toolbars/menus. But nearly every one of them does have such functionalities.
Just Google "SQLYog copy database to different host", replace SQLYog with editor you are using. Done.
rektbyfaith
06-24-2017, 08:32 AM #4Archived author: Amaroth • Posted: 2017-06-24T08:32:25+00:00
Original source
Quote: 42 minutes ago, MR.Farrarie said:Why? There is no reason for doing that. Most of MySQL table editors just give possibility to copy whole database to different connection - which is process which takes up to few minutes. And the rest of editors at least give possibility to export SQL dump and then import it to other database server.
next time you better use portable MySQL
This is kind of question which should be Googled, and its question related to editor piccolodmq is using, because each of them call such things in different manner and have them accessible in different toolbars/menus. But nearly every one of them does have such functionalities.
Just Google "SQLYog copy database to different host", replace SQLYog with editor you are using. Done.
Original source
Quote: 39 minutes ago, Amaroth said:but with portable mysql
Why? There is no reason for doing that. Most of MySQL table editors just give possibility to copy whole database to different connection - which is process which takes up to few minutes. And the rest of editors at least give possibility to export SQL dump and then import it to other database server.
This is kind of question which should be Googled, and its question related to editor piccolodmq is using, because each of them call such things in different manner and have them accessible in different toolbars/menus. But nearly every one of them does have such functionalities.
Just Google "SQLYog copy database to different host", replace SQLYog with editor you are using. Done.
its like or having a repack
its easier and faster to move or share your server
but also your opinion is good
rektbyfaith
06-24-2017, 09:11 AM #5Archived author: MR.Farrarie • Posted: 2017-06-24T09:11:43+00:00
Original source
Quote: 39 minutes ago, Amaroth said:but with portable mysql
Why? There is no reason for doing that. Most of MySQL table editors just give possibility to copy whole database to different connection - which is process which takes up to few minutes. And the rest of editors at least give possibility to export SQL dump and then import it to other database server.
This is kind of question which should be Googled, and its question related to editor piccolodmq is using, because each of them call such things in different manner and have them accessible in different toolbars/menus. But nearly every one of them does have such functionalities.
Just Google "SQLYog copy database to different host", replace SQLYog with editor you are using. Done.
its like or having a repack
its easier and faster to move or share your server
but also your opinion is good
Original source
OK so I migrated, succesfully all of my database. How do I tell my world server to connect to a new, mysql (the portable one I made).
rektbyfaith
07-07-2017, 06:02 AM #6Archived author: piccolodmq • Posted: 2017-07-07T06:02:10+00:00
Original source
OK so I migrated, succesfully all of my database. How do I tell my world server to connect to a new, mysql (the portable one I made).
Original source
worldserver.conf and authserver.conf store settings for connection to databases. F.e.:
LoginDatabaseInfo = "127.0.0.1;3307;trinity;trinity;medieval_auth"
rektbyfaith
07-07-2017, 06:50 AM #7Archived author: Amaroth • Posted: 2017-07-07T06:50:11+00:00
Original source
worldserver.conf and authserver.conf store settings for connection to databases. F.e.:
LoginDatabaseInfo = "127.0.0.1;3307;trinity;trinity;medieval_auth"
Original source
thanks for your help.
Here is What I get on the login errore log from worldserver
TrinityCore rev. 6732c1c2e1d2 2017-01-22 18:50:14 +0100 (3.3.5 branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
Using configuration file C:/Build3/bin/Release/worldserver.conf.
Using SSL version: OpenSSL 1.0.1t 3 May 2016 (library: OpenSSL 1.0.1t 3 May 2016)
Using Boost version: 1.60.0
DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home
rektbyfaith
07-07-2017, 05:10 PM #8Archived author: piccolodmq • Posted: 2017-07-07T17:10:15+00:00
Original source
thanks for your help.
Here is What I get on the login errore log from worldserver
TrinityCore rev. 6732c1c2e1d2 2017-01-22 18:50:14 +0100 (3.3.5 branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.
______ __
/\__ _\ __ __/\ \__
\/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __
\ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
\ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
\ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
\/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
C O R E /\___/
http://TrinityCore.org \/__/
Using configuration file C:/Build3/bin/Release/worldserver.conf.
Using SSL version: OpenSSL 1.0.1t 3 May 2016 (library: OpenSSL 1.0.1t 3 May 2016)
Using Boost version: 1.60.0
DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home
Original source
authserver.conf contains connection to auth database, while worldserver.conf contains connections to all 3 databases. Make sure you have updated all of them. Also make sure, that everything is correct (IP, port, login, password, database name - ALL of that!).
Also make sure, that account you are connecting to database with actually exists on your new MySQL server. And that your MySQL server actually accepts nonlocal connections (and that your core's account is not set to be able to connect from IP server is not actually connecting from). So many things can go wrong here... Just try to connect to your MySQL by using core's credentials, that can tell you a lot alone.
rektbyfaith
07-08-2017, 08:12 AM #9Archived author: Amaroth • Posted: 2017-07-08T08:12:22+00:00
Original source
authserver.conf contains connection to auth database, while worldserver.conf contains connections to all 3 databases. Make sure you have updated all of them. Also make sure, that everything is correct (IP, port, login, password, database name - ALL of that!).
Also make sure, that account you are connecting to database with actually exists on your new MySQL server. And that your MySQL server actually accepts nonlocal connections (and that your core's account is not set to be able to connect from IP server is not actually connecting from). So many things can go wrong here... Just try to connect to your MySQL by using core's credentials, that can tell you a lot alone.
Original source
Here is what the world server says about password and connections.
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"
and this for Auth server:
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
My password and login for mysql is defautl root/and ascent.
Any of that needs to be changed? How do I alligned this with MYSQL workbench? I know this is commen sense for most of you, but it isnt for me. Any help is apreciated. I will lose everything in a few days if I dont figure this up.
rektbyfaith
07-12-2017, 10:27 PM #10Archived author: piccolodmq • Posted: 2017-07-12T22:27:23+00:00
Original source
Here is what the world server says about password and connections.
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters"
and this for Auth server:
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
My password and login for mysql is defautl root/and ascent.
Any of that needs to be changed? How do I alligned this with MYSQL workbench? I know this is commen sense for most of you, but it isnt for me. Any help is apreciated. I will lose everything in a few days if I dont figure this up.
1 Guest(s)
1 Guest(s)