[Bug 12486] New: Appendix G (Resetting the Koha Database) using DELETE instead of TRUNCATE
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12486 Bug ID: 12486 Summary: Appendix G (Resetting the Koha Database) using DELETE instead of TRUNCATE Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Documentation Assignee: nengard@gmail.com Reporter: pablo.bianchi@gmail.com QA Contact: testopia@bugs.koha-community.org 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12486 --- Comment #1 from Pablo AB <pablo.bianchi@gmail.com> --- Related bug: #12488, "bulkmarcimport.pl -d option should use DELETE instead of TRUNCATE" -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12486 --- Comment #2 from Nicole C. Engard <nengard@gmail.com> --- Is this correct? http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=472b76d0... -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12486 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |katrin.fischer@bsz-bw.de Resolution|--- |FIXED --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- reads ok to me :) -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12486 --- Comment #4 from Pablo AB <pablo.bianchi@gmail.com> --- 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12486 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=12488 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org