[HELP] Change db ,but without wipe
hi there,we are running an interlude server l2j-free now its currently down because we changed the db with a new one latest revision l2archid :L2J-Archid_revision_307
we get this error when we try to execute the file l2jdb.sql "i think we use this for trasnfer accounts items etc"
[Err] 1050 - Table 'account_data' already exists
[Msg] Finished - Unsuccessfully
the sql file in front of every line says:ex:CREATE TABLE account_data etc etc i think i have to edit the file to say: REPLACE TABLE account_data...etc etc
but should i replace all tables? or just the first one?
we have an other one problem we are trying to set the gm-access levels coz its different from the last pack can we transfer this settings?>somehow ? thanks in advance
Re: [HELP] Change db ,but without wipe
try with: DROP TABLE IF EXISTS `name`; CREATE TABLE `name`
Re: [HELP] Change db ,but without wipe
ty but is there any way to replace all lines auto ? or i have to make it manualy>? about the "names"
different name every time
Re: [HELP] Change db ,but without wipe
Re: [HELP] Change db ,but without wipe
thnx for the help i am on "translation" of sql file before your posts i tried to make reaplce to all tables but i get an error on the first table i hope this error is because i maked the lines like that: REPLACE TABLE "name" here is the error :[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `account_data` (
`account_name` varchar(45) NOT NULL default '',
`var`' at line 14
[Msg] Finished - Unsuccessfully
i dont want this error come up after the DROP TABLE etc...
btw i use mysql version 5.0
Re: [HELP] Change db ,but without wipe
you can also go to l2jtools section to read the guide