| User | Post |
|
9:36 AM
Jan 8, 2010
|
NickyD
| | USA | |
| Moderator
| posts 86 |
|
|
Hi-
I just tried updating to the newest version of word press, but got the following error message:
"The update cannot be installed because WordPress 2.9.1 requires MySQL version 4.1.2 or higher. You are running version 4.0.27."
I emailed Go Daddy, my host, about this, and got this response.
"Unfortunately the only way to upgrade the MySql is to create a new MySql and choose an updated version. "
My question, how does this get handled. If I choose a new MySql, will I lose all my old material?…..would my blog have to start again from scratch?
I am not too great with my knowledge of word press, or MySql.
Anyone have a advice for me?
Thanks.
|
|
|
10:05 AM
Jan 8, 2010
|
Sean
| | USA | |
| Admin
| posts 135 |
|
|
Make a backup of your current WordPress databases for each site. I believe GoDaddy hosting has access to phpMyAdmin to do this. Be sure to export out everything for each database and name the file something you can associate with each site.
Then do what they suggested by creating a new MySQL database for each site, then import the backups into the new databases.
Also, before doing all this, give GoDaddy a call on their toll free number and ask to speak with a senior tech. They should be able to upgrade your MySQL without having you to do my suggestions.
|
|
|
1:42 PM
Jan 8, 2010
|
NickyD
| | USA | |
| Moderator
| posts 86 |
|
|
Thanks Sean. I like the idea of calling them up to go through it step by step 
|
|
|
5:35 AM
Jan 10, 2010
|
NickyD
| | USA | |
| Moderator
| posts 86 |
|
|
Sean, worked beautifully. First time I had to do it. Thanks.
|
|
|
11:21 AM
Jan 10, 2010
|
Sean
| | USA | |
| Admin
| posts 135 |
|
|
NickyD said:Sean, worked beautifully. First time I had to do it. Thanks.
Not a problem. Glad to have helped.
|
|
|
4:36 PM
Jan 10, 2010
|
NickyD
| | USA | |
| Moderator
| posts 86 |
|
|
Sean, since it all worked out, can I delete the old MySQL?
Right now, I am backing up the new database.
|
|
|
8:03 PM
Jan 10, 2010
|
Sean
| | USA | |
| Admin
| posts 135 |
|
|
NickyD said:Sean, since it all worked out, can I delete the old MySQL?
Right now, I am backing up the new database.
If you've made the changes to your wp-config.php files on all sites and put in the new database information, do one final test to make sure all is working, then yes, you can delete the old MySQL stuff.
|
|
|
2:46 AM
Jan 11, 2010
|
NickyD
| | USA | |
| Moderator
| posts 86 |
|
|
Yep, all works. It is actually just one site that needed to be updated. But all works fine.
|
|
This Forum is Currently Locked – Access is Read Only
Search 
Forum
Topic RSS 