Deleting the installation sample library file
My first post to this forum; I have tried to search for an answer with no success, so my apologies if this question is simplistic. Koha 3.2 installed on Ubuntu 10.10 server, with all required modules. Programmatically, it works fine with the recommended test/sample file (Centreville library), user and admin interfaces fully functional, as is Marc imports. Q: How do we completely delete all the "Centreville" library records, so that we can set up our own library from scratch? Thanks - Paul -- View this message in context: http://koha.1045719.n5.nabble.com/Deleting-the-installation-sample-library-f... Sent from the Koha - Discuss mailing list archive at Nabble.com.
On 2 November 2010 06:11, Paul A <paul.a@aandc.org> wrote:
My first post to this forum; I have tried to search for an answer with no success, so my apologies if this question is simplistic.
Koha 3.2 installed on Ubuntu 10.10 server, with all required modules. Programmatically, it works fine with the recommended test/sample file (Centreville library), user and admin interfaces fully functional, as is Marc imports.
Q: How do we completely delete all the "Centreville" library records, so that we can set up our own library from scratch?
Hi Paul Easiest way to do it, is to drop and recreate the database, this will cause the web based installer to run again, and you can step through, without installing the sample data this time Chris
"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? 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-f... Sent from the Koha - Discuss mailing list archive at Nabble.com.
* Paul A (paul.a@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-f... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@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
* Paul A (paul.a@aandc.org) wrote:
"Easiest way to do it, is to drop and recreate the database"...
[snip]
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. As we were not yet in a production environment, we added the -d to the mysqldump command, and it worked like a treat. Now on to MarcEdit to start importing production data... Best - Paul --- Archives and Collections (ACS) Society 205, Main Street, Picton, Ontario, K0K 2T0, Canada Canadian Charitable Organization 88721 9921 RR0001 -- View this message in context: http://koha.1045719.n5.nabble.com/Deleting-the-installation-sample-library-f... Sent from the Koha - Discuss mailing list archive at Nabble.com.
"Easiest way to do it, is to drop and recreate the database"... [snip] 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. As we were not yet in a production environment, we added the -d to the mysqldump command, and it worked like a treat. Now on to MarcEdit to start importing production data... Best - Paul --- Archives and Collections (ACS) Society 205, Main Street, Picton, Ontario, K0K 2T0, Canada Canadian Charitable Organization 88721 9921 RR0001
Chris Cormack <chris@...> writes:
On 2 November 2010 06:11, Paul A <paul.a@...> wrote:
Q: How do we completely delete all the "Centreville" library records, so that we can set up our own library from scratch?
Hi Paul
Easiest way to do it, is to drop and recreate the database, this will cause the web based installer to run again, and you can step through, without installing the sample data this time
Chris
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? Many thanks and regards Paul "Tired old sys-admin"
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? I attach such a DANGEROUS drop-all script.
DON'T DO THIS ON A PRODUCTION SYSTEM. You will lose your WHOLE koha structure and will have to re-install. Call with mysql -h mysql -u koha -p koha < koha_drop.sql or whatever your MySQL server and koha user and koha database are called. YOU HAVE BEEN WARNED. The advantage to dropping the koha database is that you don't lose permissions and passwords.
participants (5)
-
Chris Cormack -
Chris Cormack -
Edgar Fuß -
Paul A -
Paul A.