reset my database
Hi, I am trying to reset all my database to default. need to delete all the patrons and items and books and whatever the data i have entered in. Please help me with this. what should i do? thanks regards umer habib
Op 11-07-12 10:28, umer.habib@techlogix.com schreef:
Hi,
I am trying to reset all my database to default. need to delete all the patrons and items and books and whatever the data i have entered in. Please help me with this. what should i do? thanks
I have a script: http://paste.koha-community.org/24 that will delete _everything_ from a Koha database. I'm not going to give instructions on how to use it, as it's pretty dangerous, so the time spent working out how to run it will make sure that it's not used frivolously or accidentally, I'll just say that it requires a KOHA_CONF and Koha PERL5LIB defined appropriately. (I use it to clean up development databases when I'm moving between versions and such.) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
Just for my own information, why would someone not want to simply drop the database? Is there no script to recreate an empty, default database? I suppose it would be too much work to recreate one with a database tool like phpmyadmin? -- Greg Lawson Network Administrator Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 816-232-5479 x2303 ------------------------ On 07/11/2012 05:49 AM, Robin Sheat wrote:
Op 11-07-12 10:28, umer.habib@techlogix.com schreef:
Hi,
I am trying to reset all my database to default. need to delete all the patrons and items and books and whatever the data i have entered in. Please help me with this. what should i do? thanks I have a script:
http://paste.koha-community.org/24
that will delete _everything_ from a Koha database. I'm not going to give instructions on how to use it, as it's pretty dangerous, so the time spent working out how to run it will make sure that it's not used frivolously or accidentally, I'll just say that it requires a KOHA_CONF and Koha PERL5LIB defined appropriately.
(I use it to clean up development databases when I'm moving between versions and such.)
Op 11-07-12 16:02, glaws schreef:
Just for my own information, why would someone not want to simply drop the database? Is there no script to recreate an empty, default database? I suppose it would be too much work to recreate one with a database tool like phpmyadmin?
Mostly because this can be done with the permissions of the regular koha db user, and I don't have to remember to re-set-up the grants and such. So I don't have to remember the root password for the database (and, in many situations, I don't have it as it's maintained by our sysadmins.) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
participants (3)
-
glaws -
Robin Sheat -
umer.habib＠techlogix.com