Fixed 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

 

[zerohero]

up

 

[zerohero]

**"Hey everyone,
Today, with the help of my friend localhost, we tried to merge two databases, and I’d like to explain the process in case someone can help — not just me, but others who might be facing the same issue.


I had two databases. The first one was called lucera2, which was the main database used by the server — it stored account data, characters, items, etc. The second one was newx25, from which we wanted to transfer characters and items into the main database.


We uploaded newx25 as dst_db and set lucera2 as the src database. The merge process completed successfully without any errors, but in the end, the characters and items didn't appear in the main DB.


For context, I was running two GameServers — one using the lucera2 database and the other using newx25.


So the question is: what might have gone wrong? Is there something specific we need to check when merging characters or data between different packs or database structures?


Any help or insight would be greatly appreciated!"**

 

[Deazer]

Next time, include the error code. You're asking for help without specifics.

 

[zerohero]

Next time, include the error code. You're asking for help without specifics.

we fixed the error deazer and I write here that the transfer was successful but the characters do not exist in the same account

 

[Deazer]

we fixed the error deazer and I write here that the transfer was successful but the characters do not exist in the same account

It's all described in the guide, reread it. If the sum is greater than 7, the rest are transferred with a prefix.

 

[zerohero]

It's all described in the guide, reread it. If the sum is greater than 7, the rest are transferred with a prefix.

I have read 1 account on the main server, one account on the new server and the characters that are on the same account did not pass after the marge and there are only 2 one character that was on the main and one that was on the new when I do the marge I see only the new character

 

[Logan22]

If you can't solve the problem on your own, write to me after some time. I'm interested in creating such a script as a plugin for my CMS, and I’ll need you to check that all elements are transferred correctly.

 

[zerohero]

If you can't solve the problem on your own, write to me after some time. I'm interested in creating such a script as a plugin for my CMS, and I’ll need you to check that all elements are transferred correctly.

you all have to understand that this is a problem that we have to do for the whole forum because I am sure that several people have a problem or have tried and have not succeeded, we all do the process of the guide and after the marge when we enter the server we only see the characters that were on the new server

 

[zerohero]

@Deazer I have a common login, I have 2 databases, lucera2 and newx25, I do all the procedures, it's successful and it gives me another account, for example, in the old database I had a test and a char test, and now it gives me a new account test_1 char test_1

 

[zerohero]

@Deazer please tell us here how the players will know what account they should put in after the merge in order to find their old character? and also a lot of accounts that have more letters in the middle and I have to sit down and look for the accounts one by one, how can we avoid this problem

 

[GREIDER]

View attachment 6175

@Deazer please tell us here how the players will know what account they should put in after the merge in order to find their old character? and also a lot of accounts that have more letters in the middle and I have to sit down and look for the accounts one by one, how can we avoid this problem

Если столько проблем возникло при первом слиянии, то второе будет катастрофой))

 

[zerohero]

Если столько проблем возникло при первом слиянии, то второе будет катастрофой))

Yes, it’s true — it will be a big problem because, in my opinion, there are quite a few things that are wrong regarding the merge and things that need to change.