[Errors] I don't understand?

[seridium]

Well I have altered 5 zones with custom loot tables for every mob in featured zones, server quests, over 25 custom items, and I really don't want to do it all over again it seems the only issue I am having is with the items not laoding.


My DB is 070_pop_cvs I sourced the peqdb_1129Rev291.sql then the updates after installing emu added quests etc.

then I decided to update by sourcing the new peqdb_1129Rev333.sql and all updates, I figured I Could add all my custom db data by sourcing these files I extracted.

Files I extracted with NAvicat from my working server tables:
Account.sql
character_.sql
character_backup.sql
character_Activities.sql
character_enablestasks.sql
character_tasks.sql
inventory.sql
items-0.6.0-DR2-0.6.1-DR1-convert.sql
lootdrop.sql
lootdrop_entries.sql
lootable.sql
lootable_entries.sql
variables.sql
zone.sql

I did also make a backup of all tables in one file. so I could just source and make it back to normal.

But after trying to source character_.sql and getting an error I figured ok I will just make a sql file with what i needed into one file so I added the above files into one .sql instead of individual files and it seemed to put all my Character info back into effect levels zone flags etc were all good except the Item error?

I can re source the peqdb_1129Rev333.sql and it loads fine no errors but no items I made either :(

__________________________________________________ ______________

I am testing this on a second pc with the same server setup as the one I am running, I am doing this to avoid server downtime so its not like my server is all screwed or nothing but it would be nice to not have to make all my items all over again or my zone changes etc.

[trevius]

To get the items you had before, you would need to source your old database again (you can even do it into a new database name so you don't have to delete the one you have now), then, run the update that I posted above to adjust the items table so it is compatible with current DBs. Then, just dump the items table alone to sql. Last, just source that items sql file you made into your existing database. It should now be updated with the new field change and be compatible with the new items table adjustment.

[seridium]

Thanks for the info trevius but I am not sure how to run that update?

I cant find a rev292 update in the updates folder I just downloaded the peq_db too.

[seridium]

Originally Posted by seridium

Thanks for the info trevius but I am not sure how to run that update?

I cant find a rev292 update in the updates folder I just downloaded the peq_db too.

Ok I get it make a notepad file with info you posted and renamed it .sql sourced it trying now Thanks man...

[seridium]

OK I have one last question regarding this matter.

Ok on my working server that is all working order atm, what would happen to my accounts characters items etc if I just updated with peqdb_1129Rev333.sql? does that delete all my server db info ?

[trevius]

Yes, if you run any SQL updates that update full tables (like I think those do), they will delete the current table completely, rebuild the table and fill it from scratch.

[seridium]

Well I tried to source the DB mentioned on the running server and I got a mysql disconnect error and now it wont connect to mysql fun fun

[Iwasseridium]

Well I am still having this problem can anyone help???


Why would mysql get syntaxx errors during installation of peqdb_1129Rev333.sql was there an error with this update???