Bacula-users

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 06:25:20
Subject: Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long
From: Marcus Mülbüsch <muelbuesch AT as-infodienste DOT de>
To: Jérôme Blion <jerome.blion AT free DOT fr>
Date: Wed, 22 Jun 2011 12:22:34 +0200
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users