zmref Posted February 10, 2013 Posted February 10, 2013 how to reset back the character records a.k.a. wipe out what do I delete in records? only chars? Quote
Brian Posted February 11, 2013 Posted February 11, 2013 Do you only want to keep login accounts? Then execute these queries to delete all other information: TRUNCATE TABLE `auction`; TRUNCATE TABLE `cart_inventory`; TRUNCATE TABLE `charlog`; TRUNCATE TABLE `char`; TRUNCATE TABLE `elemental`; TRUNCATE TABLE `friends`; TRUNCATE TABLE `global_reg_value`; TRUNCATE TABLE `guild_alliance`; TRUNCATE TABLE `guild_castle`; TRUNCATE TABLE `guild_expulsion`; TRUNCATE TABLE `guild_member`; TRUNCATE TABLE `guild_position`; TRUNCATE TABLE `guild_skill`; TRUNCATE TABLE `guild_storage`; TRUNCATE TABLE `guild`; TRUNCATE TABLE `homunculus`; TRUNCATE TABLE `hotkey`; TRUNCATE TABLE `interlog`; TRUNCATE TABLE `interreg`; TRUNCATE TABLE `inventory`; TRUNCATE TABLE `ipbanlist`; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mapreg`; TRUNCATE TABLE `memo`; TRUNCATE TABLE `mercenary_owner`; TRUNCATE TABLE `mercenary`; TRUNCATE TABLE `party`; TRUNCATE TABLE `pet`; TRUNCATE TABLE `quest`; TRUNCATE TABLE `ragsrvinfo`; TRUNCATE TABLE `sc_data`; TRUNCATE TABLE `skill_homunculus`; TRUNCATE TABLE `skill`; TRUNCATE TABLE `sstatus`; TRUNCATE TABLE `storage`; 3 1 Quote
0 diamondhole Posted June 4, 2020 Posted June 4, 2020 for those who are referring to this topic, please add TRUNCATE TABLE 'mail' TRUNCATE TABLE 'mail_attachments' Quote
0 Onairda Posted October 1, 2021 Posted October 1, 2021 Update -> Delete all except login table TRUNCATE TABLE `auction`; TRUNCATE TABLE `cart_inventory`; TRUNCATE TABLE `charlog`; TRUNCATE TABLE `char`; TRUNCATE TABLE `elemental`; TRUNCATE TABLE `friends`; TRUNCATE TABLE `acc_reg_num`; TRUNCATE TABLE `acc_reg_str`; TRUNCATE TABLE `guild_alliance`; TRUNCATE TABLE `guild_castle`; TRUNCATE TABLE `guild_expulsion`; TRUNCATE TABLE `guild_member`; TRUNCATE TABLE `guild_position`; TRUNCATE TABLE `guild_skill`; TRUNCATE TABLE `guild_storage`; TRUNCATE TABLE `guild`; TRUNCATE TABLE `homunculus`; TRUNCATE TABLE `hotkey`; TRUNCATE TABLE `interlog`; TRUNCATE TABLE `inventory`; TRUNCATE TABLE `ipbanlist`; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mapreg`; TRUNCATE TABLE `memo`; TRUNCATE TABLE `mercenary_owner`; TRUNCATE TABLE `mercenary`; TRUNCATE TABLE `party`; TRUNCATE TABLE `pet`; TRUNCATE TABLE `quest`; TRUNCATE TABLE `sc_data`; TRUNCATE TABLE `skill_homunculus`; TRUNCATE TABLE `skill`; TRUNCATE TABLE `storage`; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mail_attachments`; Quote
-1 Diconfrost VaNz Posted July 2, 2018 Posted July 2, 2018 (edited) Never mind it just happened I put something wrong Edited July 2, 2018 by Diconfrost VaNz Quote
Emistry Posted February 10, 2013 Posted February 10, 2013 clear / delete your database...and reimport new 1.. Quote
zmref Posted February 17, 2013 Author Posted February 17, 2013 ya thanks Brian no need to delete tables then insert a new one right? Quote
Brian Posted February 17, 2013 Posted February 17, 2013 Correct, TRUNCATE TABLE basically deletes all the rows in the table. It also resets AUTO_INCREMENT values to their start values. Quote
eboni001 Posted September 1, 2013 Posted September 1, 2013 (edited) Do you only want to keep login accounts? Then execute these queries to delete all other information: TRUNCATE TABLE `auction`; TRUNCATE TABLE `cart_inventory`; TRUNCATE TABLE `charlog`; TRUNCATE TABLE `char`; TRUNCATE TABLE `elemental`; TRUNCATE TABLE `friends`; TRUNCATE TABLE `global_reg_value`; TRUNCATE TABLE `guild_alliance`; TRUNCATE TABLE `guild_castle`; TRUNCATE TABLE `guild_expulsion`; TRUNCATE TABLE `guild_member`; TRUNCATE TABLE `guild_position`; TRUNCATE TABLE `guild_skill`; TRUNCATE TABLE `guild_storage`; TRUNCATE TABLE `guild`; TRUNCATE TABLE `homunculus`; TRUNCATE TABLE `hotkey`; TRUNCATE TABLE `interlog`; TRUNCATE TABLE `interreg`; TRUNCATE TABLE `inventory`; TRUNCATE TABLE `ipbanlist`; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mapreg`; TRUNCATE TABLE `memo`; TRUNCATE TABLE `mercenary_owner`; TRUNCATE TABLE `mercenary`; TRUNCATE TABLE `party`; TRUNCATE TABLE `pet`; TRUNCATE TABLE `quest`; TRUNCATE TABLE `ragsrvinfo`; TRUNCATE TABLE `sc_data`; TRUNCATE TABLE `skill_homunculus`; TRUNCATE TABLE `skill`; TRUNCATE TABLE `sstatus`; TRUNCATE TABLE `storage`; Hey @Brian this will only delete all items and chars of each account right? is like to reset all the accounts of the server but it wont delete any other files right? if this is like that can i ask how to run this table please? Edit: Solved, thank you this was awesome. Edited September 1, 2013 by eboni001 Quote
Question
zmref
how to reset back the character records a.k.a. wipe out what do I delete in records? only chars?
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.