EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   Error : 1046 No database selected? (https://www.eqemulator.org/forums/showthread.php?t=4104)

Rilstin 11-29-2002 07:38 AM

Error : 1046 No database selected?
 
I go in to mysql.exe and type source db.sql; and it scrolls through a few pages of that. I have copied over the db.sql to mysql/bin. Whats wrong?

Trumpcard 11-29-2002 10:06 AM

Did you create the eq database first?


FROM THE README


1)
> after the install go to c:\mysql\bin\ and open winmysqladmin.exe, it should prompt you to create a user / pass ( remember this becuase you need to use the login later on in the install )

> after you set up the user / pass go to c:\mysql\bin\ and open mysql.exe

> type this in the command prompt (type it exactly how you see it here) ;

create database eq;

( this creates a database named eq )

> example output
Your MySQL connection id is 6146 to server version: 3.23.36-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> create database eq;
Query OK, 1 row affected (0.00 sec)




2)

> copy db.sql from c:\eqemu\ to c:\mysql\bin\

> open mysql.exe

> type this in exactly

source db.sql;

Rilstin 11-29-2002 10:07 AM

Yes I created the database first.

Trumpcard 11-29-2002 10:08 AM

Hmm.. the readme doesnt tell you to type

use eq;

before

source db.sql;


try that...

Rilstin 11-29-2002 10:11 AM

Thank you sir, it looks like that worked.


All times are GMT -4. The time now is 06:18 AM.

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