Jump to content
The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades. ×
  • 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:   241
  • 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:  216
  • 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:  216
  • 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...