Portal Home > Knowledgebase > Articles Database > Worst case senario for a switch ?
Worst case senario for a switch ?
| Posted by Energizer Bunny, 12-17-2008, 09:11 PM |
| Worst case senario for a switch ?
Hiyall,
What is the worst case scenario that one can face if they switched all the sudden from mysql 4.1 to mysql 5 ? Are both similar to each other ? Anyone have experiences to share maybe as to what happened when you switched from 4.1 to 5 ?
I am kinda worried as to breaking up sites and wrecking havoc ( i got bunch of wordpress blogs, vb forums, smf forum and phbb too )
Also what can one expect if moving from say 4.1 based hosting to version 5 based hosting ? Say if someone has backup from 4.1 version and they try to restore it on a host with 5 ?
__________________âÂÂView My DNS provides Dns Report, Is my Website Down checks and more â Clients testimonials:" These guys are very responsive and understanding. I love them."-"I have been with this company for over 2years now. Zero down time "-"The ONLY web hosting company that I recommend to use"->â A1 Web Hosting SolutionsâÂÂ<- Ultimate Proxy Hosting @ ->phpproxyhost.com<-
|
| Posted by bager, 12-17-2008, 10:03 PM |
| Backup the databases and try to update. I don't think there are major changes and blogs forums etc are compatible with both versions mysql 4 or 5.
|
| Posted by Rageki-John, 12-17-2008, 10:29 PM |
| It all depends on whether the script is compatible at all with the newer version. If it is, I don't think there would be any problems. However, if it isn't you might end up with errors and being forced to downgrade back to make your script work again.
__________________Rageki Web Hosting Solutions - Canada
|
| Posted by MikeDVB, 12-17-2008, 11:49 PM |
| The format of the databases themselves are slightly different which can cause some issues. I don't remember if MySQL updates the databases automatically during the upgrade but I know that you should back up all of the databases before making the change just in case.
There are utilities that can upgrade the databases to MySQL5 off-server if you need to but I cannot think of one off hand.
__________________â Michael Denney - MDDHosting, LLC - Professional Hosting Solutionsâ Shared, Reseller, Semi-Dedicated, VPS, and Dedicated â http://www.mddhosting.com/
|
| Posted by Mxhub, 12-18-2008, 12:22 AM |
| bunny, i assume you are running on cpanel server.
After you have set to 5.0 for mysql in tweak settling, you have to recompile apache
|
| Posted by Energizer Bunny, 12-18-2008, 01:13 AM |
| Quote:
Originally Posted by Mxhub
bunny, i assume you are running on cpanel server.
After you have set to 5.0 for mysql in tweak settling, you have to recompile apache
|
Add to Favourites 
Print this Article
Also Read
