[Therion] file.sql format

[Andrew Atkinson]

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