How to Import Data to New Site

  • Resolved grntrmd1800

    (@grntrmd1800)


    3 years, 10 months ago

    Hi, I’m building a new website for a client who has been using this plugin for quite some time and has a ton of popular post data in the database. I tried using phpMyAdmin to grab the database tables, import them to the new site and install the plugin on the new site but it doesn’t seem to work. The data is all there but in the plugin settings page, it shows as there is no data collected.

    I also used the native WP Export tool to export all posts from the old site to the new site so all post ID and data match on both sites.

    Am I missing a way to import the popular post data to a new site? Thanks!

    • This topic was modified 3 years, 10 months ago by grntrmd1800.
Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    3 years, 10 months ago

    Hi @grntrmd1800,

    WordPress’ export tool changes the IDs of your posts and pages when you import the data into a new database. This is likely the reason why your popular posts data doesn’t match with what you had on the old website.

    You either import the old database into the new website to keep your post / page IDs the same, or you update WPP’s database tables (_popularpostsdata and _popularpostssummary) so the IDs stored there match the new IDs generated by the export/import process.

    Thread Starter grntrmd1800

    (@grntrmd1800)

    3 years, 10 months ago

    Ah I see. I’ll try migrating via another method such as WP All Export/Import and see if that works better. Thanks for the quick response!

    • This reply was modified 3 years, 10 months ago by grntrmd1800. Reason: Marked resolved
    Thread Starter grntrmd1800

    (@grntrmd1800)

    3 years, 10 months ago

    I know I marked this as resolved but actually I can confirm all post IDs are the same on both sites. I actually went back through my notes and I used WP ALL Import/Export to maintain post IDs. Any other suggestions?

    Plugin Author Hector Cabrera

    (@hcabrera)

    3 years, 10 months ago

    Hi @grntrmd1800,

    If the IDs are the same then we have a different issue here 😛

    I recommend following the instructions from this FAQ to see if there’s a conflict somewhere: I need help with WordPress Popular Posts! What should I do?

    Plugin Author Hector Cabrera

    (@hcabrera)

    3 years, 9 months ago

    Since it’s been a couple of weeks since OP’s last reply I’m assuming they either figured it out or decided to try something different and so I’m marking this topic as resolved.

    OP if you still need assistance with this please let me know.

    Thread Starter grntrmd1800

    (@grntrmd1800)

    3 years, 9 months ago

    Issue still isn’t solved. I installed the health plugin you recommended and it’s not showing any conflicts. The plugin does not show the data even when it’s the only active plugin on the site in troubleshooting mode. Happy to give you an admin login to poke around if you’d like.

    I can confirm post tables (including IDs) are identical on both websites. I copied the ‘wp_popularpostsdata’ and ‘wp_popularpostssummary’ tables from old site to the new site so they are also identical.

    New site Popular Posts plugin looks like a fresh install and says there is no data yet.

    Plugin Author Hector Cabrera

    (@hcabrera)

    3 years, 9 months ago

    Happy to give you an admin login to poke around if you’d like.

    Unfortunately I have to turn that offer down. Forum guidelines forbid that for security reasons.

    I can confirm post tables (including IDs) are identical on both websites. I copied the ‘wp_popularpostsdata’ and ‘wp_popularpostssummary’ tables from old site to the new site so they are also identical.

    New site Popular Posts plugin looks like a fresh install and says there is no data yet.

    Try visiting one of your articles then check the browser console and see if there are any errors in there that may be related to the plugin.

    Alternatively, if your site is online somewhere and is publicly accessible please share its URL and I’ll have a look.

    Thread Starter grntrmd1800

    (@grntrmd1800)

    3 years, 9 months ago

    No errors related to the plugin are showing in the console. Here is the original site: https://www.theorderexpert.com/blog/ (there are a few new posts since I started trying to debug this) and here is the new site still on the dev server: https://orderexpert.gtmproject.com/blog/

    Plugin Author Hector Cabrera

    (@hcabrera)

    3 years, 9 months ago

    Well, I just visited one of the posts and WPP was able to track my pageview normally @grntrmd1800.

    Thread Starter grntrmd1800

    (@grntrmd1800)

    3 years, 9 months ago

    Yes, it’s tracking new views only – it does not register any of the imported data is what the problem is. The original site was around for a while and has thousands of views stored in the database but the plugin is only recognizing new views. My client does not want to lose the original view count.

    Plugin Author Hector Cabrera

    (@hcabrera)

    3 years, 9 months ago

    Honestly no idea then. I’d double check that the post IDs haven’t changed, that the database tables you imported into the new database are using the same prefix, etc.

    Thread Starter grntrmd1800

    (@grntrmd1800)

    3 years, 9 months ago

    Ok, thanks anyway for your help – I appreciate it!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘How to Import Data to New Site’ is closed to new replies.