Reinstalling WordPress and restoring only what’s needed

  • Hello guys.

    Currently I’m having a few problems with my WordPress site:

    – a few plugin config pages are not working, I receive the “You do not have sufficient permissions to access this page.” error message on them, and it has been happening for some time already and nothing I tried fixed it

    – Counterize database is getting HUGE, I think I’ll just clean it and restart from scratch on this new year

    – I wanna change my wp_ database prefix without worrying with errors I’ve read about when I was trying to fix first problem

    Well, considering all of this, I believe it would be better to do a clean install than trying to do each of those separately. My site has almost 2 years now.

    But of course, I don’t wanna lose my categories, my tags and aaaaaaall my post and comments in the process. I’m thinking on working to reconfig each and all plugin configs, but that’s the maximum I wanna do.

    So I’ll ask, is there a way to do it? Which tables should I backup and restore and which tables should I let go?

    From my 27 tables database, I separated them in this list:

    Tables that I will keep:
    wp_ak_popularity
    wp_ak_popularity_options
    wp_bad_behavior
    wp_comments
    wp_comment_notifier
    wp_postmeta
    wp_posts
    wp_sticky
    wp_terms
    wp_term_relationships
    wp_term_taxonomy

    Tables that I’ll delete and let WordPress create new ones:
    wp_ak_404_log
    wp_Counterize
    wp_Counterize_Keywords
    wp_Counterize_Pages
    wp_Counterize_Referers
    wp_Counterize_UserAgents
    wp_options

    Tables I don’t know what are used for and if I should clean:
    wp_blc_linkdata
    wp_blc_postdata
    wp_croer_meta
    wp_croer_posts
    wp_crossreferences
    wp_email
    wp_links

    And that leaves me with those 2 tables related to users, that I WISH to clean and solve the permission issue but may be required by other tables:
    wp_usermeta
    wp_users

    So, does anybody has any idea of how that can be done, and I can have a brand new blog and then restore only the really needed stuff?

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

  • Using Export from your old WordPress and Import on your new is certainly worth exploring. They are located under Tools in the left sidebar of the Admin panel on WordPress.

    It has been too many versions since I last used them, so I don’t know if everything you want is transferred. But I suspect so.

    Give it a try is my best suggestion.

    P.S. – looking at the tables you want to keep, I see some plug-in tables. Export is not going to transfer their contents, so you may have to try moving some tables across, too. Never done that — I transfer all or none of the tables, for fear of table inter-relationships.

    Thread Starter shidouhikari

    (@shidouhikari)

    Thanks for the suggestion.

    I ended up giving up on CounterizeII content and DELETE FROM everything, my database shrunk from 118MB to 10MB!

    About “You do not have sufficient permissions to access this page.” error message, I found out it was an outdated plugin that just needed a tweak to be back accessible. The other one may be too, I’ll take a look on that.

    Well I will wait some more time before giving up my installation ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Reinstalling WordPress and restoring only what’s needed’ is closed to new replies.