Best way to reset site?

Question

I had my students test out the site but now I want to reset their points and badges and also delete all of the questions. How do I go about doing this?

Thanks

Answer 1

I think you can just delete all of the tables, then run the install script. You might want to keep the options table.

Answer 2

TRUNCATE all tables excluding the options table. This will reset everything minus your admin options and doesn't require you to rerun the install script.

Note: I'm using single signon (i.e. external users)!

Comments

So in phpmyadmin for example, you would check all tables in the list (minus options), then from the combobox select the "Empty" option. It will then ask you to confirm the truncation of all tables.