Creating DB help

[onejessman]

mysql> use eq;
Database changed
mysql> source db.sql;
ERROR:
Failed to open file 'db.sql', error: 2
mysql>

anyone know what to do...i guess im gona continue on and not worry about it for now

[sotonin]

db.sql is outdated and not used anymore.

[samandhi]

To elaborate on Sotonin's quick answer, you are following the directions for setting up your server I see, because that IS what it says to type. But, the database name has changed many times since that guide was written... What you have to do is to unzip the database file that you are wanting to use into your c:\mysql\bin folder.... Let's say you are using your own created database file that was named onejessmans_058.sql

Then you would type the following to source it:

use eq;
source onejessmans_058.sql
quit


This will source whatever was in the file called onejessmans_058.sql into your eq useable database... Hope this helps...

[sotonin]

db.sql used to be a empty "framework" that was sourced before a database.

Why it's still in guides ill never know. but it's not used anymore. simply source in the database SQL be it classic or other. thats it.

[Cutter]

unless you dont want to use anyone else work.. and just create a blank database.. and start from scratch ;P

[sotonin]

the db.sql is incompatible with any even remotely recent cvs releases. you'd need to make a new one anyways.