EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   errors on World and Zone5boot... (https://www.eqemulator.org/forums/showthread.php?t=1272)

Shawn319 04-18-2002 05:17 PM

Most people can close Winmysqladmin completely and still be able to connect (it keeps mysql-nt.exe in Windows Processes).

Re-run winmysqladmin.exe, minimize it then try again.. i will fix the readme.

Shawn319 04-18-2002 05:23 PM

Also, there's a post about 2006 error on the top of this forum.

ibleet 04-19-2002 02:26 AM

Hmmmm....why are we constantly reprinting info from the readme.txt file in these forums? I'm not gonna answer that question because the majority of us already know. /bonk anyone who doesn't use the readme. That is your first line of tech support.

_____________________
Ibleet

ibleet 04-19-2002 02:30 AM

Ok my bad...you are not trying to run without a database, rather the program is having trouble finding a database on your local machine.

Xalivor 04-19-2002 03:12 AM

Everytime i go to the mysql and type use eq it says DB changed, but when i type source db.sql it says this

ERROR 1062: Duplicate entry '2136' for key 1
ERROR 1062: Duplicate entry '2137' for key 1
ERROR 1062: Duplicate entry '2138' for key 1
ERROR 1062: Duplicate entry '2139' for key 1
ERROR 1062: Duplicate entry '2140' for key 1
ERROR 1062: Duplicate entry '2141' for key 1
ERROR 1062: Duplicate entry '2142' for key 1
ERROR 1062: Duplicate entry '2143' for key 1
ERROR 1062: Duplicate entry '2144' for key 1
ERROR 1062: Duplicate entry '2145' for key 1
ERROR 1062: Duplicate entry '2146' for key 1
ERROR 1062: Duplicate entry '2147' for key 1
ERROR 1062: Duplicate entry '2148' for key 1
ERROR 1062: Duplicate entry '2151' for key 1
ERROR 1062: Duplicate entry '2152' for key 1
ERROR 1062: Duplicate entry '2154' for key 1
ERROR 1062: Duplicate entry '2156' for key 1
ERROR 1062: Duplicate entry '2158' for key 1
ERROR 1062: Duplicate entry '2160' for key 1
ERROR 1062: Duplicate entry '2162' for key 1
ERROR 1062: Duplicate entry '2164' for key 1
ERROR 1062: Duplicate entry '2165' for key 1
ERROR 1062: Duplicate entry '2166' for key 1
ERROR 1062: Duplicate entry '2171' for key 1
E
and so on

Trumpcard 04-19-2002 03:20 AM

You already have the database loaded, of course its going to spit out a million duplicate items when you source db.sql.

drop database eq;
create database eq;
source db.sql;

Xalivor 04-19-2002 03:35 AM

thanks trump that worked. But i am still getting errors about 2006. i read the post about it and did this.

mysql> GRANT ALL PRIVILEGES ON eq.* TO Ashy@localhost INDENTIFIED BY <mypass> WIT
H GRAN OPTION

but it didnt do anything that i noticed.

When i open World.exe it still says the same thing listed in previous posts.

Xalivor 04-19-2002 03:36 AM

also in my winmysqladim under process it still doesnt list a DB

Meekrat 04-19-2002 05:03 AM

user/pass??
 
[Database]
host=localhost
user=my minilogin username
password=my minilogin password
database=eq

You are not putting minilogon user/pass are you? You are putting in the user/pass that you made for MySQL?

Thought i'd ask. Your post was not clear.

Xalivor 04-19-2002 05:10 AM

yeah i think i am. i forgot my MYSQL password/username. But everytime i go to the MS window to fix it nohing happens

ibleet 04-19-2002 05:15 AM

Open up winmysqladmin, your username and password are listed there under the my.ini Setup tab.

Xalivor 04-19-2002 05:18 AM

ok i did and it seems as though its the same as mini login

ibleet 04-19-2002 05:55 AM

Actually minilogin is eqemu eqemu, but any username and pw provided will work.

Xalivor 04-19-2002 05:58 AM

im still getting the same errors

Grr all i wanna do is make items

Shawn319 04-19-2002 08:54 AM

DB.ini HAS to have your mySQL login and password. if you forgot it then delete c:\windows\my.ini then re-run Winmysqladmin.exe and make a new one.


All times are GMT -4. The time now is 05:24 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.