This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Is there any way to revive a database?

Tags: None
(comma "," separated)
piedro
Registered Member
Posts
374
Karma
1
OS
Hello everybody!

After a harddisk crash I had to resetup my Kubuntu installation. Now I am running Kubuntu 12.10 with KDE 4.10.2. I also reinstalled Kmymoney and tried to open my backup files ... obviously by fiddling around with my KMyMoney backup file I deleted the newest backup version and replaced it with a one year old backup file (which is quite useless for my purposes). Now I learned my lesson, not to hold multiple file versions as backup - but that is not my point ...

I have a mysql database (it was created with 4.6.2), which I also used when testing mysql with kmymoney (I had no problems as far as I can remember!). It is probably not really the newest verison of my data but only about two or three month old. It would be a great relief to use this data instead of filling in the whole last year of data and trying to reestablish the complex account structure I've set up. When I try to open the database with kmymoney 4.6.3 though it won't work - cannot open the database and kmymoney crashs after closing the error message:

Error in function int MyMoneyStorageSql::upgradeDb() : Error retrieving file info(version)
Driver = QMYSQL, Host = localhost, User = kmymoney, Database = kmymoneydb
Driver Error:
Database Error No -1:
Text:
Error type 0
Executed: SELECT version FROM kmmFileInfo;
Query error No -1:
Error type 0

Is there any way to resolve this issue or to set up a new database and transfer the data manually to the new one?

Any help is appreciated,
thx for reading,
piedro


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Evergrowing, Google [Bot], ourcraft