[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!

[Смердокрыл]

On 23.06.2017 at 5:54 AM, piccolodmq said:

I know I can just copy the BUILD and TRINITY files, but how do I get all the DB changes...?

 

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.

On your computer, create a new connection with similar properties, and do Server > Data Import > Import from Self-Contained File

[MR.Farrarie]

next time you better use portable MySQL

[Amaroth]

42 minutes ago, MR.Farrarie said:

next time you better use 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.

[MR.Farrarie]

39 minutes ago, Amaroth 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.

 

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.

but with portable mysql

its like or having a repack

its easier and faster to move or share your server

but also your opinion is good

[piccolodmq]

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

[Amaroth]

worldserver.conf and authserver.conf store settings for connection to databases. F.e.:

LoginDatabaseInfo = "127.0.0.1;3307;trinity;trinity;medieval_auth"

[piccolodmq]

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

[Amaroth]

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.

[piccolodmq]

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.

[Amaroth]

Right now, you are attempting to connect to databases with login trinity and password trinity. So, assuming that you want to keep using this default setting...:

1. Does account "trinity" exist on your new MySQL server?
2. Does it really have password "trinity"?
3. Does it have full access rights on all databases and all tables in them (so global full access rights would be the best)
4. Can it connect from localhost?

If you have no clue how to even find out answers to these main questions, you need to learn something about creating and managing accounts and access rights on MySQL server. For now I can make this more simple for you with this script.:

GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0;

GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `auth` . * TO 'trinity'@'localhost' WITH GRANT OPTION;

 

PS: You have mentioned your admin root account, which is created during installation. I do not recommend using that account for anything else than setting up MySQL server - so mainly for creating first, nondefault account which will actually be used. Root should not be used for common editing of data, and it definitely should not be used for accessing databases from apps like TrinityCore.