XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / Should I upgrade to mysql 5.0?
Register
1
boumbo
Should I upgrade to mysql 5.0?

  • 2007/1/9 7:21

  • boumbo

  • Just popping in

  • Posts: 37

  • Since: 2006/9/25


Hi,

I am presently running XOOPS ver 2.2.2 on MySQL 4.1 on my production site.

Is it better for me to upgrade to MySQL 5.0? If not, could you please tell me what would be the advantages of staying with 4.1?

If so, is there something I have to pay attention to with 5.0 when I do the upgrade?

Also, should I upgrade ver 2.2.2 to 2.2.3a? Is this the most recent version? Is it worth the update?

Thank you.
2
wizanda
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 12:04

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


5 is the way forward and XOOPS does work on it....might also try upgrading to 2.2.5rc2 also if you are 2.2....as there will be bug fixes
3
Peekay
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 12:53

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Perhaps one day, the Xoops.org module repository will be searchable by system requirements - e.g. only show modules that the developer has categorically stated will work in (or at least has been developed using) XOOPS 2.0.16, XOOPS 2.2.5, PHP 5, MySQL 6, register_globals 'off' etc, etc.

Without this information, you have to accept the risk that PHP and MySQL upgrades will probably result in broken modules.
A thread is for life. Not just for Christmas.
4
boumbo
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 18:28

  • boumbo

  • Just popping in

  • Posts: 37

  • Since: 2006/9/25


Thanks for the prompt reply.
Is the version 2.2.5rc2 a stable version fully functional, if not whats the latest most stable version?

Can I do a direct upgrade from XOOPS 2.2.2 to 2.2.5rc2 or does it have to be a step by step upgrade from 2.2.2 to 2.2.3 to 2.2.4 to 2.2.5? Also, do you know where I can download the upgrade?

As I explained I have XOOPS ver 2.2.2 and MySQL 4.1 on my production site.

I am also setting up a TEST site with the following setup:

with Apache web server v2.0.52, MySQL v14.7 (Distrib 4.1.20), and XOOPS v2.0.16.

If I drop in the database info and content from my Production site to the TEST site will there be a problem in the transfer? Should have the same XOOPS version setup to be safe?

Thanks again
5
Dave_L
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 20:27

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


I've been using XOOPS 2.2.4 with MySQL 5 for a while without any problems. But I don't have very many third-party modules.

When you say "drop in the database info", I'll assume you mean export your old database as an .sql file and then import the .sql file into the new MySQL server, which is the correct way to do it. The alternative method of copying the raw database files may not work when going from one MySQL version to another.

It would probably be better to upgrade XOOPS first, since a newer version of XOOPS is less likely to have issues with a newer version of MySQL.

The most important thing to is do complete backups at each step, so you can always get back to where you were.
6
stefan88
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 22:13

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


Quote:
If I drop in the database info and content from my Production (2.2.2) site to the TEST (2.0.16) site will there be a problem in the transfer?


I'm not shure the database structure is the same. There should be different config for those versions, also extended profile and private message modules ...
..
7
vaughan
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 22:18

  • vaughan

  • Friend of XOOPS

  • Posts: 680

  • Since: 2005/11/26


stefan is correct.. you can't use a MySQL dump from a XOOPS 2.2.x database to restore into a XOOPS 2.0.x site.

you would have to convert your 2.2 site to 2.0.16 1st, and then create the backup..
8
boumbo
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 23:15

  • boumbo

  • Just popping in

  • Posts: 37

  • Since: 2006/9/25


Quote:
stefan is correct.. you can't use a MySQL dump from a XOOPS 2.2.x database to restore into a XOOPS 2.0.x site.

you would have to convert your 2.2 site to 2.0.16 1st, and then create the backup..


In this case, is there a direct upgrade from XOOPS 2.2.2 to 2.0.16?

If so, could you direct me to the URL for the download of the upgrade?

Thanks.
9
boumbo
Re: Should I upgrade to mysql 5.0?

  • 2007/1/9 23:20

  • boumbo

  • Just popping in

  • Posts: 37

  • Since: 2006/9/25


Quote:

Dave_L wrote:
When you say "drop in the database info", I'll assume you mean export your old database as an .sql file and then import the .sql file into the new MySQL server, which is the correct way to do it.
...
The most important thing to is do complete backups at each step, so you can always get back to where you were.


Yes thats what I mean, sorry I know dropping the database would be a different action.
10
stefan88
Re: Should I upgrade to mysql 5.0?

  • 2007/1/10 9:42

  • stefan88

  • Community Support Member

  • Posts: 1086

  • Since: 2004/9/20


Quote:
In this case, is there a direct upgrade from XOOPS 2.2.2 to 2.0.16?


Hi,

I believe there was a downgrade script from 2.2.? to 2.0.? (I don't remember the versions). You may have a look at:

https://xoops.org/modules/newbb/viewtopic.php?topic_id=51369&forum=20&post_id=248911#forumpost248911

https://xoops.org/modules/newbb/viewtopic.php?topic_id=53405&viewmode=flat&order=ASC&start=0

or do a search for "downgrade"

There was a roadmap for development, but the one I found a link to say "You don't have access ..."

Generaly the plans were:

2.0.x ----> 2.3.x -----> 2.4
2.2.x -----------------> 2.4

My advice would be: if you have a working web site and you are happy with it - don't brake it. Just wait and see where the things will go.
If you decide to go for change - do as complete backup as possible (database and files) and do experiment on a non production setup first.
..

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

399 user(s) are online (306 user(s) are browsing Support Forums)

Members: 0

Guests: 399

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits