MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Change InnoDB to MYISAM after restore
Posted by: Bob Field
Date: June 10, 2006 09:11AM

Do a SHOW ENGINES and see if InnoDB support got disabled. If so you'll need to re-enable it and then you can use ALTER TABLE to change the tables back to InnoDB, or else you can re-run the restore.

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


Subject
Written By
Posted
Change InnoDB to MYISAM after restore
Beate Schlesiona
June 10, 2006 06:21AM
Re: Change InnoDB to MYISAM after restore
Bob Field
June 10, 2006 09:11AM
Re: Change InnoDB to MYISAM after restore
Beate Schlesiona
June 11, 2006 02:05AM
Re: Change InnoDB to MYISAM after restore
Beate Schlesiona
June 11, 2006 03:15AM
Re: Change InnoDB to MYISAM after restore
Bob Field
June 11, 2006 09:54AM
Re: Change InnoDB to MYISAM after restore
Beate Schlesiona
June 11, 2006 10:31AM
Re: Change InnoDB to MYISAM after restore
Beate Schlesiona
June 18, 2006 02:58AM


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.