hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Compatibility of mysql 5 with mysql 4
Reply

Hosting Security and Technology Configuring and optimizing web hosting servers and operating systems, developing administration scripts, building servers, protecting against hackers, and general security (SSL certificates, etc.)
Forum Jump

Compatibility of mysql 5 with mysql 4

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 09-16-2009, 11:38 AM
Dr_Michael Dr_Michael is offline
cPanel is your friend
 
Join Date: Jul 2002
Location: World Wide Web
Posts: 1,195

Compatibility of mysql 5 with mysql 4


Are there any known issues regarding the upgrade of mysql from 4 to 5? I mean are there any known scripts which may face problem with mysql 5?
I have a dedicated server with mysql 4.1.22 and I am looking to upgrade to mysql 5 but I worry for my clients hosted. Some of them are using very old scripts such as oscommerce, phpbb, yabb, etc.

__________________
Michael Vlastos
HostWired.com - Innovative Hosting Solutions since 2005 | cPanel, Softaculous
Personalized support | No site suspensions | No overloaded servers | Green Hosting
Multiple Backups | Average Response Time: 15 min | Toll Free: 1-855-ECO-HOST

Reply With Quote


Sponsored Links
  #2  
Old 09-16-2009, 02:01 PM
nomankhn nomankhn is offline
Aspiring Evangelist
 
Join Date: Sep 2007
Posts: 361
*

Quote:
Originally Posted by Dr_Michael View Post
Are there any known issues regarding the upgrade of mysql from 4 to 5? I mean are there any known scripts which may face problem with mysql 5?
I have a dedicated server with mysql 4.1.22 and I am looking to upgrade to mysql 5 but I worry for my clients hosted. Some of them are using very old scripts such as oscommerce, phpbb, yabb, etc.
Yes, you are right it create problem, few months before i have upgraded a ticket system their database structure is based on mysql 4.x and i was updating on mysql 5.x, i just did it for testing and after that make ticket system for testing with updated structure, it is not working, as it should be expected, then i have reviewd the forums and did the patches of database, after that everything looks fine. I suggest you will do one by one on a testing server then after fixing the all issues deploy in production server. My database was 34 GB, it took me 2 days to continue patching without any break.

__________________
Thanks,
Noman
noman@linuxonsupport.com
O Canada, we stand on guard for thee

Reply With Quote
  #3  
Old 09-16-2009, 02:32 PM
fabin fabin is offline
Web Hosting Evangelist
 
Join Date: Mar 2009
Location: Gods Own Country
Posts: 530
backup all the databases before the upgrade..

Reply With Quote
Sponsored Links
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help, I moved Mysql from /var to /backup/mysql, mysql is no longer working pcnet21 Hosting Security and Technology 4 05-09-2009 01:58 AM
Installed MySQL in /usr/local/mysql but error in /var/lib/mysql guest3 Hosting Security and Technology 1 01-21-2007 06:38 PM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) manisha_khtri Hosting Security and Technology 2 06-05-2006 10:05 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. atul Hosting Security and Technology 5 05-11-2004 12:24 AM
Problem with /var/lib/mysql/mysql.sock after MySQL upgrade oldford Dedicated Server 9 07-30-2003 11:35 AM

Related posts from TheWhir.com
Title Type Date Posted
Eucalyptus Systems Offers Extended AWS Compatibility with Version 3.3 Web Hosting News 2013-05-03 12:53:22
WHD.global 2013: ARPU Wars with BaseKit VP of User Experience and Community Web Hosting News 2013-03-21 07:59:47
Web Host Rackspace Launches Private Beta for MySQL Cloud Database Web Hosting News 2011-12-01 21:09:51
Web Hosting Software Firm CloudLinux Releases CloudLinux OS Version 6.1 Web Hosting News 2011-09-13 14:08:49
Gazzang Data Encrytion Solution Adds Support for CloudLinux Platform Web Hosting News 2011-06-30 18:54:10


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?