Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi all, --------------------------

Status
Not open for further replies.

aheaddigital

Programmer
Dec 16, 2003
2
US
Hi all,
-------------------------------------------------
My Environment:
Windows XP pro, sp1
IIS5.1
mysql 4.0.17
phpMyAdmin 2.5.4
-------------------------------------------------
-------------------------------------------------
I recently built a new database at my work PC, and wanted to migrate the database to my home PC, so I dumped the database to a .sql file for import at home.
When I browse for the file using phpmyadmin and click "go", it returns the error message:

"no sql query!"

I'm not able to figure out why I can't run the .sql text file.
-------------------------------------------------
-------------------------------------------------
What it's Not:
> It's not a problem with the .sql file, or the syntax of the file, for I have sent it to two other developers who were able to sucessfully import and run the file, no problems.

>It's not that my phpMyAdmin is not sucessfully connected to mysql, for I am able to see the two default tables that come with mysql (test and mysql). I am also able to actually manually create databases and tables using phpmyadmin.

>>It's probably not a problem with the version of mysql or phpmyadmin that I'm using, because I've not only tried the latest versions of each products, but also older versions, and different mixes of them. Each causing the same "no sql query!" result.

-------------------------------------------------

Regards,
Daniel Greeney

[ Insert witty phrase here ]
 
...I apologize for the subject line of this thread, it got changed when I went to the preview screen and then I went backin my browser by accident, and forgot to re-add the subject line.





dg

[ Insert witty phrase here ]
 
SQL No Query will be returned if you have 2 semicolons together - each is read as the terminator for an individual query. (e.g ;;)
check the file for that.

Thats all that springs to mind without seeing it al in action or having the file to play with.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top