On Thu, 21 Mar 2013 14:46:04 +0100 Uwe Schuerkamp <uwe.schuerk...@nionex.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
