mysql server has an error, broken or wrong data.

Zhang Weiwu, Beijing zhangweiwu at realss.com
Wed Jul 6 10:32:33 EDT 2011


Hello. This error message on the subject line is translated back from
Chinese to English. Having Chinese GUI on an English installation
(selected English on installer) on a Chinese computer itself is a wired
thing, but that's a separate bug or topic.

Here is how this issue happened:

    * Copy a working .gnucash file (produced by gnucash 2.2.9) to Windows XP
    * Install 2.4.7 on Windows XP
    * Open the .gnucash file successfully.
    * Save as mysql. fill in host and mysql username & password, click
      "Save as" (mysql database is newly created and empty)
    * Wait 5 minutes, get this error message:
      "mysql server has an error, broken or wrong data."

Where do you suggest me to go from here?

By the way, I intended to use postgresql, but there is no such a save-as
option in gnucash 2.4.7 XP edition.

The list of tables on the mysql database tables after the error occurs
is listed here FYI:

$ echo 'show tables;' | mysql -h houyhnhnms -u gnucash -pfake_password
gnucash
Tables_in_gnucash
accounts
billterms
books
budget_amounts
budgets
commodities
customers
employees
entries
gnclock
invoices
jobs
lots
orders
prices
recurrences
schedxactions
slots
splits
taxtable_entries
taxtables
transactions
vendors
versions



More information about the gnucash-user mailing list