Looking Problem with SQL Merge – Need Help

[zerohero]

Hello everyone,


I know many people have faced the same issue as me regarding database merging. I’m aware that there is an official guide from Lucera, but unfortunately, I’m encountering errors during the process and would really appreciate any help from someone who’s familiar with it.


Here’s my situation step-by-step:


I have two servers: one main and one new.

• The database for the main server is named: lucera2
• The database for the new server is named: newx25

All accounts are saved in the lucera2 database, and my goal is to merge the newx25 database into lucera2, which is my main database.


The steps I follow are:

1. I create two new databases: src_db and dst_db
2. I import the main server backup into dst_db
3. I import the new server (newx25) backup into src_db
4. I go into the game server folder where the sql_merge tool is located and follow the exact steps from Lucera’s official video guide.

This is where the problem starts: I get an error and the process cannot be completed.


If anyone has experience with this merging process, I’d be very grateful if you could help me figure out what’s going wrong or what I might be missing.


Thanks in advance for your time and support!

 

[localhost]

use mysql cli for merge

 

[zerohero]

use mysql cli for merge

I have done it, friend, but I have errors

 

[localhost]

I have done it, friend, but I have errors

have log?

 

[zerohero]

hello yes I'll get back to you in a bit