Wipeout Accounts?

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

Thanks !

UP

[Snap]

How can i run that?

[Brian]

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

[Brian]

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.

[Snap]

But it says click one tab.