[Phpmyadmin-devel] export: about using "--"
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
#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
Size: 189 bytes
Desc: not available
More information about the Developers