Jump to content
  • 0

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


Windy

Question


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  17
  • Reputation:   0
  • Joined:  04/01/21
  • Last Seen:  

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?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...