Will stats reset if site moved to new host & server? (2 posts)

  1. webtrix
    Posted 2 years ago #

    Hello! I run a popular Podcast site that is being moved to a new host. I am praying that the stats do not reset! My client would have a heart attack. Does anyone know if there is a chance of that AND if there is a way to ensure they do NOT get reset?

    Thank you!


  2. ntm
    Plugin Author

    Posted 2 years ago #

    Hi Dan,

    it is possible. But it is very important that the post IDs remain the same during the moving process!
    You may use the WP export function which creates a .xml file and in the new blog the default WordPress Importer plugin. But you need remove Hello World post and comments and also the category Uncategorized. In other word you need to clear the wp_posts, wp_postmeta, wp_comments, wp_commentmeta, wp_terms, wp_term_taxonomy and wp_term_relationships table before you start the WordPress Importer to import the .xml. Otherwise the WordPress Importer would change the ID numbers of the imported posts, comments and categories. It adds the imported stuff and does not replace existing elements and because two things can't have the same ID, it changes the ID of the imported elements (But that would destroy the relation between the posts and the statistic results).

    After importing the posts, comments etc., it is necessary to move the wp_podpress_stats and wp_podpress_statscounts table. The WP export and import tools ignore these two additional tables. I used the phpMyAdmin db interface to export and import these two table (and also to clear the other existing tables as described above).
    Afterwards you can adjust the podPress settings for the new blog and the statistic results should be the same as in the old blog.

    Maybe you try this procedure in a test environment. I used a XAMPP to create and run a test blog.


Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic