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
|