← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 12:33 | slef | kados: vaguely... it's lunchtime here |
| 14:25 | 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 | 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 | if you didnt want to tar up the bin files | |
| 10:53 | 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 | 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 | 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 | AutoMySQLBackup VER 2.5 | |
| 10:58 | http://sourceforge.net/projects/automysqlbackup/ | |
| 10:58 | 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 | mostly it's the breeding farm that is huge - rest of DB is small | |
| 11:00 | 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 | 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 | might be the safest plan | |
| 11:05 | 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 | 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 | much much much better searching | |
| 11:07 | 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 | there should be a beta release of 3.0 soon | |
| 11:09 | jamesa | you read my mind |
| 11:10 | with only 2.5K items I think search speed is not a big issue for us. | |
| 11:10 | chris | yeah |
| 11:10 | its a better search as well as faster, but with 2.5k items you wont notice the speed | |
| 11:10 | id wait for 3.0 | |
| 11:11 | 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 | 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 | thanks for the help again- wanted to pass on the good news! |
← Previous day | Today | Next day → | Search | Index