The problem with the keyword 'order' is that, although it has been escaped, the character used is a double-quote. By default, Mysql doesn't recognize this; it expects a backtick as the escape character. If you have access to the Mysql configuration, this can be fixed by the addition of the line
sql_mode = 'ANSI_QUOTES' to the [mysqld] section of the configuration file (in ubuntu, at /etc/mysql/mysql.conf.d/mysql.cnf), and restarting the mysql server. With this fix, I was able to load my 4.6 anonymized file under 4.8.0 in about 3-4 minutes. However, I decided to build 4.8.1.1 from source and try that. I got the following error loading my 4.6 file: ----------------------------------------------------------------------------------------------------- Error in function bool MyMoneyStorageSql::alterTable(const MyMoneyDbTable&, int) : Error inserting into new table kmmFileInfo Driver = QMYSQL, Host = localhost, User = tonyb, Database = Anonkmm Driver Error: Database Error No -1: Text: Error type 0 Executed: INSERT INTO kmmFileInfo (version, created, lastModified, baseCurrency, institutions, accounts, payees, tags, transactions, splits, securities, prices, currencies, schedules, reports, kvps, dateRangeStart, dateRangeEnd, hiInstitutionId, hiPayeeId, hiTagId, hiAccountId, hiTransactionId, hiScheduleId, hiSecurityId, hiReportId, encryptData, updateInProgress, budgets, hiBudgetId, '', '', logonUser, logonAt, fixLevel) SELECT version, created, lastModified, baseCurrency, institutions, accounts, payees, '', transactions, splits, securities, prices, currencies, schedules, reports, kvps, dateRangeStart, dateRangeEnd, hiInstitutionId, hiPayeeId, '', hiAccountId, hiTransactionId, hiScheduleId, hiSecurityId, hiReportId, encryptData, updateInProgress, budgets, hiBudgetId, '', '', logonUser, logonAt, fixLevel FROM kmmtmpFileInfo; Query error No 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 ''', '', logonUser, logonAt, fixLevel) SELECT version, created, lastModified, bas' at line 1 QMYSQL: Unable to execute query Error type 2 -------------------------------------------------------------------------------------------- This looks pretty bad! I downloaded the source from one of the mirrors on this page: https://download.kde.org/stable/kmymoney/4.8.1.1/src/kmymoney-4.8.1.1.tar.xz.mirrorlist If someone can confirm that is the latest, I'll look into the problem if you wish. -- Cheers TonyB