MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: show create procedure fails after move to different server
Posted by: Charlie Farrow
Date: August 20, 2009 05:18AM

Charlie Farrow Wrote:
-------------------------------------------------------
> I have found the solution!
>
> Move to your mysql datadirectory.
> Go into the mysql database directory.
>
> Run "myisamchk -e -o -r *.*"
>
> That has 100% fixed it for me.



Actually thats not true. It found lots of errors, but its not fixing them. I get the folloowing message a lot of times:

"Found block that points outside data file at #####"
where ##### is a number.

? :(

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.