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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users