1
Rhomal
Highest version of mysql inquiry
  • 2006/9/7 15:45

  • Rhomal

  • Quite a regular

  • Posts: 274

  • Since: 2004/10/5


What is the latest ver of MySQL can I use with the XOOPS 2.2 branch?

Currently I am using 4.0.23

Thanks for any info.

2
Dave_L
Re: Highest version of mysql inquiry
  • 2006/9/7 16:10

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


I'm using XOOPS 2.2.4 with PHP 5.1.4 and MySQL 5.0.22, and haven't noticed any problems.

Of course, some modules may have issues.

3
Rhomal
Re: Highest version of mysql inquiry
  • 2006/9/8 11:51

  • Rhomal

  • Quite a regular

  • Posts: 274

  • Since: 2004/10/5


Quote:

Dave_L wrote:
I'm using XOOPS 2.2.4 with PHP 5.1.4 and MySQL 5.0.22, and haven't noticed any problems.

Of course, some modules may have issues.


Thank you for the reply. So that forces the question is it a simple matter of backing up the site db, uninstalling the current MySQL and simply reinstalling the new ver and popping the db back in?

Is there any config file I need to edit in XOOPS itself?

4
svaha
Re: Highest version of mysql inquiry
  • 2006/9/8 12:31

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


I had some problems lately porting a database from my own server (mysql 5.1) to a server on the internet (mysql 4.0)
I had a lot of question marks in my text.
I found out that the one used utf collation and the other (older one) iso 8859.

5
Rhomal
Re: Highest version of mysql inquiry
  • 2006/9/9 11:20

  • Rhomal

  • Quite a regular

  • Posts: 274

  • Since: 2004/10/5


Quote:

svaha wrote:
I had some problems lately porting a database from my own server (mysql 5.1) to a server on the internet (mysql 4.0)
I had a lot of question marks in my text.
I found out that the one used utf collation and the other (older one) iso 8859.


hhmmm so does that mean I should upgrade to the latest 4.x series rather then the 5.x branch?

If I understand you you are saying the 4.x and 5.x use a different data format and cant read each others data?

6
Dave_L
Re: Highest version of mysql inquiry
  • 2006/9/9 11:36

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Quote:
Thank you for the reply. So that forces the question is it a simple matter of backing up the site db, uninstalling the current MySQL and simply reinstalling the new ver and popping the db back in?

Is there any config file I need to edit in XOOPS itself?


That sounds right. In my case, it was a clean install of a new O/S, so I didn't need to uninstall the old version of MySQL. The XOOPS configuration doesn't need changing.

Quote:
hhmmm so does that mean I should upgrade to the latest 4.x series rather then the 5.x branch?

If I understand you you are saying the 4.x and 5.x use a different data format and cant read each others data?


Some people have posted here that they've had conflicts with MySQL 5, but I haven't encountered any problems.

MySQL 5 can import a MySQL 4 backup. If you make a backup from MySQL 5 for import into MySQL 4, you need to specify compatibility mode.

7
svaha
Re: Highest version of mysql inquiry
  • 2006/9/22 8:20

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Quote:

Rhomal wrote:
Quote:

svaha wrote:
I had some problems lately porting a database from my own server (mysql 5.1) to a server on the internet (mysql 4.0)
I had a lot of question marks in my text.
I found out that the one used utf collation and the other (older one) iso 8859.


hhmmm so does that mean I should upgrade to the latest 4.x series rather then the 5.x branch?

If I understand you you are saying the 4.x and 5.x use a different data format and cant read each others data?


What Dave_L writes about this is correct, you can use 5.x, just pay attention if you are porting from MySQL 5.x to 4.x

8
McNaz
Re: Highest version of mysql inquiry
  • 2006/9/22 8:41

  • McNaz

  • Just can't stay away

  • Posts: 574

  • Since: 2003/4/21


Personally I would stick with mySQL 4.x as I have experienced issues with some modules.

mySQL would offer you the best compatibility with existing modules.

Login

Who's Online

56 user(s) are online (36 user(s) are browsing Support Forums)


Members: 0


Guests: 56


more...

Donat-O-Meter

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

Latest GitHub Commits