Hi Jessa. The problem when you change domain names on a WordPress site, even with a search and replace, is that the length of the values changes, and WordPress stores the length along with the actual string. For example, if you changed your name from example.com to supersite.com, the length of the string changes from 11 characters to 13 characters. You can do a search and replace on the string to change that, but when you do, you are not changing that stored length. That's where the problem starts.
Because you have already migrated your site, and the meta recovery tool has not worked, there might not be any help we can provide in a forum other than to ask you to recreate the forms. If your forms required a substantial amount of work and it's worth paying someone to recover them, so you don't need to recreate them, you can find help with that here.
Here is some advanced troubleshooting advice, and what I use when I migrate sites from one domain or server to another. After you have properly changed the site URL and imported the database to the new server, I use this tool to change the domain name strings in the database and also change the serialized value lengths at the same time. This is an advanced tool which has the ability to destroy your database and your website. Please don't use it if you're not comfortable with it, and also please be sure you have at least one backup of your original database, and that you do not work with that. Save that somewhere safe, make a copy of it, then work with the copy.
This is the tool:
http://interconnectit.com/124/search-and-replace-for-wordpress-databases/
Please be sure you have a backup of your database before you attempt to use this. You have to weigh the possibility of destroying your database and the work required to recreate that, vs. doing to work to recreate your forms.
Please let us know if you have any questions if you would like to attempt this.
Posted 12 years ago on Wednesday January 18, 2012 |
Permalink