wp-content | problem with site migration

  • Resolved ollie2104

    (@ollie2104)


    3 years, 6 months ago

    Hi there,

    I recently created a subdomain to redesign my website, so that I could eventually move the new website to the root domain. I followed a guide, but it did not work (although I made backups of both the old and new website).

    I decided to start from scratch, trying a different method. I uninstalled WordPress through Installatron and deleted all /public-html files using CPanel’s File Manager.

    I was advised that all I needed to move is the /wp-content folder from the new site to the root domain site, followed by conducting a search/replace on some URL database entries.

    So I did a fresh install of WordPress through Installatron, which created a new /public-html directory. I replaced the /wp-content folder that was created, with my backup. The settings I chose during my installation point to the correct directory and the correct database directory. The wp-config.php file is all updated too.

    However, when I go into the WordPress dashboard for my site, everything looks like it’s a fresh install. No pages, plugins, etc. I don’t know what I’ve missed. In CPanel’s File Manager, I can see all the correct files and folders under /wp-content. And yet, nothing shows up in my WP Dashboard!

    Please help if you can – would seriously appreciate it!

    • This topic was modified 3 years, 6 months ago by ollie2104.
Viewing 4 replies - 1 through 4 (of 4 total)

  • @ollie2104 As far as I can tell, there seems to be three possible scenarios:

    1. You didn’t import your SQL file. some users just upload the SQL file in their server, but they don’t import it in their database. Make sure you did that.

    2. You imported the SQL file in a separate database. Your MySQL server (or whatever you’re using) can have more than one database, but your WordPress site is connecting to one specific database in the SQL server. If you imported the tables and data in a different database, it’s normal you don’t see any data in your WordPress site — it’s just looking at the wrong place. Either change your WordPress setup (in wp-config.php) to let it know what database should it connect to or import the tables in the right place.

    3. You imported the SQL file in the proper database, but table prefixes are wrong. WordPress adds some prefixes to your database tables. So, for example, the table that contains all your posts is usually named wp_posts, but it can be anything such as wbo_posts or wp123_posts. Just make sure your setup is pointing to the appropriate tables.

    Do let me know if this helps.

    Thread Starter ollie2104

    (@ollie2104)

    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.

    Thread Starter ollie2104

    (@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!

    @ollie2104 Awesome- Your Welcome. And thank you for the update.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wp-content | problem with site migration’ is closed to new replies.

Tags