I think it should be corrected to begin/commit only as afaik most of the sql servers use this syntax. L. Dne středa, 24. července 2013, Andrew Atkinson napsal(a):
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 _______________________________________________ Therion mailing list Therion@speleo.sk <javascript:;> http://mailman.speleo.sk/mailman/listinfo/therion