View previous topic :: View next topic |
Author |
Message |
mythandra n00b
Joined: 15 Sep 2006 Posts: 35
|
Posted: Tue Jan 09, 2007 10:15 pm Post subject: mysql databse dilema please help!! |
|
|
Hello Guys,
I am completly pulling my hair out at the moment trying to recover my wiki database, here is what happend.
I was installing Beryl 1.4 and made the mistake of doing a emerge -uDav beryl
this command upgraded my mysql database from a version to 5.0.30.
I have tried to copy copy over the data dir from my old db location to the new location (since it won't start mysql if i specify a diff db location other than the default)
It tells me when i try and run the following that i am running the wrong version of the db for the database
Code: |
mysql> select * from user;
ERROR 1033 (HY000): Table './wikidb/user' was created with a different version of MySQL and cannot be read
|
I have no clue what version of mysql was installed to be honest as this was done a while ago.
I think it could have been 4x something but not sure.
I have masked out the following versions of mysql
Code: |
>=dev-db/mysql-5.0.26-r1
>=dev-db/mysql-5.0.30
|
and have installed version
Code: |
* dev-db/mysql
Latest version available: 4.1.22
Latest version installed: 4.1.22
Size of files: 17,393 kB
Homepage: http://www.mysql.com/
Description: A fast, multi-threaded, multi-user SQL database server.
License: GPL-2
|
I have cd'd into the /var/lib/mysql/wikidb dir and run
which retuens the following
Code: |
user.frm: MySQL table definition file Version 10
|
Can anyone tell from this version what mysql version I had installed? or of any tools that would allow me to upgrade these files to work with mysql 5.0.30?
i am still getting the error about the wrong version of the database.
I am pulling my hair out at the moment, i have some development work to complete and i need to be able to copy the live dbs to my machine to work at home
can anyone suggest anything that i haven't already tried. |
|
Back to top |
|
|
boerKrelis Apprentice
Joined: 01 Jul 2003 Posts: 241 Location: The Netherlands
|
Posted: Tue Jan 09, 2007 10:51 pm Post subject: |
|
|
You might find your previous version number in /var/log/emerge.log. Everything you emerge, gets logged. After downgrading you might try to upgrade by following the mysql upgrade guide in the gentoo docs. Do you know how to downgrade? |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|