pilotjourney — 2010-10-31T12:02:28-04:00 — #1
I am trying to import a .sql file.
I created the database, then tried to import the file.
phpmyadmin indicated that 634 queries were executed however when looking at the database there were no tables, therefor nothing to browse.
I have never done this before, what did I do wrong?
registryexpert — 2010-11-02T13:25:22-04:00 — #2
To restore a .sql file, copy the file to bin folder of mysql installation and give the following command on command prompt while being in bin folder of mysql installation:
mysql --add-drop-tables -u [rootuser] -p [databasename] < [filename.sql]
replace [rootuser] with your username of root user.
replace [databasename] with the name of database in which you want to import.
replace [filename.sql] with the name of .sql file.
If need further help, let me know.