Powered by Invision Power Board


  Reply to this topicStart new topicStart Poll

> I'd like to upgrade MySQL... some question
fabrizio
Posted: Nov 12 2006, 01:48 PM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Hello,
I have a dedicated server and I was wondering if is possible to upgrade MySQL to at least version 4 since I would need to use UNION queries.

If that's possible, here are my questions:

1. What possible problems a such upgrade could involve either for compatibility with previous code or server reliability?

2. What version do you think would be better to upgrade to? I would leave to you the choice since you would do the upgrade (if possible of course).

Any information is very welcome!

Thank you in advance.

Sincerely,


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
Matt
Posted: Nov 13 2006, 02:51 PM
Quote Post





Group: Members
Posts: 1,103
Member No.: 342
Joined: 25-November 03



You can upgrade to either the latest stable release of Mysql 4.1 or 5.0, whichever you would prefer.

The basic steps for upgrading to MySQL 5.0 would be:

1) Backup the /var/lib/mysql directory

2) Go to

http://dev.mysql.com/downloads/mysql/5.0.html

and download the rpms in the following categories:

Server
Client programs
Libraries and header files
Shared compatibility libraries

3) Uninstall the HSPC Application template for Mysql.

4) Install the RPMs downloaded in step 2.

During this process we have found that frequently complications will arise that need to be worked out for MySQL to run. Once these problems have been fixed, we have found that newer versions of MySQL have been backward compatible with earlier versions.

If you wish, we can upgrade MySQL to the version that you wish for our $75.00 an hour program installation rate. An upgrade of MySQL typically takes one to two hours. If you are interested in this option email support@advantagecom.net.


--------------------
Matt B.
Advantagecom Technical Support

Private messages are ignored unless solicited. If you have a support question, please email support@advantagecom.net, post in the appropriate section of the forum, or call if your service plan allows support by phone.
PMUsers Website
Top
fabrizio
Posted: Nov 13 2006, 05:21 PM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Thank you very much Matt. I'll think what to do.

All the best,
Fabrizio


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
fabrizio
Posted: Jan 17 2007, 09:14 AM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Matt, I know this thread is old, but I have a follow-up: I'd like also to upgrade to the latest stable version of PHP 4.x (4.4.4). How can I upgrade this package too? Please, let me know.

Thank you again.

Sincerely,
Fabrizio.


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
Jonathan
Posted: Jan 18 2007, 02:51 PM
Quote Post





Group: Members
Posts: 267
Member No.: 5
Joined: 12-July 02



When it comes to installing a newer version of PHP, I would suggest that it be compiled from source, which is not too hard as long as you are familiar with working on your VPS from a bash prompt (SSH into the server). You should be able to find the desired version of PHP from php.net. Then you can go through the process similar to the way I described it in a previous post:

http://forum.schmolie.com/index.php?showto...findpost&p=3548

But you will want to just use that as an example, some things will be different like the version, and possibly some issues may come up along the way which you can deal with by installing what ever else it may need. I do not expect it to be very much different than what I showed in the post. Also, be sure to uninstall the PHP that you have installed from the HSPC control panel first, this is very important. HSPC installed applications have a potential to be updated from time to time, and that would cause problems if you just compiled and installed over the HSPC application.

This is something you can have us do for you, for a fee. If you are interested in having us take care of this for you, let us know and we can put together a quote for the job.


--------------------
Jonathan Kinney
Data Systems Specialist
Please note, Private Messages will be ignored.
PMUsers Website
Top
fabrizio
Posted: Feb 8 2007, 06:54 AM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Thank you Jonathan for your reply and sorry for my delay in responding.

Yes, sounds possible to do by myself, but I'd like to know how much would be the cost to have the job done by you. Is it possible to have a quote?

Thank you Jonathan!

Sincerely,
Fabrizio


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
Matt
Posted: Feb 8 2007, 08:43 AM
Quote Post





Group: Members
Posts: 1,103
Member No.: 342
Joined: 25-November 03



To upgrade both PHP to PHP 4.4.4 (or PHP 5.x) and MySQL to version 4.x (or 5.x) typically takes two to three hours at our $75.00 per hour Program Installation and Configuration rate.

