MySQL Forums
Forum List  »  MyISAM

How do I convert an InnoDB database into MyISAM?
Posted by: Niek van der Heijden
Date: May 16, 2005 10:45AM

Hello,

I've built a database in InnoDB (was default in MySQL - changed that now to MyISAM), but my host only supports MyISAM. I've exported the DB in a .sql-format, but I do not know how to import that into a new MyISAM-db. Is this transformation possible or do I have to rebuild the thing in MyISAM? The db doesn't yet contain data, but I'd like to spare myself the work, because I get along quite nicely with the PHP-cms, and I don't want any rebuild-mistakes. I do use PHPMyAdmin. Thanx,

Niek

Options: ReplyQuote


Subject
Views
Written By
Posted
How do I convert an InnoDB database into MyISAM?
77382
May 16, 2005 10:45AM
40829
October 14, 2005 08:46AM


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.