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

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...