[Koha] reinstalling, but keep records

[Ryan Higgins]

If you wish to reinstall Koha but keep your cataloged records ( and you are
okay with losing
circulation data ),  your best bet is to export via Tools -> Export
bibliographic and holdings data,
then import into a fresh installation using the Stage MARC Record import
tools.
Note that you will have to have your branch codes defined as well as
authorized values
for item status fields.

If you only want to reset the system preferences, they are contained in a
sql file
in the installer directory of your installation
(after backing up your database ( with mysqldump --single-transaction *) ),
access the mysql client and issue the sql statement:
delete from systempreferences;
then from the commandline, reinstall the default systempreferences:
mysql -uKOHAUSER -pKOHAPASSWD kohadbname <
KOHAROOT/installer/data/mysql/en/mandatory/sysprefs.sql

 * Do note that when using mysqldump to back up Koha's innodb tables, you
should use the --single-transaction flag to ensure data consistency across
tables.

Hope that helps

Ryan



On Fri, May 30, 2008 at 5:24 AM, Ramon Andinach <custard at westnet.com.au>
wrote:

> Hi there,
>
> Is it possible to reset the prefrences?
>
> Or alternately, can koha be reinstalled in such a way that the records
> are not lost?
>
> -custard
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Ryan Higgins

LibLime * Open-Source Solutions for Libraries
Featuring KohaZOOM ILS
888-564-2457 x704
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080530/3b33223c/attachment-0001.htm