mysql Dump file?

[Bengal313]

Okay I finally decided to switch from asp to php. Now I need to convert all my Access 2000 databases to mysql. I used this program called accessdump to create a dump file, "db.sql". Now, How do I use this file to recreate my MYSQL database. Do I use "phpmyadmin" or something else? Where do I go from here?

[codefox]

use phpmyadmin. there's an option to run SQL statements from a file.

[mbenson]

you can also use

1- mysqladmin -h myhost -u root -pmypass create dbname
creates the database

2- mysql -h myhost -u root -pmypass dbname < file/location/db.sql
to import the tables into the database created in step 1


These are done at the command line though.
"mysql\bin" on win32.