Manual appendix G, "Resetting the Koha Database"[1] talks about resetting Koha database with TRUNCATE SQL command. As Robin Sheat[2] point me this is a deprecated way. Now, with MySQL >~5.5 the way is just: DELETE FROM biblio; And the constraints will propagate the delete to (ALMOST) all other tables. [1] http://manual.koha-community.org/3.16/en/resetkohadb.html [2] http://lists.katipo.co.nz/public/koha/2014-June/039701.html I'll fill another bug about updating also bulkmarcimport.pl -d option.
Related bug: #12488, "bulkmarcimport.pl -d option should use DELETE instead of TRUNCATE"
Is this correct? http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=472b76d062da4d74a5279900cd817c7615d0b15f
reads ok to me :)
To me too :) JFTR, been strict «DELETE FROM biblio;» not always do the task straightforward, in some scenarios you should remove first some dependencies (sadly, I don't now exactly whats.. if item is borrowed?). PS: Same with bug #12488.