[Phpmyadmin-devel] export: about using "--"

Michal Čihař michal at cihar.com
Tue Sep 14 08:11:09 CEST 2004

On Mon 13. 9. 2004 19:26, Marc Delisle wrote:
> here is IMO a MySQL (at least 4.0.20) bug, but maybe we could put a
> workaround in the export logic.
> If the last exported table has no data, the export file
> ends with those ANSI-style comments:
> --
> -- Dumping data from table table1
> --
> and MySQL gives an error on this!
> No problem if the file ends with MySQL-style comments.

The problem is that phpMyAdmin removes trailing space, so it is not valid ANSI 
comment then:

#1064 - You have an error in your SQL syntax.  Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'--' at line 3

I currently don't have time to track where the space is being trimmed...

    Michal Čihař | http://cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20040914/4a0b264e/attachment.sig>

More information about the Developers mailing list