Page 1 of 1
How do i make a wipe?
Posted: Sat Oct 30, 2010 4:31 pm
by davide874
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!
Re: How do i make a wipe?
Posted: Sat Oct 30, 2010 4:34 pm
by K4N4BS
Delete all tables, files, etc...
And install everything again.
Re: How do i make a wipe?
Posted: Sat Oct 30, 2010 4:44 pm
by davide874
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
Re: How do i make a wipe?
Posted: Sat Oct 30, 2010 4:57 pm
by ZaKaX
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.
Re: How do i make a wipe?
Posted: Sat Oct 30, 2010 5:05 pm
by Probe
theoritically, if you wipe characters table gameserver will delete all other data
Re: How do i make a wipe?
Posted: Sat Oct 30, 2010 5:11 pm
by SolidSnake
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..
Re: How do i make a wipe?
Posted: Sat Oct 30, 2010 5:22 pm
by Probe
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
Re: How do i make a wipe?
Posted: Sun Oct 31, 2010 9:49 am
by davide874
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
Re: How do i make a wipe?
Posted: Sun Oct 31, 2010 12:37 pm
by Probe
l2j doesn't use foreign keys at all xD
Re: How do i make a wipe?
Posted: Sun Oct 31, 2010 1:10 pm
by _DS_
Actually, l2j does not need foreign keys
Re: How do i make a wipe?
Posted: Sun Oct 31, 2010 2:32 pm
by Probe
_DS_ wrote:Actually, l2j does not need foreign keys
if it used them idfactory clean up wouldn't be necessary