Posted by Shai on March 2, 2012 at 4:28am
Hi Folks,
I lease a dedicated server running CentOS 5.7 with MySQL 5.0.x. I have about 20 Drupal sites installed: 1 D5, 15 D6, and 5 D7.
I need to upgrade my server to run MySQL 5.1.x in order to install CiviCRM 4.1 on one of the D7 sites. I've set up a test server on a VPS which is running MySQL 5.1.x. I have moved over a few of the sites for testing. Things seem okay, but I'm just "clicking around." What should I be looking for or in what ways can I test to see if there are any problems.
I'm embarrassed to say that i don't even know how to run the tests that are built in to Drupal 7.
But I'm most concerned about the Drupal 5 site.
Any suggestions?
Thanks in advance,
Shai
Comments
I wouldn't worry about D7.
I wouldn't worry about D7. MySQL 5.1 has been out for a long time, so I'm sure there are even D5 sites running on it.
The only real difference to watch out for between MySQL 5.0 and 5.1 is that collations changed substantially - if you have any multibyte characters, watch out for lost translations and double-check the collations transfer.
The other thing you may need
The other thing you may need to do with a Civi installation is grant the SUPER permission to the MySQL user as is mentioned here.
Tests themself may be run by enabling the Simpletest module (core) on Drupal 7 although in Drupal 5 the simpletest module was in contrib-space.