Results 1 to 2 of 2
Thread: Import a .sql file
Oct 31, 2010, 10:02 #1
- Join Date
- Jan 2004
- 0 Post(s)
- 0 Thread(s)
Import a .sql file
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?
Nov 2, 2010, 11:25 #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.