On Wed, 22 Jun 2011 12:22:34 +0200, Marcus Mülbüsch <muelbue...@as-infodienste.de> wrote: > Am 22.06.2011 12:05, schrieb Jérôme Blion: > >> I don't know how you dumped your mysql database. >> Did you try to use mysqldump -T ? mysql2pgsql ? >> I used some other scripts to migrate data pieces. I will look for them >> this evening... > > mysqldump -t -n -c --compatible=postgresql --skip-quote-names --skip-opt
> --disable-keys --lock-tables -ubacula -p -q bacula | grep -v "INSERT > INTO Status" | sed -e 's/0000-00-00 00:00:00/1970-01-01 00:00:00/g' | > sed -e 's/\\0//' > bacula-backup.sql So you should really try mysqldump -T... This is known to be much faster (then use copy from ...) Did you try some tools like http://www.sql-workbench.net/ or http://sqlfairy.sourceforge.net/ ? Cordialement. Jérôme Blion. ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users