How to refresh a server with Part2 on Final?

[managerlexx]

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

Gracia Part2
L2J Revision Number:2944
L2JDP Revision Number:5991

Gracia Final
L2J Revision Number:3071
L2JDP Revision Number:6133


Prompt how to refresh please a server with Gracia Part2 on Gracia Final?
So that there were all players, things, clans, and all the rest.

I tried to substitute simply files and to refresh a database, but it has turned out nothing. Likely I that have made that not so.: (

Can eat what that the instruction? Or tell.

In advance thanks for the help!

[lishawj]

I think I understand what you're asking but if I am wrong, please correct me. You have an older Gracia Part 2 server database and you want to transfer it to Gracia Final?

If this is what you want to do then I would suggest:

1) Dump your current L2JDB database into a file by using the following command:
mysqldump --all-databases -u root -p<password> > <database file>.sql

For example:
mysqldump --all-databases -u root -pSecret > L2JDB.sql

2) Check out the latest Gracia Final SVN and compile it.

3) Copy over your Config files from the previous Gracia Part 2 server to your new Gracia Final server. (Server.properties and any other config files you modified) You can also simply modified them over again if you want.

4) Create your new L2JDB database.

5) Dump the backup L2JDB.SQL file into the newly created database to populate the tables.
mysql -u root -pSecret L2JDB < L2JDB.SQL

This is basically an overview of one way to do it.

[managerlexx]

Yes thanks all of you have correctly understood Thanks.

As to refresh files I have understood and how to refresh the Database with old on new I have not understood:)

1. I have refreshed a server to the last version from SVN.
2. I have copied all configuration files.
3. I have started database_installer.sh and instead of complete installation (f) I have pressed to refresh (u).
4. After that I have started a server and was many errors and Characters did not start up in Game. (In login came and further is not present))

[lishawj]

Yes thanks all of you have correctly understood Thanks.

As to refresh files I have understood and how to refresh the Database with old on new I have not understood:)

1. I have refreshed a server to the last version from SVN.
2. I have copied all configuration files.
3. I have started database_installer.sh and instead of complete installation (f) I have pressed to refresh (u).
Do a full installation here so you have a fresh new database.

4. Now import/dump the backup database you made into the new database using the following command string.
mysql -u root -pYourPassword L2JDB < L2JDB.SQL

5. Run your server and you should not have missing player data, spawn data, etc.

If this is still hard for you to follow then I am not sure how else to help.

[managerlexx]

3. I have started database_installer.sh and instead of complete installation (f) I have pressed to refresh (u).
Do a full installation here so you have a fresh new database.

4. Now import/dump the backup database you made into the new database using the following command string.
mysql -u root -pYourPassword L2JDB < L2JDB.SQL

3. It you about installation Gracia Final?
4. When I try to import gracia_part2.sql to database Gracia Final, produces an error that such tables already are




For me it is not difficult to merge a dump or to copy files:)

Has put at all in it.

I cannot understand as to refresh database Gracia Part2 to Gracia Final without loss of the data.

For me on Gracia Part2 played many people and I do not want that from for transition on Gracia Final they have left:)

And so we will return to our rams:

1. I have database Gracia Part2 (in it many data which cannot be deleted)
2. I have a file part of a server (a folder gameserver/loginserver and another)
3. I download the last version Gracia Fina from SVN and I compile it
4. I copy all files from Gracia Final (folders gameserver/loginserver and another) in folder Gracia Part2
5. I start \gracia_final\tools\database_installer.sh
6. I select database Gracia Part2 and I press to "UPDATE" (u)

I so understand it and there is correct a transition to new Chronicles?

[janiii]

6. I select database Gracia Part2 and I press to "UPDATE" (u)

after that there should be one more step, or? where you can choose if the update should be automatic for the changed table structures..

[managerlexx]

Probably we do not understand each other))

I cannot understand as me to refresh my old database - Gracia_Part2 on new Gracia Final?
I should make what operations?

[Bruteforce]

Isn't it so, that if you import the .sql files manually, they will dump and make a fresh installation of the tables that are not user-based, like the etcitems and weapons tables and such, but if you do it with for instance items or accounts tables, it will NOT make a fresh installation, but just quit since it's allready existing?

So, if you first run the .sql files in the updates-folder, then go through every single .sql file, and import them, it will be updated correctly?

I wouldn't want to do this automatically you see!

[managerlexx]

For me it has turned out ))))))))))))

Thanks All who has helped ))

The problem is solved !

The theme is closed ))))