help with mysql 3.23.53

Geniaan · #1 10-27-2002, 01:26 PM

Hey, i just downloaded mysql 3.23.53 and tried to create a database and all that pops up is the flush commands. Ive tried reinstalling a few times and still nothing. I had the eqemu working before with a different version of mysql. Oh, im using Windows Me p4 1400mhz 128mb ram. Thanks

Lurker_005 · #2 10-27-2002, 02:11 PM

http://forums.eqemu.net/showthread.p...;threadid=3847

Check what is different from the posted screen shot. Is your stop light green? Perhaps try this http://forums.eqemu.net/showthread.p...;threadid=1169 although I thought winmysqladmin was using the root login...

I don't know what all these people are doing that they aren't seeing the option to create a database. If someone figures it out, please post it. I know there are other ways around this problem, but lets please get a solution for this.

Geniaan · #3 10-27-2002, 02:32 PM

Thanks image i did this before with other mysql just thought you had to do it only once.

DeletedUser · #4 10-27-2002, 02:53 PM

*confused*

Trumpcard · #5 10-27-2002, 03:03 PM

If you ever run into this problem, just do
it manually, it's not hard..

open a command window (cmd)

then,
cd c:\mysql\bin
mysqladmin create eq

Boom, you now have an eq database. Source in your files per the readme...

Geniaan · #6 10-27-2002, 03:04 PM

Tried the grant all privileges and it did the 1 row affected but still nowhere to create database.

Geniaan · #7 10-27-2002, 03:21 PM

Now world boots up without errors but boot5zones get error in emusharemem.dll

Xarslik · #8 10-28-2002, 01:29 AM

What's the error message you're getting now?

tamarae · #9 10-28-2002, 02:14 AM

I had the same problems when creating the database. Here's a quick HowTo for mysql.

Start with the README file steps.. when you get to the part about setting up the database, follow steps below:

Use Winmysyqladmin.exe to create the name/password, then minimize it.

Copy db.sql and dbupdate.sql to your c:\mysql\bin directory. (provided you installed mysql in the default location)

Run mysql.exe. Type:

create database eq; [Enter]
use eq; [Enter]
source db.sql; [Enter]
source dbupdate.sql; [Enter]

Here is a good place to install the 3.6 addon and the 3.9 update if you're going to as well while you're at it. When done, type:

exit [Enter]

Continue from here with the README steps.

meshgiath · #10 10-28-2002, 04:32 AM

I'm getting the same error with EMuShareMem.dll . Everything else loads fine, but once boot5zones begins, I get a "zone.exe" error, and the tech report refers to EMuShareMem.dll. Each zone window shuts down with this error...

WinXP pro, AthTbird1400, 512, 100gb, Audigy, Radeon8k

Godspeed
Meshgiath

tamarae · #11 10-28-2002, 05:06 AM

What's different, Lurker, is when you right click to get the menu you show in the screen shot, there are only the 4 flush options, the create database option does not appear no matter if you right click on your host name or anywhere else in the window. I worked around it by doing it from the mysql command line, as I posted above. :(

Got my server up and running yesterday and having a blast checking it all out.. woohoo!

I had the same issues that are listed here with the zone servers crashing with the windows error... until... the newest release of the emu was released and I installed it clean, updated my client, sourced db.sql, dbupdate.sql, installed the 3.6 and 3.9 addon dbases.. Runs like a dream now. Perhaps this info will be of a slight bit of use. I do agree that its a database issue of some sort.

meshgiath · #12 10-28-2002, 07:02 PM

Same ol same ol here....

looks like it's having trouble loading NPC types... I uninstalled, reinstalled fresh, re sourced everything to a "T" and still same error =-\

Geniaan · #13 10-28-2002, 08:49 PM

All you gotta do is download the db.sql addon then source it and itll fix it