I was hoping someone might be able to help with the following situation:
Recently, my hosting service provider managed to somehow mess up my site. The result was a non-working WordPress install. I was however able to get into the service provider's admin interface to create a full backup of the mysql database.
After thinking it through a bit, I decided to do a "clean" install of WordPress from scratch. Over the years, there was a lot of stuff that had accumulated that I thought would probably be better not to have. In addition, I did some clean up, changed the domain name, changed the default database name (as recommended in the install guide) and basically did a bunch of clean up I should have done years ago.
Unfortunately, what I have not been able to figure out is how to get all of my old content back in to my new install. While I have found the howto on restoring a MySQL backup using phpMyAdmin, that isn't quite what I want to do, since I don't want the old URL references, etc. Just purely the content - posts, pages, comments, custom fields and tags. Basically, what using the "import" function in WP Admin would probably accomplish (which I don't think I can use given that I only have a .sql backup).
When I read the stuff on restoring a database, it doesn't seem like it would work, as the table names are all different, etc. There are also tables from the old install relating to plugins I haven't used for ages, etc.
So, I guess to be more precise, I'm trying to find out if there's a way to use phpMyAdmin or something else to import content only into a fresh WP install. I suspect it might involve selectively restoring certain tables only from the backup, and possibly renaming tables (don't even know if that's possible - my mySQL-fu is weak) and perhaps other stuff?
If anyone has any guidance on how to do this, or could point me in the right direction to learn how to myself, I'd certainly appreciate it.