Hey Miriam. Here’s my response to your email, which I’ll repost here for future users with a similar question:
—–
The data is stored in the WP_Options table under the option name 301_redirects. If you’re going to do a find an replace on the data, be aware that it is stored using WordPress’ own data serialization format, which includes a number paired with each string that has to match the number of characters in that string. That makes updating via a MySQL replacement query challenging. It’s best to update through the interface.
If you’ve already run a query to replace the domain name and now the fields in the interface are empty, you can likely still find the data in your database. If it’s there, you can put the old domain back in place and the data should return, then you can update through the interface. Or, if you have a good grasp of how WordPress serializes data for options, you can update those character counts directly.
Thank you so much for your fast response Scott! I found the data in the table, as you said. I think we’ll have to manually re-enter the redirects. At least we know for next time!
Hi Scott!
Your reply helped me a lot. I have seen you plugin is not updated from past 2 years 🙁 . I’m now afraid that will your plugin be compatible for the future versions too.
Hi Ajay,
I’m still testing it with the latest versions (but it still hasn’t needed an update.) I have a feature update almost ready to go, but my day job has conspired against me–I’ve been too busy to add the the last couple features. It should be out very soon, though.