How do I combine login and char details from sql from old to new?

[Windy]

Hello everyone,

I noticed that both of my server database's account_id starts from 2000000 and char_id starts from 150000 in login and char table respectively.

Does changing the values of these two parameters and then exporting and re-import into new server works this way?

[Emistry]

On 6/21/2021 at 7:58 PM, Windy said:

I noticed that both of my server database's account_id starts from 2000000 and char_id starts from 150000 in login and char table respectively.

these are default value.

https://github.com/rathena/rathena/blob/master/sql-files/main.sql#L767

https://github.com/rathena/rathena/blob/master/sql-files/main.sql#L270

or you can manually adjust it

ALTER TABLE `login` AUTO_INCREMENT=1001;
ALTER TABLE `char` AUTO_INCREMENT=1001;

 

On 6/21/2021 at 7:58 PM, Windy said:

exporting and re-import

if you export the ID, then re-import it to a new database, it should stay the same.