List:General Discussion« Previous MessageNext Message »
From:Jeremiah Gowdy Date:May 25 2005 1:26pm
Subject:Re: InnoDB to MyISAM
View as plain text  
----- Original Message ----- 
From: "Rafal Kedziorski" <rafcio@stripped>
To: "Scott Purcell" <spurcell@stripped>; <mysql@stripped>
Sent: Wednesday, May 25, 2005 6:06 AM
Subject: Re: InnoDB to MyISAM


> http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html

He's converting InnoDB to MyISAM.

I would recommend something like this:

CREATE TABLE newtable LIKE oldtable;

ALTER TABLE newtable ENGINE=MyISAM;

ALTER TABLE newtable DISABLE KEYS;

INSERT INTO newtable SELECT * FROM oldtable;

ALTER TABLE newtable ENABLE KEYS;

>>key relationships?
> 
> MyISAM can't FK's.

Yes it can, they're just not enforced.
Thread
InnoDB to MyISAMScott Purcell25 May
  • Re: InnoDB to MyISAMDBA)25 May
  • Re: InnoDB to MyISAMRafal Kedziorski25 May
  • Re: InnoDB to MyISAMJeremiah Gowdy25 May
  • Re: InnoDB to MyISAMMartijn Tonies25 May
  • Re: InnoDB to MyISAMJeremiah Gowdy26 May
    • Re: InnoDB to MyISAMmfatene26 May
  • Re: InnoDB to MyISAMMartijn Tonies26 May
  • Re: InnoDB to MyISAMJeremiah Gowdy26 May
  • Re: InnoDB to MyISAMJeremiah Gowdy26 May
  • Re: InnoDB to MyISAMMartijn Tonies26 May
    • RE: InnoDB to MyISAMPeter Normann26 May
  • Re: InnoDB to MyISAMJeremiah Gowdy27 May
Re: InnoDB to MyISAMMartijn Tonies26 May
Re: InnoDB to MyISAMDBA)26 May