Re: Change InnoDB to MYISAM after restore
Now I know, that if the server starts and doesn't find an innodb-tablespace, it changes the variable have_innodb from YES to DISABLED. Then I must deinstall and install again the MySQL-server and restore my databases. I found an another way, without a new installation. I take a "new" tablespace from another MySQL-server, directly after a new installation, copy the innodb-tablespace to my defect data-directory, change owner, start the MySQL-server and run my restore-script. I am not sure, if it is a better way, but it is one :-)
Subject
Written By
Posted
Re: Change InnoDB to MYISAM after restore
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.