Subject: The mailing list for listmasters using Sympa
List archive
Re: [sympa-users] migrating db from postgresql to mysql
- From: Miles Fidelman <address@concealed>
- To: address@concealed
- Subject: Re: [sympa-users] migrating db from postgresql to mysql
- Date: Mon, 27 Oct 2014 12:37:25 -0400
Any particular reason WHY you're migrating?
Given Oracle's acquisition of MySQL, it seems like most people are moving the other way, or at least from MySQL to the Mariadb fork of MySQL.
I'm kind of curious why you're migrating TO MySQL.
Regards,
Miles Fidelman
------------------------------------------------------------------------
*De :* address@concealed [mailto:address@concealed] *De la part de* Amos
*Envoyé :* vendredi 24 octobre 2014 22:35
*À :* address@concealed
*Objet :* [sympa-users] migrating db from postgresql to mysql
It was decided that the db should be migrated from PostgreSQL to MySQL. The DBA team imported the data from the PostgreSQL db into MySQL. I then proceeded to bring up Sympa 6.1.23.
Overall things go well. Sympa updates the db structure to match the mysql settings. However, the following error message is logged:
Oct 24 15:23:20 localhost sympa[27509]: err Upgrade::probe_db() Could not set field 'robot_subscriber,list_subscriber,user_subscriber' as PRIMARY KEY, table'subscriber_table'.
Is this serious, anything to worry about? Should something be done manually?
-
[sympa-users] migrating db from postgresql to mysql,
Amos, 10/24/2014
-
RE: [sympa-users] migrating db from postgresql to mysql,
Jérôme Zittoun, 10/27/2014
-
Re: [sympa-users] migrating db from postgresql to mysql,
Miles Fidelman, 10/27/2014
-
Re: [sympa-users] migrating db from postgresql to mysql,
Amos, 10/27/2014
- Re: [sympa-users] migrating db from postgresql to mysql, Miles Fidelman, 10/27/2014
-
Re: [sympa-users] migrating db from postgresql to mysql,
Amos, 10/27/2014
-
Re: [sympa-users] migrating db from postgresql to mysql,
Miles Fidelman, 10/27/2014
-
RE: [sympa-users] migrating db from postgresql to mysql,
Jérôme Zittoun, 10/27/2014
Archive powered by MHonArc 2.6.19+.