Title: Cleaning the database tables?
Last modified: August 30, 2016

---

# Cleaning the database tables?

 *  Resolved [gella2002](https://wordpress.org/support/users/gella2002/)
 * (@gella2002)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/cleaning-the-database-tables/)
 * Hello,
    I’ve noticed that the tables wp_watupro_student_answers, wp_watupro_taken_exams
   and wp_watu_taking all together take 95% of my database. 501, 123 and 105 Mb 
   respectively. My hosting provider demands reducing the database size, as it’s
   close to allowed limits. I cleaned up almost all taken exams details (“Show me
   a button to cleanup all submitted data on this quiz.”) but this action didn’t
   change the size of these tables at all. Please advice, how could I reduce the
   size of these tables, thank you in advance!
 * [https://wordpress.org/plugins/watu/](https://wordpress.org/plugins/watu/)

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

 *  Plugin Author [Bob](https://wordpress.org/support/users/prasunsen/)
 * (@prasunsen)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/cleaning-the-database-tables/#post-6771978)
 * You are talking both about Watu and Watupro here. WatuPRO will reduce the DB 
   size when you use that cleanup option. Watu does not have such option but it 
   has the following:
 * Do not store user answers in the database to save DB space.
 * So it won’t store data in the future if you don’t need it. If you want to delete
   past data you can do it from phpMyAdmin or the free SQL Executioner plugin.
 *  Thread Starter [gella2002](https://wordpress.org/support/users/gella2002/)
 * (@gella2002)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/cleaning-the-database-tables/#post-6771979)
 * Thanks, but I have only WatuPro installed. There’s no Watu in my plugins section.
   Can I simply delete these tables?
 * Do you mean if I use this SQL Executioner, it should be okay with your plugin?
 *  Plugin Author [Bob](https://wordpress.org/support/users/prasunsen/)
 * (@prasunsen)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/cleaning-the-database-tables/#post-6771989)
 * You can delete the contents but don’t delete the tables because the plugins will
   stop working.
 * You can run such queries:
 * TRUNCATE TABLE wp_watupro_taken_exams;
    TRUNCATE TABLE wp_watupro_student_answers;
 * This will delete ALL submitted data on ALL quizzes you have.
 * In your first post you mentioned having table wp_watu_takings which is a table
   from the free Watu.
 * If you have further Pro questions please use the support email. This forum does
   not allow Pro plugin discussions.
 *  Thread Starter [gella2002](https://wordpress.org/support/users/gella2002/)
 * (@gella2002)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/cleaning-the-database-tables/#post-6772144)
 * Thanks, truncate query solved the problem.

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

The topic ‘Cleaning the database tables?’ is closed to new replies.

 * ![](https://ps.w.org/watu/assets/icon-128x128.png?rev=1680960)
 * [Watu Quiz](https://wordpress.org/plugins/watu/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/watu/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/watu/)
 * [Active Topics](https://wordpress.org/support/plugin/watu/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/watu/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/watu/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [gella2002](https://wordpress.org/support/users/gella2002/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/cleaning-the-database-tables/#post-6772144)
 * Status: resolved