On Thu, Mar 21, 2013 at 07:40:01AM -0400, Phil Stracchino 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; >
Thanks Phil, I was a bit anxious about the select into bit because the server ran out of memory before when I tried to create a postgres-compatible dump using mysqldump, so it was important for me to create a fully consistent dump of the file table first for backup purposes. All the best, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA ------------------------------------------------------------------------------ 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
