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