Changing MySQL DB from 4.0 to 5.0?

MyOwnDemon

Face Rocker
Jan 28, 2007
3,529
27
48
Iowa
www.sitestomp.com
So I have a wordpress website that I took offline a few year back. It was hacked and I was extremely busy at the time so I didn't feel like messing with it. However, I did save the database.

Lately, I've been thinking about putting it back online, so I installed a new copy of wordpress and hooked it up to the old MySQL database.

However the old database is 4.0 and wordpress now needs 5.0.

Is there any quick way to change it? I did a few google searches and I don't understand a word of it. I contacted my host but they haven't gotten back to me yet.
 


I think all you have to do is make sure your my.cnf file for your 5.0 server has the following variable set:

old-passwords = 1

If not, set it and restart mysql server then do your import.
 
Tech support never got back to me, but I got it figured out. All I did was export the old database and import it into a 5.0 database. There were a few minor problems doing it like that, but it all worked out in the end.