Jump to content
  • 0

how to update database without closing server


mansanalchamp

Question


  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.01
  • Content Count:  30
  • Reputation:   1
  • Joined:  04/20/20
  • Last Seen:  

could you help me please

How do i update database (phpmymin) without closing the rathena server

thank you.

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  50
  • Topics Per Day:  0.01
  • Content Count:  1702
  • Reputation:   238
  • Joined:  09/05/12
  • Last Seen:  

What are you updating in the database? If you are updating by providing DML (insert,update,delete) statements then there's no need to restart rAthena

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  215
  • Reputation:   45
  • Joined:  05/03/13
  • Last Seen:  

Just for information, I don't have a list (and maybe it changed and i'm wrong?) but some info can't be edited whithout restarting like guild name, and editing inventory ect live can make some weird behaviour too.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.01
  • Content Count:  30
  • Reputation:   1
  • Joined:  04/20/20
  • Last Seen:  

16 hours ago, Kreustoo said:

Just for information, I don't have a list (and maybe it changed and i'm wrong?) but some info can't be edited whithout restarting like guild name, and editing inventory ect live can make some weird behaviour too.

Sory, if information 

example 

when i edit user_id and password in login DB on my web browser i not restart server

but when i edit insert or updeate item_cash_shop DB I must restart server

So, please help me 

I must not restart server when i edit insert or update table item_cash_db 

 

thx so much 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  215
  • Reputation:   45
  • Joined:  05/03/13
  • Last Seen:  

cash_db, you can just reloaditemdb (and if you use the button on the client, disconnect/reconnect)

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...