| Time |
S |
Nick |
Message |
| 12:33 |
|
slef |
kados: vaguely... it's lunchtime here |
| 14:25 |
|
slef |
paul: are you here? |
| 19:18 |
|
johnb |
quit |
| 19:18 |
|
slef |
no |
| 10:47 |
|
jamesa |
hello all, anyone got time to talk about rebuildnonmarc.pl I am about to give it a run! |
| 10:48 |
|
chris |
hi jamesa ... im not sure that script has had much love in the recent past |
| 10:49 |
|
chris |
make sure you back up your db before you run it |
| 10:52 |
|
jamesa |
OK thanks, I was planning to stop mysql, tar up a copy of the DB files, start mysqld, run rebuildnonmarc.pl. this is all because about 100 of our 2500 items dont seem to have anything in classification |
| 10:52 |
|
chris |
you could do a mysqldump |
| 10:53 |
|
chris |
if you didnt want to tar up the bin files |
| 10:53 |
|
chris |
mysqldump -uuser -ppassword --add-drop-table Koha > Koha-backup.sql |
| 10:54 |
|
jamesa |
I thought doing a file replace would be easier if things went sour ?, rather than dropping DB and feeding mysqldump back in |
| 10:54 |
|
chris |
with the add-drop-table you dont need to drop the db |
| 10:54 |
|
chris |
but id do both |
| 10:54 |
|
jamesa |
I am happy to learn from other experience though |
| 10:55 |
|
chris |
because ive been caught out with the file replace before |
| 10:55 |
|
chris |
you'll probably be fine with file replace but doesnt hurt to have the sql backup just in case |
| 10:56 |
|
jamesa |
ok, we run a nightly backup using a script - keeps daily,weekly monthly - zipped up I think this is a sqldump but I shall check |
| 10:56 |
|
chris |
cool |
| 10:58 |
|
jamesa |
this is the script we use for daily backups, then we grab the files evey few days to USB stick |
| 10:58 |
|
jamesa |
AutoMySQLBackup VER 2.5 |
| 10:58 |
|
jamesa |
http://sourceforge.net/projects/automysqlbackup/ |
| 10:58 |
|
jamesa |
it emails me the results each night |
| 10:59 |
|
chris |
sweet, looks good |
| 10:59 |
|
jamesa |
it used to email me the DB but now it's too big |
| 10:59 |
|
jamesa |
mostly it's the breeding farm that is huge - rest of DB is small |
| 11:00 |
|
jamesa |
can I drop the breeding farm ? |
| 11:00 |
|
chris |
you could if you wanted, (thats where all the records used for copy cataloguing are) |
| 11:01 |
|
jamesa |
so that would mean any new books we would have to z3950 search for them again and add the boblio from the new search ? |
| 11:02 |
|
chris |
yep, the breeding farm is where all the results of your z3950 searches are stored, (plus any marc records you uploaded) |
| 11:03 |
|
jamesa |
we buil or DB all from searches - went from cards. |
| 11:04 |
|
chris |
ahh right |
| 11:04 |
|
jamesa |
what about marc_word - is that a koha table or a breeding farm like table ? |
| 11:04 |
|
chris |
thats a koha table |
| 11:04 |
|
chris |
thats what koha uses to search |
| 11:04 |
|
jamesa |
ok keep him then |
| 11:04 |
|
chris |
you definitely want that :) |
| 11:05 |
|
jamesa |
perhaps I sould just leave a working system working!!!!! |
| 11:05 |
|
chris |
:) |
| 11:05 |
|
chris |
might be the safest plan |
| 11:05 |
|
chris |
what id do, is take a copy of the db one time get another copy of koha running and load the db in |
| 11:06 |
|
chris |
and then you can try things safely :) |
| 11:06 |
|
jamesa |
could you explain the benefits of this new zebra db ? is it just for searches or do you migrate the whole db to it ? good idea about the test system |
| 11:07 |
|
chris |
its for the bibliographic data |
| 11:07 |
|
chris |
much much much better searching |
| 11:07 |
|
chris |
but all the patron and accounts and other data stays in the database |
| 11:08 |
|
jamesa |
looks the same to members - same templates css etc ? just the back end changes ? |
| 11:08 |
|
chris |
pretty much |
| 11:08 |
|
jamesa |
an it works with 2.2.7 ? |
| 11:09 |
|
chris |
altho on the systems we have using it, we have new templates too ... with koha 3.0 you can run zebra or without zebra |
| 11:09 |
|
chris |
there should be a beta release of 3.0 soon |
| 11:09 |
|
jamesa |
you read my mind |
| 11:10 |
|
jamesa |
with only 2.5K items I think search speed is not a big issue for us. |
| 11:10 |
|
chris |
yeah |
| 11:10 |
|
chris |
its a better search as well as faster, but with 2.5k items you wont notice the speed |
| 11:10 |
|
chris |
id wait for 3.0 |
| 11:11 |
|
chris |
where you get lots of other improvements too |
| 11:12 |
|
jamesa |
yeah agreed, ok thanks for the chat - great to be able to bounce some questions off another, I hope I can help someone else one day |
| 11:12 |
|
jamesa |
cheers for now |
| 11:12 |
|
chris |
no worries, catchya another time |
| 11:31 |
|
jamesa |
well the news is it seemed to work! went from 125 items where classification is NULL to only 20 so now I shall have to check the mard detail for those 20 and see if there is anythin in 082A |
| 11:31 |
|
jamesa |
thanks for the help again- wanted to pass on the good news! |
