On Thu, 21 Mar 2013 14:46:04 +0100
Uwe Schuerkamp <uwe.schuerkamp AT nionex DOT net> wrote:

> > 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. 

I'm curious about how to do such a Postgres-compatible dump?
Could you please share this?

------------------------------------------------------------------------------
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