CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • What's best method of upgrading from MySQL 4.1
Pages: [1]

Author Topic: What's best method of upgrading from MySQL 4.1  (Read 1499 times)

backdrifting

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 2
What's best method of upgrading from MySQL 4.1
April 30, 2008, 09:22:13 am
I have a database that is from a server running MySQL 4.1 with CiviCRM 1.9.  I've moved all of this over to my dev server which is running MySQL 5.x.   However when I try upgrading CiviCRM to version 2.0 or 2.0.3 I'm getting a ton of errors.  Most of which appear to be related to the original version of the MySQL database.

So my question - is it even possible to do this upgrade with data from MySQL 4.1.  Or should I just rebuild all of my CiviCRM forms in version 2.0.3 with a brand new database.

I don't have a lot of time to troubleshoot the MySQL errors and it's starting to get extremely frustrating.  I cross posted some of the errors I'm getting on the "Installing with Drupal" forum as well.

So please let me know what the best practice is of dealing with MySQL 4.1 data.

Thanks.

speleo

  • Ask me questions
  • ****
  • Posts: 396
  • Karma: 28
  • CiviCRM version: 4.3.1
  • CMS version: J! 2.5,9
  • MySQL version: 5.1
  • PHP version: 5.3.24
Re: What's best method of upgrading from MySQL 4.1
April 30, 2008, 11:03:32 am
Unless I miostaken 1.8 was the last version that ran with mysql 4.1. When I upgraded from mysql 4 > 5 I simply upgraded the codebase.

If you going to do it it would make sense to jump to 2.0.3 and go though the normalisation process. You can do that on your dev server after suspending the live db and then just reload the new db back to production with the 2.0.3 code base. Of course if our running anything special you will want to test functionality on your dev server first.

acrosman

  • Guest
Re: What's best method of upgrading from MySQL 4.1
April 30, 2008, 11:20:49 am
My experience with upgrading versions of MySQL is that it's usually very simple.

Note: Always backup you data before doing anything to the server!

If you have using a Linux distro with package management, it's likely that the packages are just there, and you can select the MySQL 5 packages, deselect the MySQL 4 packages, and the distro maintainers will have done the rest of the work for you.

If you have installed it from a MySQL pre-compiled binary, just down load the new binary, and follow the install instructions.  There can sometimes be issues making sure you re-link all the libraries right to make PHP happy, but that's usually not a problem.

If you have compiled it yourself, then either you know enough to repeat the process, or you followed instructions somewhere.  They probably haven't changed much, so you could probably follow them again.

The hardest part in my experience is making sure the PHP libraries don't have trouble.

Aaron

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • What's best method of upgrading from MySQL 4.1

This forum was archived on 2017-11-26.