[Koha-devel] Koha 3 Reset Database
Hello, I'm a very-new Koha user, and have a fresh installation of Koha 3.00.00 on Ubuntu 8.04. I initially choose to have the sample data installed out of the box, but would now like to try the application out using semi-real data. A search turned up only info for older versions, so I'll pose this question: What is the best way to reset or wipe the database clean in Koha 3, while (optionally) retaining configuration settings? Thanks! - DR -- david a. riggs software engineer, createTank mailto:ri...@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Re: [Koha-devel] Koha 3 Reset Database
On Mon, Jan 26, 2009 at 09:53:54AM -0500, David Riggs wrote: Hello, hello, What is the best way to reset or wipe the database clean in Koha 3, while (optionally) retaining configuration settings? this is the zsh script i use for myself: tables=( bibio biblioitems items auth_header sessions zebraqueue ) print 'truncate '$^tables'; ' | mysql if you don't use zsh, just open your prefered mysql client and truncate all the tables listed between the 2 parentheses. -- Marc Chantreux BibLibre, expert en logiciels libres pour l'info-doc http://biblibre.com ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Re: [Koha-devel] Koha 3 Reset Database
On Mon, Jan 26, 2009 at 10:40 AM, Marc Chantreux marc.chantr...@biblibre.com wrote: On Mon, Jan 26, 2009 at 09:53:54AM -0500, David Riggs wrote: What is the best way to reset or wipe the database clean in Koha 3, while (optionally) retaining configuration settings? this is the zsh script i use for myself: tables=( bibio biblioitems items auth_header sessions zebraqueue ) print 'truncate '$^tables'; ' | mysql I've truncated the tables listed above, but I still have items showing up in search results. Do I need to run some command to purge the Zebra index also? Thanks for your help! - DR -- david a. riggs software engineer, createTank mailto:ri...@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Re: [Koha-devel] Koha 3 Reset Database
On Mon, Jan 26, 2009 at 03:04:00PM -0500, David Riggs wrote: I've truncated the tables listed above, but I still have items showing up in search results. Do I need to run some command to purge the Zebra index also? don't carre about that and just use rebuild_zebra.pl with the -r flag. regards -- Marc Chantreux BibLibre, expert en logiciels libres pour l'info-doc http://biblibre.com ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Re: [Koha-devel] Koha 3 Reset Database
On 2009/01/27, at 9:39 AM, David Riggs wrote: On Mon, Jan 26, 2009 at 3:20 PM, Marc Chantreux marc.chantr...@biblibre.com wrote: On Mon, Jan 26, 2009 at 03:04:00PM -0500, David Riggs wrote: I've truncated the tables listed above, but I still have items showing up in search results. Do I need to run some command to purge the Zebra index also? don't carre about that and just use rebuild_zebra.pl with the -r flag. I ran the following commands (Ubuntu 8.04) and still get items showing up in search results. Clicking on the item gives a 404 error. $ sudo su - koha $ export PERL5LIB=/usr/share/koha/lib/ $ export KOHA_CONF=/etc/koha/koha-conf.xml $ perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -r Thanks, - DR just use 'rebuild_zebra.pl -r' no -a or -b args ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
Re: [Koha-devel] Koha 3 Reset Database
On 2009/01/27, at 10:10 AM, David Riggs wrote: On Mon, Jan 26, 2009 at 4:01 PM, Mason James mason.loves.su...@gmail.com wrote: On 2009/01/27, at 9:39 AM, David Riggs wrote: I ran the following commands (Ubuntu 8.04) and still get items showing up in search results. Clicking on the item gives a 404 error. $ sudo su - koha $ export PERL5LIB=/usr/share/koha/lib/ $ export KOHA_CONF=/etc/koha/koha-conf.xml $ perl -I /usr/share/koha/lib /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -r just use 'rebuild_zebra.pl -r' no -a or -b args Apparently that's not allowed. $ k...@linimac:~$ perl /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl -r Must specify -b or -a to reindex bibs or authorities Please do '/usr/share/koha/bin/migration_tools/rebuild_zebra.pl --help' to see usage. Thanks, - DR ah, ok 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; ___ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel