Hello I have just been playing with the export database part of Therion again.
The file outputted was imported into some application fine, but most would not work phpMyAdmin being one of the ones that I could not import with and the one that my ISP forces me to use. phpMyAdmin was giving the error #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 'TRANSACTION' at line 1 After a bit of searching I found this http://dev.mysql.com/doc/refman/5.0/en/commit.html (there is a similar page for MySQL4 and 3.23 that seem to say the same) So editing the exported file first line from begin transaction; to begin; and last line from commit transaction; to commit; then it worked Not sure if this is a bug or my lack of understanding of the .sql file format Andrew
