Subject:*
<
Name/Email:*
<
Message Icon:*
<
Select*
<
Message:*
<



Click the Preview to see the content in action.
Options:*
<
Confirmation Code*
<
0 + 8 = ?  
Input the result from the expression
Maximum attempts you can try: 10
*
<
     

Re: Highest version of mysql inquiry
by McNaz on 2006/9/22 8:41:38

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.
Re: Highest version of mysql inquiry
by svaha on 2006/9/22 8:20:19

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
Re: Highest version of mysql inquiry
by Dave_L on 2006/9/9 11:36:19

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.
Re: Highest version of mysql inquiry
by Rhomal on 2006/9/9 11:20:04

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?
Re: Highest version of mysql inquiry
by svaha on 2006/9/8 12:31:23

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.

Who's Online

217 user(s) are online (148 user(s) are browsing Support Forums)


Members: 0


Guests: 217


more...

Donat-O-Meter

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

Latest GitHub Commits