
December 20th, 2003
03:19 PM
me like web dev
Status: Offline!
no sql query! from an imported .sql file
Hi,
I have been getting the report:
no sql query!
when i run an exported .sql file in phpmyadmin.
The .sql file is one from a verifiably working database that i built at work and wanted to migrate to my home pc. I know it works at work, and i even sent it to a friend, and he was able to run it on his mysql database, and it did indeed build the database and propagate it with information.
For some reason, I AM able to actually manually create the database myself via the phpmyadmin query window with standard sql syntax, however it seems that my only problem is that it doesn't want to run an external .sql textfile. I have serarched the online documentation rather exhaustedly, and I'm still in the dark. Help anyone please!
Thanks,
DG
___________________
[FONT=tahoma][place graphical sig here]
[b]you're = You + Are[/b] [size=1]--ex.[/size] "[I]That's it, you're done![/I]"
[b]your = possessive[/b] [size=1]--ex.[/size] "[I]Is that your dog?[/I]" - [u]not[/u] - "[I]That's it, your done![/I]"[/FONT]

December 21st, 2003
06:07 AM
it might have errors in the syntax for the .sql file. I come accross this when i moved some forums for a friend.
If it does work on a mates computer then find out what version he is running. Mayby you need to upgrade?
hope i helped. 
___________________
LocalHoster.com
FreeHostHelp.com

December 22nd, 2003
04:29 AM
me like web dev
Status: Offline!
Hi, and thanks for the response andrew.
Just to give more info on the problem, here is some information about my environment:
# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Dec 18, 2003 at 04:55 PM
# Server version: 4.0.17
# PHP Version: 4.3.4
I am running this on IIS5.1 on windowsXPproSP1.
As for what andrew said, yes I sent the file to a friend, actually two now at the time of this posting, and two other people have been able to execute my .sql file and build the database it contains. I have tried actually downgrading my mysql database, and phpmyadmin, and also differing combinations of both (newest admin, newest server -- newest admin, older server -- older admin, newer server -- older both) but to no avail. I'm quite sure it's not a problem of needing to upgrade, as this problem arose with the latest versions both mysql and phpmyadmin.
Thanks for your response, but does anyone else have any ideas?
I've been scouring newsgroups and help sectons, and the mysql manual. So far I'm still in the dark.
Thanks.
___________________
[FONT=tahoma][place graphical sig here]
[b]you're = You + Are[/b] [size=1]--ex.[/size] "[I]That's it, you're done![/I]"
[b]your = possessive[/b] [size=1]--ex.[/size] "[I]Is that your dog?[/I]" - [u]not[/u] - "[I]That's it, your done![/I]"[/FONT]