On 03/21/13 08:43, Konstantin Khomoutov wrote: > On Thu, 21 Mar 2013 07:40:01 -0400 > Phil Stracchino <[email protected]> wrote: > > [...] >> Try this for a faster method: >> >> CREATE TABLE NewFile LIKE File; >> INSERT INTO NewFile (SELECT * FROM File); >> DROP TABLE File; >> RENAME TABLE NewFile TO File; > > I think the "ALTER TABLE" step is missing, and this should be: > > CREATE TABLE NewFile LIKE File; > ALTER TABLE NewFile ENGINE=InnoDb;
Right. I tend to forget that because I simply never use MyISAM, for *anything*. (Except of course the grant tables, and that only until MySQL grant tables can be sotred in InnoDB.) -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 [email protected] [email protected] [email protected] Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
