Snap Posted April 14, 2012 Group: Members Topic Count: 64 Topics Per Day: 0.01 Content Count: 186 Reputation: 0 Joined: 04/07/12 Last Seen: May 18, 2012 Share Posted April 14, 2012 How can i wipeout the accounts / characters of my server without bothering my dbs? I mean, Only ACCOUNTS AND CHARACTERS Will Wipe out? I am Using SQL [ phpMyAdmin Since i just hosted my server to bluesky. Thanks ! UP Quote Link to comment Share on other sites More sharing options...
1 Snap Posted April 15, 2012 Group: Members Topic Count: 64 Topics Per Day: 0.01 Content Count: 186 Reputation: 0 Joined: 04/07/12 Last Seen: May 18, 2012 Author Share Posted April 15, 2012 How can i run that? Quote Link to comment Share on other sites More sharing options...
Brian Posted April 14, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted April 14, 2012 (edited) I mean, Only ACCOUNTS AND CHARACTERS Will Wipe out? Accounts & characters pretty much includes everything. What DO you want to keep? To empty all SQL tables except item/mob databases, run these queries: TRUNCATE TABLE `auction`; TRUNCATE TABLE `cart_inventory`; TRUNCATE TABLE `char`; ALTER TABLE `char` AUTO_INCREMENT=150000; TRUNCATE TABLE `charlog`; TRUNCATE TABLE `friends`; TRUNCATE TABLE `global_reg_value`; TRUNCATE TABLE `guild`; 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 `homunculus`; TRUNCATE TABLE `hotkey`; TRUNCATE TABLE `interlog`; TRUNCATE TABLE `inventory`; TRUNCATE TABLE `ipbanlist`; TRUNCATE TABLE `login`; ALTER TABLE `login` AUTO_INCREMENT=2000000; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mapreg`; TRUNCATE TABLE `memo`; TRUNCATE TABLE `mercenary`; TRUNCATE TABLE `mercenary_owner`; TRUNCATE TABLE `party`; TRUNCATE TABLE `pet`; TRUNCATE TABLE `quest`; TRUNCATE TABLE `ragsrvinfo`; TRUNCATE TABLE `sc_data`; TRUNCATE TABLE `skill`; TRUNCATE TABLE `skill_homunculus`; TRUNCATE TABLE `sstatus`; TRUNCATE TABLE `storage`; Edited April 14, 2012 by Brian Quote Link to comment Share on other sites More sharing options...
Brian Posted April 15, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted April 15, 2012 I am Using SQL [ phpMyAdmin Since i just hosted my server to bluesky. Click the button that says "SQL" which opens a query window. Copy-paste those SQL queries and click Go. Quote Link to comment Share on other sites More sharing options...
Snap Posted April 15, 2012 Group: Members Topic Count: 64 Topics Per Day: 0.01 Content Count: 186 Reputation: 0 Joined: 04/07/12 Last Seen: May 18, 2012 Author Share Posted April 15, 2012 But it says click one tab. Quote Link to comment Share on other sites More sharing options...
Question
Snap
How can i wipeout the accounts / characters of my server without bothering my dbs?
I mean, Only ACCOUNTS AND CHARACTERS Will Wipe out?
I am Using SQL [ phpMyAdmin Since i just hosted my server to bluesky.![:)](https://rathena.org/board/uploads/emoticons/default_smile.png)
Thanks !
UP
Link to comment
Share on other sites
4 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.