[Koha-bugs] [Bug 12488] bulkmarcimport.pl -d option should use DELETE instead of TRUNCATE
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Mar 25 11:07:39 CET 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488
--- Comment #5 from Magnus Enger <magnus at enger.priv.no> ---
This does the trick for me:
if ($delete) {
if ($biblios){
print "deleting biblios\n";
$dbh->do("DELETE FROM biblio");
$dbh->do("ALTER TABLE biblio AUTO_INCREMENT = 1");
$dbh->do("DELETE FROM biblioitems");
$dbh->do("ALTER TABLE biblioitems AUTO_INCREMENT = 1");
$dbh->do("DELETE FROM items");
$dbh->do("ALTER TABLE items AUTO_INCREMENT = 1");
}
else {
print "deleting authorities\n";
$dbh->do("truncate auth_header");
}
$dbh->do("truncate zebraqueue");
}
On an uptodate Debian 7, running MySQL 5.5.41-0+wheezy1-log.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list