In the past, we have not run into any issues upgrading php or mysql to custom versions that have not been resolvable within that two to three hour estimate. Each situation is unique so it is possible, although unlikely, that there may be some additional issues to work out.


--------------------
Matt B.
Advantagecom Technical Support

Private messages are ignored unless solicited. If you have a support question, please email support@advantagecom.net, post in the appropriate section of the forum, or call if your service plan allows support by phone.
PMUsers Website
Top
fabrizio
Posted: Feb 17 2007, 11:26 AM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Matt,
thank you for your reply and sorry for my delay, I wasn't notified of your reply by e-mail... huh.gif

Well, actually I would go ahead and ask you to install those upgrades for me, I prefer to spend those money and save time for my other duties.

Now, I am wondering what is better for me to do: upgrade directly PHP to 5.x and MySQL to 5.x or upgrade to the latest PHP 4.x and MySQL 4.x version? Could be there any related or retro-compatibility issue by installing the very latest (stable) versions of both packages?

Any advice is very welcome.

Thank you!

Sincerely,
Fabrizio


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
Jonathan
Posted: Feb 19 2007, 01:32 PM
Quote Post





Group: Members
Posts: 267
Member No.: 5
Joined: 12-July 02



I personally would suggest going to the latest stable of both. I do know of a few changes in PHP that have been known to cause issues in older versions of various PHP based applications, but those incidents came to pass after a 4.3.x upgraded to a 4.4.x version. The only things I would suggest that you watch out for are applications installed via HSPC that use MySQL or PHP, those may have issues when you take the suggested step of uninstalling MySQL and PHP from the control panel before the upgrade. What ever the case, we will gladly help you though any complications as a result of the upgrade, should they arise.


--------------------
Jonathan Kinney
Data Systems Specialist
Please note, Private Messages will be ignored.
PMUsers Website
Top
Matt
Posted: Feb 19 2007, 03:32 PM
Quote Post





Group: Members
Posts: 1,103
Member No.: 342
Joined: 25-November 03



PHP.net has the following info regarding migrating from PHP 4 to PHP 5:

http://us3.php.net/manual/en/migration5.php


--------------------
Matt B.
Advantagecom Technical Support

Private messages are ignored unless solicited. If you have a support question, please email support@advantagecom.net, post in the appropriate section of the forum, or call if your service plan allows support by phone.
PMUsers Website
Top
fabrizio
Posted: Feb 19 2007, 04:52 PM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Thank you guys for your helpful information.

I think will be best to upgrade to the most stable 4.x versions of both, actually I would need PHP 4.3.3 or greater and MySQL 4.0.16 or greater to be able to run the latest version of vBulletin and to "stay up" with the versions of both PHP and MySQL. Actually at the moment I don't need 5.x features. Probably to upgrade MySQL from 3.23 to 4.x and PHP from 4.3.1 to 4.4 (or the latest stable 4.x version) is the best secure way for my case.

I'd like to monitor the system right after the upgrade, so I'd really like to schedule a date for such an upgrade with you in order to talk with you right away if needed. When is the best time during the week (in the coming weeks) to perform this upgrade for you? I have a pretty flexible schedule, so I leave you the choice.

Thank you again!

Fabrizio.



--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
Jonathan
Posted: Feb 22 2007, 03:12 PM
Quote Post





Group: Members
Posts: 267
Member No.: 5
Joined: 12-July 02



Please send an email to support, and we can work out the details, thanks.


--------------------
Jonathan Kinney
Data Systems Specialist
Please note, Private Messages will be ignored.
PMUsers Website
Top
fabrizio
Posted: Feb 23 2007, 06:21 AM
Quote Post





Group: Members
Posts: 156
Member No.: 19
Joined: 16-July 02



Ok Jonathan, thank you.

Best,
Fabrizio


--------------------
-----------------------------------------
Fabrizio Ferrari - 'Violinist, contemporary and computer music composer'
E-MAIL: fabrizio@virtualsheetmusic.com
http://www.musicianspage.com
http://www.virtualsheetmusic.com
PMUsers Website
Top
0 User(s) are reading this topic (0 Guests and 0 Anonymous Users)
0 Members:

Topic Options Reply to this topicStart new topicStart Poll