| 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:
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? 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? 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:
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. |