Wiping the db

[ghazul]

Hey there,

I'm currently trying to get an overview about the sql db. Could someone tell me what exactly do I have to do to do a full wipe (which things to delete/change) please?

Basically I wanna wipe the saves (chars, inventory, storage, carts, etc) but keep the accounts, so it's like a clean db installation except for the accounts.

Thanks in advance.

[SilverMayCry]

TRUNCATE cart_inventory;

just get the table names except the login.

do this for others you can list it and run it as a single query.

cart_inventory, inventory, storage, char.

Edited April 28, 2012 by silver118

[Brian]

This (below) will truncate all tables except `login`, and the item/mob tables.

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

[ghazul]

Thank you very much. Just what I needed