My hosting company is dropping support for MySQL 4 after tomorrow (04-30-2013) and moving to MySQL 5, so I had to move my WordPress blog to a new database on the server. I used phpMyAdmin to back up my old database. I also used the backup tool in WordPress to create another backup, both of which are in folders on my home computer. Meantime I manually copied all the WP files I could see on my server to another folder on my local machine. So I have three backups.
I then created a new database, and since I was using an old version of WP (2.8.4), I downloaded the latest (3.5.1). I edited wp-config.php to connect to the new database and followed the detailed instructions for installing/updating WordPress. I then imported my backed up database using phpMyAdmin.
But all I have now is the WP 3.5.1 dashboard and my old plugins. None of the original blog is there — posts, comments, graphics, etc. The fact that I have the dashboard and the sample page means (I think) that the WP installation is connecting correctly with the database, but I don’t know where to look for my posts or how to restore them. I’m only technical enough to get into trouble, so I would be grateful if someone could give me a hint on how to get my posts and comments back.
EDIT, 5 MINUTES LATER: Now I can’t get to the dashboard or the blog. “Error establishing a database connection.” It worked for two hours, though, and I didn’t change anything. Possibly the server is overworked with everyone migrating at the last minute, like me. But I’m still asking (begging) for help on my main issue above.
- The topic ‘Restoring My Blog After Database "Upgrade"’ is closed to new replies.