Updating Databases

[13ack.Stab]

Hi.

I'm sorry if this is a dumb question, but how do I update my databases to the latest version? So that the Sunwell is spawned, the loot tables are updated with the newest T6 pieces (and Sunwell drops), etc?

Also, how do I update my ascent core to be the latest version?

Thanks a bunch.

[TheSpidey]

With the core, just compile the newest revision from the SVN and copy over the binaries to your old server folder.

Database; If you have custom stuff you want to keep, that's a bit tricky. I believe SQLyog has a feature to merge DBs, try that. If you don't have any custom stuff just place the new DB in place of the old one

[13ack.Stab]

How would I go about compiling the newest revision? I got the files from the SVN. I see four folders now: branches, tags, trunk, and udb.

Thanks!

[soul02]

http://www.mmowned.com/forums/emulat...-included.html

[13ack.Stab]

Okay, so I got everything to work.

When I create a character, though, it instantly disconnects me from the server. What's up?

I believe I messed up in my database somewhere when I updated. Where can I find an up-to-date database (preferably one that contains logon, world, character, etc in it)?

Thanks!

[TheSpidey]

Take a look at the console when you try to create a char, it would probably complain about column count mismatch. You need to update your characters table, you can find the update in the trunk\sql folder

[13ack.Stab]

Nope, the console says absolutely nothing. Its kind of irritating.

I've noticed that every field in every single table (except for account, because I filled that in) in my database is null.

[thijsd]

Try to get a database, that someone made (don't know how to call it ). There are a lot of difference betwean them. So please search the forum for them

[13ack.Stab]

Which file is my actual database? C:\Ascent_Files\Database\Database\sql\world.sql?

I only have one file in that folder, since my world database contains the world, character, and logon databases. How would I go about replacing this if I cannot find another all-in-one database?

[Power of Illuminati]

You are supposed to execute the world.sql into a database editor, like Navicat Lite. But you need MySQL first

[13ack.Stab]

I understand that. I've had mysql and navicat for quite a while, and I had a private server up and running for quite over a month. Then I decided to implement boss scripts. I confused myself, and decided that I needed to update my ascent core (which I did) and my database (which I am having trouble doing).

My question is this: Where can I get a new world.sql file to update my database with, and since my server's logon and character databases are within the world database, will I have problems if I just replace my world.sql? Thanks.

[13ack.Stab]

Bumpershnitzle.