mysql problem - new version / old database

[Ben Harrison]

Hi all, my host recently upgraded his mysql version and now one of my old sites has cocked up. When i go into the table via phpmyadmin it says..

Table './lamotte_lamotte/bookings' was created with a different version of MySQL and cannot be read

Current version is 'MySQL client version: 4.1.22'

Unsure what the old version is/was.

I've tried to get my host to sort this as it was something he's done, but he's not willing to help and keeps telling me to come ask on here. He also claims he didn't do any backups before moaving over to this new server with the newer version of mysql. Am I right in thinking this should be his job and not mine?

Any help - much appreciated!

 

[vanessa]

You may need to see if you can have your host copy the raw MySQL files onto a MySQL 4.1 server, then export and import again properly. I don't think you can resolve this any other way that doesn't involve a downgrade.

 

[Ben Harrison]

I did ask him to do this and he wouldn't do it :/

 

[Kailash1]

I think your host has downgraded the version of MySQL because you should not face the problem if your host upgrade MySQL from previous version.

MySQL version Downgrade is not supported. It will corrupt all the data if you downgrade the version.

Kailash

 

[Ben Harrison]

Deffinetly upgraded

 

[Ben Harrison]

so is downgrading the only way to go about this?

 

[Infopro]

Why not try exporting/dumping the DB from shell then reload it to a new DB? Shouldn't hurt anything to try I wouldn't think. How large is the DB?

 

[vanessa]

Exporting won't work if MySQL can't even read it - downgrading or moving the database to a server with older mysql is the only way to fix.

 

[Ben Harrison]

Hi, recently did an entire account raw backup and the sql file still says 'msql database was created with an older version..' etc. :/