L2J Server

Posted: **Tue Aug 25, 2009 3:23 pm**

how to transfer SQL database(dump and backup saved), from crashed server

L2J Revision 3349: - no vitality system
L2JDP Revision 6457:

to new revisions with vitality system like:

L2J Revision 3425: - with vitality system
L2JDP Revision 6519:

to avoid errors like " Unknown column 'vitality_points' in 'field list' . Thanks in advise.

Posted: **Tue Aug 25, 2009 3:24 pm**

http://www.l2jdp.com/trac/browser/trunk ... l?rev=6515

Code: Select all

ALTER TABLE `characters` ADD `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER `bookmarkslot`;

Posted: **Tue Aug 25, 2009 3:36 pm**

janii you are like a flash

- it works prefect

super big thanks, gl

L2J Server

SQL base from non-vitality to vitality Releases ?

SQL base from non-vitality to vitality Releases ?

Re: SQL base from non-vitality to vitality Releases ?

Re: SQL base from non-vitality to vitality Releases ?