EQEmulator Forums - MySQL Issues. Yes, I RTFM. and then I read the manual.

WinXP
1.8Ghz P4, 512MB RAM.
EQEmu 0.4.0.1
MySQL 3.23.53
MiniLogin Server Only

Can't seem to get the database linked - not sure if
1. World.exe isn't seeing the database correctly or
2. I don't have the database 'eq' set up correctly in MySQL.

I deleted my.ini, reinstalled MySQL, and started from scratch again:
1. Put in Username and Password.
2. Fired up mysql.exe.
3. Typed: "create database eq;" (Query OK, etc.)
4. Typed: "use eq;" (Database changed)
5. Typed: "source db.sql;" (Query OK ... scroll scroll scroll ... no errors tho)
6. Typed: "exit;"

Then I changed my db.ini to say:

[Database]
host=localhost
user=username
password=password
database=eq

I then had to add the eqemu user in through world.exe to prevent 1017 errors:
(C:\eqemu\> world adduser eqemu eqemu 200)

I can log on, create a character, find/cast spells, #level, #zone, all the other commands, but when I #search (foo), I always get 0 items found.

My question is this: do I need to do anything else than copy db.sql and "source db.sql;" it in order for 0.4.0.1 to work? If so, what and how do I do it? What is this DB-AddOn I keep reading about? I just downloaded this tonight ...

Thanks in Advance for your time.

edit: thought I should add:
When I run "status" from mysql.exe shell, here are the results:

Connection id: 2
Current database:
Current user: ODBC@localhost
Server version: 3.23.53-max-nt
Protocal version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
Uptime: 10 sec

(this was after reboot: the 2 things that trouble me are that the current database field is blank, and that the user is ODBC, not my username - do I have to manually "log on" to MySQL, tell it to "use eq;" every time?)

HiDef
- - - - - -
P.S. Amazing software job on this, it's tremendous.