WordPress.org

1. balticdesign
   Member
   Posted 5 months ago #

   I have a subfolder on my domain which has a password protected installation of wordpress I use for development. I have used it once to import wordpress data and I am needing to use it again to help transfer a blog.

   How would I completely remove all posts/comments/categories ect. while leaving the actual installation intact? I can't do this manually as there are over 800 post/comments.

   Thanks

   Dan

2. balticdesign
   Member
   Posted 5 months ago #

   So far I'm in phpMyAdmin and I'm just going through wp_comments ect.. and emptying the tables. This seems to work fine so far - I'm just hoping I dont miss something.

3. balticdesign
   Member
   Posted 4 months ago #

   Oh well I've got it sorted I believe:

   TRUNCATE TABLE wordpress_db.wp_comments;
   TRUNCATE TABLE wordpress_db.wp_links;
   TRUNCATE TABLE wordpress_db.wp_postmeta;
   TRUNCATE TABLE wordpress_db.wp_posts;
   TRUNCATE TABLE wordpress_db.wp_term_relationships;
   TRUNCATE TABLE wordpress_db.wp_term_taxonomy;
   TRUNCATE TABLE wordpress_db.wp_terms;

   Will clear out all the necessary files.

4. jupiterwise
   Member
   Posted 2 months ago #

   Worked great! Thanks for following through on this.

Reply

You must log in to post.