Worldofjimmy Posted August 16, 2019 Posted August 16, 2019 Hello, Â MYSQL for player database. Â How does database cleanup work when deleting a character? Deleting a character from the client it seems to automatically clean the database. Â How would I correctly delete a character with a mysql query? Do I have to locate all the rows related to the character? Â Thanks in advance Â
0 jcsnider Posted August 16, 2019 Posted August 16, 2019 You should wait until the functionality is safely provided through the Servers API. Editing the DB directly while the server is running will cause your server to crash.  But yes, you'd just locate all rows with the character id of the one your're deleting and remove them.Â
0 Worldofjimmy Posted August 16, 2019 Author Posted August 16, 2019 Thanks @jcsnider for the explanation, Okay I understand, I'll wait for the Servers API  Â
Question
Worldofjimmy
Hello,
Â
MYSQL for player database.
Â
How does database cleanup work when deleting a character?
Deleting a character from the client it seems to automatically clean the database.
Â
How would I correctly delete a character with a mysql query? Do I have to locate all the rows related to the character?
Â
Thanks in advance
Â
2 answers to this question
Recommended Posts