Welcome to WebmasterWorld Guest from 54.147.20.131

Forum Moderators: rogerd & travelin cat

Message Too Old, No Replies

1&1 Hoses WordPress Sites on May 1, 2013

Migrate MySQL 4 DB NOW to MySQL 5 or Lose Your Site

     

martinibuster

3:03 pm on Mar 26, 2013 (gmt 0)

WebmasterWorld Administrator martinibuster is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



1and1.com is "deactivating" MySQL 4 Databases on May 1st, 2013. All WordPress sites hosted on 1and1.com that have not migrated their databases from the old database to the new MySQL 5 databases may have their sites go offline. 1and1.com doesn't explicitly say the sites will go down, but their email states that they will be deactivating the MySQL 4 databases, which implies that sites not migrated may go dark.

If you host a database driven site on 1and1.com, log in, go to MySQL Administration and check what version of MySQL your site is using.

Full instructions here:
http://faq.1and1.com/web_space__access/mysql/20.html [faq.1and1.com]


The information below applies only to Linux Hosting packages with MySQL 4 databases. MySQL 4 is being phased out and therefore any data held within a MySQL 4 database must be migrated into a new MySQL 5 database.

Why is the migration not done automatically?
The migration can not be carried out automatically because of some features of MySQL 4 are not supported in MySQL 5 and in order to minimize the amount of transmission and handling of your private data. Because of this we are allowing customers to carry out the migration on their own, at their leisure.

How do I know if my databases are affected?
Any database created in the 1&1 Control Panel that says MySQL 4 as the version, will need to be migrated to a newly created MySQL 5 database. You can check what version of MySQL your databases are by logging into your 1&1 Control Panel and clicking on MySQL Administration from the Domains & Web Space section.

ergophobe

8:09 pm on Mar 26, 2013 (gmt 0)

WebmasterWorld Administrator ergophobe is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



Goodness. People are still on MySQL 4? MySQL 5 was released Dec 24, 2003. That's 10 years ago. Granted, it took some time to become stable, but it's been stable for quite some time.

- last MySQL 4.x release: 2008
- last Apache 1.x release [EOL]: 2010

And yet, who's on Apache 1.3?

Rosalind

12:56 pm on Mar 27, 2013 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I wonder what percentage this will affect? You have to have had a database created before they started automatically installing MySQL 5 databases, and they don't say in the FAQ when they started doing this.

ergophobe

5:50 pm on Mar 27, 2013 (gmt 0)

WebmasterWorld Administrator ergophobe is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



For most hosts this is dependent on CPanel (not sure if 1&1 uses CPanel or not though).

Anyway, CPanel stopped supporting MySQL 4 with the 11.32 release (Dec 4, 2012) and announced the change on Sept 11, 2012.

[cpanel.net...]
[docs.cpanel.net...]

ergophobe

5:52 pm on Mar 27, 2013 (gmt 0)

WebmasterWorld Administrator ergophobe is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



Per the MySQL Support Lifecycle policy, extended support for MySQL 4.1 ended on December 31, 2009. MySQL users are encouraged to upgrade to a current production release of MySQL.

-- [mysql.com...]

rogerd

10:18 pm on Mar 27, 2013 (gmt 0)

WebmasterWorld Administrator rogerd is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Funny how the announcement makes it sound like letting customers be responsible for the migration is a big benefit. "At their leisure..." :)

I'm sure there are loads of users who have no clue as to what version of MySQL they are running, or even what MySQl is.

A better approach would have been to identify customers with active MySQL 4 databases and proactively offer to assist them in the transition.

DirigoDev

10:50 pm on Mar 27, 2013 (gmt 0)

10+ Year Member



"1and1" and "better approach" in the same post. LOL. No kidding. I've never heard of 1and1 doing anything proactive.

I do like their website builder TV commercial in the USA. Makes it look easy and all SEO friendly.

martinibuster

11:52 pm on Mar 27, 2013 (gmt 0)

WebmasterWorld Administrator martinibuster is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



A better approach would have been to identify customers with active MySQL 4 databases and proactively offer to assist them in the transition.


Yes. At the very least 1and1 could have limited the announcement to those who were actually affected. My hosting accounts weren't affected but I still received the announcement, causing me about an hour of anguish.

rsndll

9:38 pm on Mar 28, 2013 (gmt 0)

5+ Year Member



They also don't warn you that you'll run into problems if you continue to use their default php version (4) when you upgrade to MySQL 5
 

Featured Threads

Hot Threads This Week

Hot Threads This Month