Subject: The mailing list for listmasters using Sympa
List archive
[sympa-users] migrating db from postgresql to mysql
- From: Amos <address@concealed>
- To: "address@concealed" <address@concealed>
- Subject: [sympa-users] migrating db from postgresql to mysql
- Date: Fri, 24 Oct 2014 15:34:43 -0500
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+.