Import a .sql file

Databases
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?

2

Hi,

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.