DB set up

[Disorder]

Greetings! Thanks for the help thus far!

Still attempting to set up a server using Huppy's skeleton. I say skeleton, not due to his writing, just because so much has changed.

http://www.eqemulator.org/forums/showthread.php?t=32980

I'm stuck again.

16. When you open Navicat, double click on the localhost_3306 name and double click on the
peq name. Then right click on the peq name and choose "Execute SQL File"

In the window that pops up, click on the little square with 3 dots [...] to navigate to
the following folder(on your C-Drive: /source/trunk/EQEmuServer/utils/sql/svn/
*Note*
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.

The reason your doing this, is because, even after a new database revision is out, all
the updates developed after that, need to be sourced in. In this case, when the rev1751
was sent out, (after the 1667), not all updates were applied to the release.
I know it leaves more work for us "end users", but what the heck, it's free

***WARNING*** - You may run in to errors on some of the updates, (I ignored some), but
there is one you can not ignore: 1711_account_restricted_aa.sql
YOU NEED THIS UPDATE for your server to create accounts without errors.
If you get an error when sourcing that in, you can do this to help it along:

Open the 1711 file with Notepad++ and remove the first line (there is 3)
After removing that line, run the update again.
I CAN NOT help you with all the errors from the updates, but just search the forums for
any others.

Obviously rev1752 is outdated. The svn came with rev2294, which is what I used. Do I need to do every file from 1711-2428?

I'm so new to this, it isn't even funny. It appears that these files are sort of.. Mods.. to the DB that people have made. Some are required some are not. I'm just confused as to what it is I am actually doing and what I need to be doing since this guide is old.

Thanks for your time!

[lerxst2112]

Every required update above 2294 and any optional updates you want to use.

[Disorder]

Thanks for the quick response.

I shall give it a try.