upgrading SQl 3.x to 5

M

mtelman

New member
Joined
Aug 14, 2007
Messages
4
Location
Pontiac, MI
I have been trying to upgrade mySQL in DA and my tech staff tells me there are several issues in upgrading mySQL due to DA. Can some one help me with the upgrade process??

Thank You
Mark Telman
 
well this is really about the issues in upgrading mySQL from 3.25 to 5.0 and the database issue that arise

if anyone can help my server techs don't seem to want to help

Thanks
Mark
 
mtelman said:
I have been trying to upgrade mySQL in DA and my tech staff tells me there are several issues in upgrading mySQL due to DA. Can some one help me with the upgrade process??
Click to expand...
There are no technical issues when upgrading MySQL on a DA powered server. I am interested to know these issues, if your host can share them with you. Before you attempt to upgrade MySQL, backup your entire MySQL DBs, just in case.
 
The issue must be there time then. They told me that there were password issues that might not work even with the old_password addition. I think they just want me to do it. I am not a unix guy and so don't know the invironment very well so you can see why I'm shy. I have blown up a few servers in my day, so I was tring to get them to help. they wanted 10 hrs of $75 per
But i regress.

I looked at the installer the other user told me about but mySQL is only ver 3.25 and so the installer does not see it.(4.0 or newer) so still a delema

More help needed

Thanks
Mark
 
mtelman said:
I looked at the installer the other user told me about but mySQL is only ver 3.25 and so the installer does not see it.(4.0 or newer) so still a delema

More help needed
Click to expand...
The password issue is not a problem at all when updating to a higher version. I am not sure what kind of help do you need here :confused:

I suggest you seek professional help either from your host, or a different company. Good luck!
 
mtelman said:
I have blown up a few servers in my day, so I was tring to get them to help. they wanted 10 hrs of $75 per

Thanks
Mark
Click to expand...

The place to start is just researching upgrading MySql from 3 to 5 independent of DA. I can see why the techs are hesitant. Unless you are very familiar with the DB and feature changes time vanishes in a hurry if things go wrong in an upgrade.

I would:
-download a back up of the database
-install 3.25 on a local machine, install the db
-do a dry run upgrade, you will then know what to expect
-if you don't feel confident after that hire a pro

You could also install 5 on your server running on a different port. This would allow you to have 3.25 and 5 running at the same time and allow you a safe transition. If anything when wrong you could simply replace your mySql connection strings to the old port.
 
You must log in or register to reply here.
Back
Top