MySQL Query Error : Plz help

[Arun]

I get the error quoted below when I tried to import a mysql dumb I collected yesterday from my db (using phpMyAdmin) here. I tried to import it to another db here itself.

I had repaired and optimised all tables in it before exporting this dump from my parent db. Will changing some data export parameters in phpMyadmin export window help resolve this bug? I'm left clueless here.Some help is really appreciated.
(The OPS db backup of yesterday is corrupt so I chose phpMyADmin export - and after I have repaired the table today there has not been any backup taken by OPS)

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

[Arun]

The OPS DB backup of today is now available and it hs been exported properly (as I repaired the DB today afternoon) This time I was able to import it to a new DB without any error....

Although the problem is temporarily solved there is something which I'm doing which I should not do when exporting a dump using phpmyadmin. Some parametrs in the "data" section probably. anyways I'm gonna post this to MySQL.Com too.

Thank You
Arun

[mitchind]

Why do you think the Ops db backup is corrupt?

Its a gzipped file which has to be saved with that extension (.gz) if you want Winzip to open it.

You can send me a URL to the file or email me and I'll have a look at it.

As for your export - what does the file look like - can you post a few lines from the file? Is it comma delimited or a SQL file?

[Arun]

mitchind,
Thank you very much for your reply.
But I know what a GNU zip is and I don't want to open it in my PC. Even if I want to open it up in Win I have almost two free utils which let me uncompress all the *nix compression formats. But if I wanted to import it to my local test server I've configured it to load the PHP extensions for it . If I couldn't have achieved anything I mentioned above I would've used the RHL9 installation on my desktop to do it all.

Why do I say that the OPS dump was corrupt??? I say it because it was corrupt, before I repaired some tables in them.

Yesterdays GNU Zipped OPS dump was 3 kb whereas it actually is 1.2 MB and the uncompressed sql file is 3.6 MB

I tried all the export types supported my the powwebs installation of phpmyadmin ie plan sql, gzipped and bzipped. But sorry I cant give the files here for security reasons.

mitchind if you really want to help people out here you should read their posts carefully and give due respect to it especially when you are an admin of a very active forum.

Thank You Very Much once again
Regards