Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long
2011-06-22 06:25:20
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
|
|
|