ollie2104

UPDATE:

It did not overwrite the tables, just moved them.

It was to do with the incorrect table prefix.

All is sorted now – besides the page customizations that were not imported.

Thanks for your help!

Hi Kuldeep,

Thanks for your advice!

I’ve had a look through phpMyAdmin and I’ve located the correct database. The wp-config points to it. I think I’ve found the issue, and it’s to do with your 3rd point about table prefixes.

When I installed WordPress for the second time, I remember I accidentally directed the database to the prefix “zyce” instead of “zyce_”.

For some reason, this process has overwritten the original tables which contained an underscore (e.g. zcye_posts with zcyeposts). I can confirm this because I see some tables without an underscore (e.g. zcyeposts) and others with one (e.g. zcye_actionscheduler_actions). The latter was likely generated through a plugin and wasn’t overwritten by the fresh install.

So the content inside “zcyeposts” just shows the example pages generated by WordPress, and the original “zcye_posts” no longer exists.

On the assumption that I did not back this database up, is there any way to recover it..? I only had about 3 pages, so it’s not a huge loss anyway. But if it’s possible to recover somehow, that would save a bit of time.

I was using the W3 Total Cache plugin on the new site, which fortunately saves a file of each page’s HTML code.

And luckily the databases from the original site were unaffected, so I can revert back to the original if necessary.

Let me know if you have any further advice for me.