Jump to content
  • 0

Question

Posted

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.

3 answers to this question

Recommended Posts

Posted (edited)

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 by silver118
Posted

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`;

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...