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

Marcus

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

Reply via email to