[Koha-devel] Koha 3 Reset Database

[Mason James]

On 2009/01/27, at 10:51 AM, David Riggs wrote:

> On Mon, Jan 26, 2009 at 4:16 PM, Mason James
> <mason.loves.sushi at gmail.com> wrote:
>>
>> try a 'zebraidx -c /yourpath/koha-conf.xml init' then
>>
>> FYI: have a peek at line 488-ish of the rebuild script
>>
>>  system("zebraidx -c $zebra_config -g $record_format -d  
>> $zebra_db_name
>> init") if $reset_index;
>>
>
> No change. I continue to get results when searching, despite having
> truncated the listed tables, running various combinations of
> `rebuild_zebra.pl` and `zebraidx -c`. Clicking those items results in
> a 404. I have verified that browser caching is not at fault.
>
> I'm supposed to give an evaluation of Koha's suitability for use this
> week, and having the database(s) in an inconsistent state is making
> that extremely difficult. While it would be nice to persist my
> configuration changes, I'd be happy just blowing away and re-creating
> the database. Can someone please point me to docs or offer help as to
> how to re-initialize the DB without doing a complete re-installation?
> I'm overwhelmed by the number of scripts and data files provided, and
> unable to find documentation aside from reading hundreds of lines of
> Perl.
>
> Thanks for your help!
> - DR
>
>


ok, to wipe your zebra auth and bib dbs - this works for me..


#  zebraidx -c /home/mason/koha/ashs/etc/zebradb/zebra-authorities- 
dom.cfg -g iso2709 -d authorities init

11:01:02-27/01 zebraidx(17800) [log] zebra_start 2.0.34 /home/mason/ 
koha/ashs/etc/zebradb/zebra-authorities-dom.cfg
11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-text.so
11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-dom.so
11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-alvis.so
11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-grs-marc.so
11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-grs-xml.so
11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-grs-regx.so
11:01:02-27/01 zebraidx(17800) [log] enabling shadow spec=/home/mason/ 
koha/ashs/var/lib/zebradb/authorities/shadow:1G
11:01:02-27/01 zebraidx(17800) [log] cache_fname = /home/mason/koha/ 
ashs/var/lib/zebradb/authorities/shadow/cache
11:01:02-27/01 zebraidx(17800) [log] zebra_stop: 0.02 0.02 0.00

#  zebraidx -c /home/mason/koha/ashs/etc/zebradb/zebra-biblios.cfg   - 
g iso2709 -d biblios  init

11:01:26-27/01 zebraidx(17801) [log] zebra_start 2.0.34 /home/mason/ 
koha/ashs/etc/zebradb/zebra-biblios.cfg
11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-text.so
11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-dom.so
11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-alvis.so
11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-grs-marc.so
11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-grs-xml.so
11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ 
idzebra-2.0/modules/mod-grs-regx.so
11:01:26-27/01 zebraidx(17801) [log] enabling shadow spec=/home/mason/ 
koha/ashs/var/lib/zebradb/biblios/shadow:4G
11:01:26-27/01 zebraidx(17801) [log] cache_fname = /home/mason/koha/ 
ashs/var/lib/zebradb/biblios/shadow/cache
11:01:26-27/01 zebraidx(17801) [log] zebra_stop: 0.06 0.02 0.00
root at fugu:/etc/apache2/sites-enabled#