On 03/21/13 08:43, Konstantin Khomoutov wrote:
> On Thu, 21 Mar 2013 07:40:01 -0400
> Phil Stracchino <alaric AT metrocast DOT net> 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
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  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
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users