[Koha-bugs] [Bug 12486] New: Appendix G (Resetting the Koha Database) using DELETE instead of TRUNCATE

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: pablo.bianchi at gmail.com
        QA Contact: testopia at 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.