MySQL Forums
Forum List  »  InnoDB

Re: Mysql service hangs on ALTER TABLE only on one particular database
Posted by: Noel Abela
Date: October 23, 2015 07:47AM

Yes, it is InnoDB. The table is very very small, less than 50 rows.

Unfortunately we have did not know about the .err file at the time and restored the whole data folder. This overwrite the .err file too.

We are now trying to convince the users to do it again so that we can look into the error log, but they are making a big fuss over it. What we did to get the updates done was to stop the service, copy the whole data folder to a laptop, do the necessary ALTERs there, and then copy the data folder back to its original server and then start the service again.

Thanks
N

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.