Newb question, How to open a database in mysql

[sazebac]

I'm running MySql in a Windows environment, I have a database called winestore.database and I put it in \mysql\bin

I can connect to mysql fine.
I can't seem to open the database, I've tried
use winestore.database
use winestore
mysql winestore.database
Plus a few others. Any suggestions?

 

[sleipnir214]

I'm intrigued by your use of the phrase "I put it in \mysql\bin".

Did you not create the database from within MySQL by using the "CREATE DATABASE" statement? If not, you need to -- that's the only way you're going to get MySQL to recognise the database.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[sazebac]

What I mean is, the database is an example database that ties in to the book I'm reading. The database is on a web site. I downloaded it, and copied it into the c:\mysql\bin and then into c:\mysql\data. So no I did not create the database from within mysql.

 

[sleipnir214]

Then MySQL is not going to use it.

What exactly did you download? A set of SQL statements?

If so, you need to run your preferred MySQL administration application, create the database, then import those SQL statemetns into MySQL.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[sazebac]

The database is at

http://www.webdatabasebook.com

There is one ziped and one that is gziped?
The gziped on is at

http://www.webdatabasebook.com/winestore.data.gz

The directions in the book are for loading the database in a unix environment, and I'm trying to do it in a Windows environment.

 

[sleipnir214]

Download the zipped version.

Unzip it.

Issue a command something like:
mysql < winstore.database

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[frumunda1]

do a mysql>show databases command. If you don't see your database there then it's either a zipped file, scripts to create your database or something else.

Regards,

JG