Wiping all except Char and Login?

[Gouki]

How do you wipe all data except for Char and Login?

I tried exporting a clean main.sql > removing Char / Login > uploading the back up Char and Login.

but when you login ingame it says, SQL error contact administrator..

[brunorhis]

 Hello, first of all perform a security backup <<<THIS IS VERY IMPORTANT

after that run the following commands to wipe all data excep accounts:

TRUNCATE TABLE `auction`;
TRUNCATE TABLE `cart_inventory`;
TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
TRUNCATE TABLE `elemental`;
TRUNCATE TABLE `friends`;
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`;

 

if you wish not to delete the characters remove

TRUNCATE TABLE `charlog`;
TRUNCATE TABLE `char`;
 before running the commands.