PDA

View Full Version : Error : 1046 No database selected?


Rilstin
11-29-2002, 07:38 AM
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.