How do i make a wipe?

davide874 · Post by **davide874** » Sat Oct 30, 2010 4:31 pm

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

hi everyone,

i wanted to ask how to make a professional wipe without incurring in errors. I know that i need to delete all tables like character,accounts etc but i'd like to be sure to delete all the needed one.

Can someone give me a list of all the tables i need to delete? (Freya l2j ofc)

Thanks so much!

K4N4BS · Post by **K4N4BS** » Sat Oct 30, 2010 4:34 pm

Delete all tables, files, etc...
And install everything again.

davide874 · Post by **davide874** » Sat Oct 30, 2010 4:44 pm

K4N4BS wrote:Delete all tables, files, etc...
And install everything again.

nono...i wanna wipe onyl characters. I have all my custom things in the server that i don't wanna lose...
I only need the list of tables to empty so that the server is "clean" etcept my custom drop, spawn, mobs etc

Post by **ZaKaX** » Sat Oct 30, 2010 4:57 pm

Do some re-search, you could for example do a fresh installation of the L2J Database on a second and temporary database, then check which tables on the old database has more entries than on the fresh one. You'll also have to reset several tables content to default values. (castles owners and such, for example...)

It's not that hard, you can do it! If you don't manage then get back to us, but I believe you will.

Probe · Post by **Probe** » Sat Oct 30, 2010 5:05 pm

theoritically, if you wipe characters table gameserver will delete all other data

SolidSnake · Post by **SolidSnake** » Sat Oct 30, 2010 5:11 pm

First make a backup of database, then delete and reinstall these tables:

account_data
accounts
airships
auction_bid
auction_lots
auction_watch
augmentations
characters
clan_data
couples
cursed_weapons
heroes
heroes_diary
items
kamaloka
messages
mods_wedding
olympiad_data
olympiad_fights
olympiad_nobles
olympiad_nobles_eom
petitions
pets
record
seven_signs
seven_signs_status
siege_clans
territory_registrations

Other characters/castle tables should be cleaned automatically..

Probe · Post by **Probe** » Sat Oct 30, 2010 5:22 pm

Not true,
wiping characters + clans tables pretty much makes idfactory wipe all other tables

however l2j is missing wipe of fort\territory related tables, and mail cleanup

davide874 · Post by **davide874** » Sun Oct 31, 2010 9:49 am

SolidSnake wrote:First make a backup of database, then delete and reinstall these tables:

account_data

accounts

airships

auction_bid

auction_lots

auction_watch

augmentations

characters

clan_data

couples

cursed_weapons

heroes

heroes_diary

items

kamaloka

messages

mods_wedding

olympiad_data

olympiad_fights

olympiad_nobles

olympiad_nobles_eom

petitions

pets

record

seven_signs

seven_signs_status

siege_clans

territory_registrations
Other characters/castle tables should be cleaned automatically..

Thank you. Isaw, unfortunately, that most of the table doesn't have a policy "ON DELETE" and lot of tables misses proper foreign key...

I'll try my best

Probe · Post by **Probe** » Sun Oct 31, 2010 12:37 pm

l2j doesn't use foreign keys at all xD

Post by **_DS_** » Sun Oct 31, 2010 1:10 pm

Actually, l2j does not need foreign keys

Probe · Post by **Probe** » Sun Oct 31, 2010 2:32 pm

_DS_ wrote:Actually, l2j does not need foreign keys

if it used them idfactory clean up wouldn't be necessary

L2J Server

How do i make a wipe?

How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?

Re: How do i make a wipe?