An sql question about using existing .sql files

[damon2003]

Hi,
I have an sql question and there is no thread for this.
I have a .sql file, (simply a txt file), containing all the nesessary commands to create mysql tables. I am using a windows comand prompt and want to use this txt file to create the tables. I have created a blanck database and want to import new tables using this file,
does anyone know the command to do this?
thanks a lot

[DanUK]

Do you have anything like `phpMyAdmin'?
This could achieve it. You can simply browse the file on your HDD and use it there.
I use SSH to ssh into our FreeBSD box to do stuff like that, so I don't know if it's possible or not via the windows prompt.

HTH.

[damon2003]

Thanks a lot, actually tried dbmanager and it works.
In dos I ended up just typing the name of the file to be uploaded, but kept getting errors, anyway dbmanager is much easier

[pyro]

I'm assuming that your last post was in responce to this thread, so I've merged them together.

Also, I agree with skydan on phpMyAdmin. If I'm doing MySQL work, it's a given that I'll be using it. ;)