[Koha] backup restore problem

2012-07-22 Thread maq baq
hi, i work on koha 3.2, i've done backup koha database in deffirent ways (mysqldump, phpmyadmin, ) when i try to restore it, the books' data do not restore to catalogue but to resorvior, anyone have a solution to this problem, please. mohammad abid qassim programmer

Re: [Koha] SQL queries to delete records from the database?

2012-07-22 Thread Sonia P .
Hello It seems that we can't use 'delete' commands in the Koha admin website (build SQL reports or so). How can I do that? I need to delete these records, I know the proper command, I just want to be allowed to do it. (I am now down to 20 faulty records, so I will just delete them from the

Re: [Koha] SQL queries to delete records from the database?

2012-07-22 Thread Chris Cormack
* Sonia P. (sossola...@hotmail.com) wrote: Hello It seems that we can't use 'delete' commands in the Koha admin website (build SQL reports or so). How can I do that? I need to delete these records, I know the proper command, I just want to be allowed to do it. Yes, that is because

Re: [Koha] SQL queries to delete records from the database?

2012-07-22 Thread Sonia P .
So something like that? mysqldump -u kohauser -p kohalibrary savedatabase230712.sql mysql -u username -p[password]use kohalibrary;DELETE FROM biblio WHERE biblionumber='2315'; (never done mysql things in commandline before...) Cheers, Sonia. Date: Mon, 23 Jul 2012 15:42:59

Re: [Koha] SQL queries to delete records from the database?

2012-07-22 Thread Chris Cormack
On 23 July 2012 15:57, Sonia P. sossola...@hotmail.com wrote: So something like that? mysqldump -u kohauser -p kohalibrary savedatabase230712.sql mysql -u username -p[password]use kohalibrary;DELETE FROM biblio WHERE biblionumber='2315'; (never done mysql things in commandline

Re: [Koha] SQL queries to delete records from the database?

2012-07-22 Thread Sonia P .
OK, thanks. Yes, I am 100% sure I want to do this. We have been dealing with that recurrent index problem for months now. I am despaired. I could try anything. :) (and deleting a few lines in the biblio table won't probably crash anything...) I don't know how to restore from a back-up but

Re: [Koha] SQL queries to delete records from the database?

2012-07-22 Thread Mark Tompsett
Greetings, Did I hear someone say 'recurrent index problems'? I think this means I should repaste my indexing journey here. This was on an Ubuntu 10.04 LTS VM with only 512MB of memory. As such, your mileage may vary. And if there is something wrong in here, someone can comment and correct me.