On Wed, 22 Jun 2011 12:22:34 +0200, Marcus Mülbüsch
<muelbuesch AT as-infodienste DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users