Problems with Wordpress 2.9 and 1and1 hosting MySQL Version
Print This Post
Email This Post to a Friend
I am posting this looking for a bit of help from the blogging community. I have said in the past that I use 1and1 for my hosting and up until now things seemed to be ok, well yesterday things took a bit of a turn for the worse.
There is a release candidate out for Wordpress 2.9 that I tried to install yesterday and amongst my blogs I have a mix of MySQL 4.0 and 5.0 databases, well the version for the MySQL 4.0 databases is at 4.0.27 and the minimum requirement for Wordpress 2.9 is currently MySQL 4.1.2
So I looked through the documentation with 1and1 and I saw that the best way to change things is to create a MySQL database 5.0 version and then export the old database, import to the new empty database and I would be good. The trouble I had was that the database export was to big to import to the new database (2 meg limit) so I am still stuck.
I am sure that 1and1 must me aware of this by now, with 1,000 of people possible having trouble with an upgrade in the next few days, and the support tickets that I opened were not handled correctly with the emails coming back telling me how to create a new database only.
So I am hoping that one of two things happens. I hope that 1 and 1 hosting upgrades all the MySQL databases to 4.1.2 from the current patch level or that there is some easier way to upgrade my current MySQL 4.0 databases to MySQL 5.0
Entries (RSS)
Hi Bill, here is what I went through to do this upgrade on 1&1 (step-by-step).
What I learned upgrading to WordPress 2.9
The 1and1 help documentation leaves out a lot of details.
What I found is that even though you can’t import a file over 2,048kb, you can open your SQL export dump in a text editor, copy the text, and paste it into the Import window in phpMyAdmin. My file was 4.6GB and this worked fine.
I was able to export my MySQL 4 database to a new MySQL 5 database, edit my wp-config.php file, and upgrade to Wordpress 2.9. However, I’m noticing “junk” in the form of random question marks appearing on various posts, but not all. Any thoughts on how to fix this?
Jon, you exported and/or imported your database incorrectly. You can try to fix the special characters using a search & replace but you’d be better off just exporting and importing correctly. If you’re doing this from the command line, use the -r switch.
mysqldump databasename -uusername -ppassword -rexport.sql
Unfortunately, I don’t have SSH access on my hosting package. I would have to use phpMyAdmin to export the settings. Initially, I just used Wordpress’s backup feature (that comes built in under the tools menu).
Would you happen to know what incorrect settings were included in Wordpress’s default backup feature?
[...] used: How to downgrade from 2.8 to previous version? What I Learned Upgrading to WordPress 2.9 Problems with Wordpress 2.9 and 1and1 hosting MySQL Version February 28th, 2010 | Category: Site News, [...]