[Koha] Deleting the installation sample library file

[Chris Cormack]

* Paul A (paul.a at aandc.org) wrote:
> 
> "Easiest way to do it, is to drop and recreate the database"... 
> 
> Chris - thanks for replying. I am pretty certain that koha-admin will allow
> me to recreate, but how do I "drop" the existing database? Example: I have
> deleted all "branches" but cannot delete the "Centreville"; I have renamed
> it, but cannot modify the branch code. All our tests on Marc imports, users,
> staff, keep showing up; etc, etc.
> 
> I realize that a "delete my whole structure" might be a dangerous "in
> production" command for Koha - but that is what I need now - to start with a
> clean slate. Do I have to do a complete re-install without the test/sample
> file?

What I would do is

mysqldump -ukoha -p koha > koha_backup.sql

mysqladmin -uroot -p drop koha
mysqladmin -uroot -p create koha

You won't need to recreate the user etc. But when you try to start Koha
it will run the webinstaller again.

Chris

> 
> Many thanks and regards
> Paul
> "Tired old sys-admin"
> -- 
> View this message in context: http://koha.1045719.n5.nabble.com/Deleting-the-installation-sample-library-file-tp3245362p3245653.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20101103/3d3d278f/attachment.pgp