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; INSERT INTO NewFile (SELECT * FROM File); DROP TABLE File; RENAME TABLE NewFile TO File; Thanks for the tip -- used this approach today to reload my own catalog. ------------------------------------------------------------------------------ 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