Server wipe/rollback

[Gabber]

Hello everyone,

I'm creating l2j server and I'll put it on open beta test. After it I want to wipe the server but I want all my made changes to remain the same, except players data, and I want my server to start from beginning how it was on first launch.

If you understood what I meant, please help me )))

[MELERIX]

restore your backup, thats all.

[Gabber]

Is this backup made automatically (if yes, where?) or I have to make it manually (if yes, how?)

[MELERIX]

Is this backup made automatically (if yes, where?)

yes, by database_installer, in tools folder

or I have to make it manually (if yes, how?)

well, if you are an admin you should have at least a "basic knowledge" about how make a backup manually, other way use google xD

[Gabber]

I just have basic knowledge in java programming. Other things are pretty much trees in the forest

[Gabber]

So I need to do full database install ? And everything what players made will be deleted including them ?

[blarke]

Easier if you just drop and recreate your whole "characters" and "accounts" table since the server will clean up most of the junk upon the next backup. However, it will leave many things in (ie. items in the item tables) that are not connected to any characters after that which may impact performance.
Basically if you are doing any modifications on your DB, you will very likely do it on the custom tables anyway, so wiping and rebuilding the DB should suffice...

And by the way, this has nothing to do with java knowledge.

cheers

[MELERIX]

So I need to do full database install ? And everything what players made will be deleted including them ?

if you want to wipe and reset your whole db, yes, full install will delete and import new clean tables

[Gabber]

Ok for example:

Some hackers hacked my server and spawned some raid bosses in server. How do I do a rollback to exact date?

[MELERIX]

restoring a backup from that day (if you have one ofc)

[Gabber]

And that backup would be manually made by raring server folder ofc? ))

[blacksea]

And that backup would be manually made by raring server folder ofc? ))

only db you need... server folders you have them in your pc..

to create backup
mysqldump -u root -p database_name > blabla.sql

to restore your backup
mysql -u root -p database_name < blabla.sql

[Gabber]

Maybe this file gs_backup.sql in tools folder has all the db information?

I just execute this sql after delete all l2jgs tables in Navicat and my backup is good to go ?

And do I need to do database upgrade or full install ?