3

My question is, how do I transfer my characters from one Azerothcore docker setup to an Azerothcore Bash Dashboard server?

From: Azerothcore (Docker) Ubuntu 20.10 Docker Mysql 5.7

To: Azerothcore (Bash Dashboard) Ubuntu 20.10 MySQL 8.0

I'm assuming this will have to be a MySQL copy and insert task. If so, what is the simplest way of doing this? And there are characters on both MySQL databases to consider. Thank you all for your consideration on this matter! -Lynn

Lynn McCargar
  • 31
  • 4

2 Answers2

0

You just need to back up your acore_auth and acore_characters databases and import them into the new server.

Francesco Borzi
  • 56,083
  • 47
  • 179
  • 252
  • So you're saying I can merge the acore_auth and acore_characters from the docker build without overwriting my the existing acore_auth and acore_character databases on bash/mysql 8.0 build? – Lynn McCargar Apr 30 '21 at 19:25
  • I did the mysql export on the docker build acore_auth and acore_characters databases and imported to the bash build and got a can't run sql statement error when trying to launch the auth database. The differences are mysql 5.7 and mysql 8.0 and different passwords for mysql root. Got anymore ideas? – Lynn McCargar May 01 '21 at 03:14
  • not sure what you meant but maybe this helps you: this is merely an issue about exporting two MySQL databases and importing them in a different location, you can find plenty of tutorial on the web to do so – Francesco Borzi May 01 '21 at 18:09
  • Hi Francesco, I do appreciate you for trying to help me, thank you! And I do agree with you about searching online tutorials to help me understand the basics of the technology I'm working with. And I have taken your advise and have discovered my issue is more complex than I initially expected. – Lynn McCargar May 05 '21 at 04:06
  • My first azerothcore build was with docker/mysql 5.7. Then I installed the new azerothecore bash on mysql 8.0. What I noticed was the account table had a different datasets between mysql 5.7 and mysql 8.0. And when I tried to simply overlay/overwrite those databases, the azerothcore code was a mismatch practically with the mysql_stmt_prepare() function. – Lynn McCargar May 05 '21 at 04:07
  • @LynnMcCargar are those 2 databases using the exact same AC version? – Francesco Borzi May 05 '21 at 08:35
  • The ac bash dashboard build is the current version 3.0. The ac docker build I think its version 2.0, I build this ac build back in early December 2020. When I run a mysql query on both account tables, they have different data types and column. Ex: account table on docker mysql 5.7 uses sha_pass_hash with datatype varchar(40). The account table on the new dashboard build, ac3.0, mysql 8.0.23, uses salt with a datatype binary(32). – Lynn McCargar May 05 '21 at 16:57
  • I going to try to cross join the two ac databases, this is the only way I think it might work. I got the idea from, https://stackoverflow.com/questions/13620554/how-to-join-2-tables-without-common-column/13620617#13620617 I'll post about the result after I finish. – Lynn McCargar May 05 '21 at 19:40
0

If you only have a few characters to move, the pdump command should do the trick. It's about halfway down the GM Commands Page on the AzerothCore Wiki

Duncan Steenburgh
  • 1
  • 1