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