How to wipe the database of books (on a test site)
I'm playing around with importing books into a test site, and I want to wipe the database ("delete from TABLE"), to start over. I think I need to delete a few tables, then run a script to do a full re-index or something, then wait a few minutes. Anyone want to give me a list of tables to wipe (and maybe the name of the script to run)? Thanks p.s. I may have already wiped a few tables. -- Tim -- View this message in context: http://koha.1045719.n5.nabble.com/How-to-wipe-the-database-of-books-on-a-tes... Sent from the Koha-general mailing list archive at Nabble.com.
magmatic schreef op ma 18-11-2013 om 08:17 [-0800]:
I'm playing around with importing books into a test site, and I want to wipe the database ("delete from TABLE"), to start over.
It depends on exactly what you want to delete, but if it's just biblios: items biblioitems biblio (in that order should be the fastest.) If you just do a delete, don't forget to reset the auto_increment back to 1, or new things will be numbered from where the previous data left off. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (2)
-
magmatic -
Robin Sheat