• Resolved deuxjardins

    (@deuxjardins)


    Hi Héctor
    I had to reinstall the WPP Plugin and for some reason, all my previous views from the past years disappeared. ( I did not flush the cache).
    Luckily, I have a backup of the entire website database in one file. But I do not know how to extract the WPP data from the file and import it into my MYSQL database on the server, as I have never done this. How do you recommend I go about this? Is there plugin I can use?
    Thanks and best regards, Greg

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    Hi @deuxjardins,

    I had to reinstall the WPP Plugin and for some reason, all my previous views from the past years disappeared. ( I did not flush the cache).

    Yes, that’s intended: the plugin assumes you won’t be using it anymore and cleans up after itself when uninstalled. Maybe I should add an option so people can uninstall it (eg. for debugging purposes) without removing the data?

    I do not know how to extract the WPP data from the file and import it into my MYSQL database on the server, as I have never done this. How do you recommend I go about this?

    WordPress Popular Posts stores its data in two database tables: wp_popularpostsdata and wp_popularpostssummary (the wp_ prefix might be different in your case.)

    You can create a temporary database and import your .sql dump there, then export just these two tables from the temporary database, and finally import this new .sql dump into your site’s database.

    You’ll need to disable WPP first though (assuming it’s active right now), delete the existing wp_popularpostsdata and wp_popularpostssummary tables (if any), and then import the ones from the new backup as explained above.

    Thread Starter deuxjardins

    (@deuxjardins)

    Hi Héctor, many thanks for your quick reply. I really appreciate it. i will try to do this

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Restore views from backup’ is closed to new replies.