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 at speleo.sk <javascript:;> > http://mailman.speleo.sk/mailman/listinfo/therion > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20130725/f155405f/attachment.html>
