populating database

[Johann Montfort]

Dear all,
  I am trying to learn MySql and I am in my first steps.  I have installed the mysql server and everything seems to be working fine.  Now I am following a tutorial, and this has created a file called DB.sql, and then this tutorial tells you to populate a database with this file.

When I am typing

C:type DB.sql | mysql -h localhost -u root myDB

in the MSDOS, it is not working.  What am I doing wrong?

Sorry if I did not explain myself well, but I have started MySql today and I am not so sure what is exactly happening, that is why I posted a message in this message board

Thanks for your help!

[Musicman]

exactly what is happening then?

Musicman

[Johann Montfort]

It is giving me the following error:-

'mysql' is not recognasable as an internal or external command, operable program or batch file.

Another thing, how do I create and ODBC Connection to my database?

[Musicman]

Hi,

If there is a mysql program with your kit, probably the dos box does not know where it is. Change the PATH setting (in autoexec.bat if you are running a 9x system, or somewhere in the control panel for NT/2000) to include the folder where your mysql programs are

Musicman

[Flash-db]

Ok, try this:

Open the MS Dos prompt then use the CD command to traverse to the directory where the MySQL.exe program is located.

Default is C:\MySQL\Bin

So you could use

CD C:\MySQL\Bin

once your their then you can run your command by typing :

mySQL [enter]

Which will spit out some lines of text saying that your connected to the DB.  
Then you'll see a prompt like:

MySQL>

Enter any commands you want to execute their.

Also try out that new article:
http://www.flash-db.com/ApachePHPSQL

it goes into some details further along like page 7 or 8.