As you may know my new web host Media Temple (mt) only supports MYSQL 3.23.58. I used to host this website on Dreamhost which uses MySQL 5.0.18 so (mt)’s version 3 was pretty much incompatable with my database that I had to move. The following is a log of all the changes it takes to move your posts and downgrade MYSQL.
- Move ALL files to your new host, but keep your wp-config.php to connect to the old database. If it is localhost then you are going to have to find the IP address or alternate hostname.
- Set your feed to output 100 posts (or however many posts you have)
- Go File > Save - and save the feed.xml file
- Now go back into the wp-config.php file and type in the new database information
- You will now have 1 HELLO WORLD post. You can delete it. In the Wordpress admin go to IMPORT > RSS. Upload the feed.xml file you downloaded.
PROBLEMS
If you use the above method you will lose your comments. There is probably a way to get the old comments from the database but I was alright with losing some of the comments.
August 27th, 2006 at 12:01 am
I just transferred our blog over to mediatemple’s Shared Server system a couple of days ago and didn’t have too many major problems except for the MySQL issue. Our old server used MySQL 4.1 while mediatemple currently only supports MySQL 3.2.I got it to work though.
I used phpMyAdmin to backup the data. Within phpMyAdmin you can choose which version of MySQL you need the backup to be compatible. Next, I just moved all the WordPress files over to mediatemple’s server, changed the wp-config file, imported the database backup into MySQL. It worked! The only hitch was that some special characters like quotes and accent characters got mangled. I had to do a global search and replace for each mangled character.