Hi, Can someone please help me as I don't feel like reloading and re-doing 6000 items. Using Koha 2.2.8-W32-R0. Running on Windows XP Professional. 1. I can't edit any bilio's in Koha as they are all blank (not visible in Opac either), although the book info is there (if selecting "normal" you can see the detail). How can I fix this problem? 2. How can I access the database in MYSQL, would it automatically have saved to Mysql. If not how do I set it up to be able to do both a manual and auto back-up. I have originally used the Marc-maker it import my data. Annelize RUC Lending Library annelizec@mtnloaded.co.za -- This message has been scanned for viruses and dangerous content by Pinpoint, and is believed to be clean.
Annelize Cussons <annelize@mtnloaded.co.za> escribió:
Hi, Can someone please help me as I don't feel like reloading and re-doing 6000 items.
2. How can I access the database in MYSQL, would it automatically have saved to Mysql. If not how do I set it up to be able to do both a manual and auto back-up.
you have to run mysqldump from cmd: mysqldump -A >backup.sql and mysqldump will dump all databases to a new file called backup.sql Gustavo
I have originally used the Marc-maker it import my data.
Annelize RUC Lending Library annelizec@mtnloaded.co.za
-- This message has been scanned for viruses and dangerous content by Pinpoint, and is believed to be clean.
---------------------------------------------------------------------------------------------- Este mensaje fue enviado desde Webmail Red de Investigacion del Hospital 12 de Octubre (Madrid)
I have used automysqlbackup from Sourceforge with great success. http://sourceforge.net/projects/automysqlbackup/ John ________________________________ From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Annelize Cussons Sent: Friday, January 23, 2009 1:43 AM To: Koha@lists.katipo.co.nz Subject: [Koha] Backup in MYSQL Importance: High Hi, Can someone please help me as I don't feel like reloading andre-doing 6000 items. Using Koha 2.2.8-W32-R0. Running on Windows XP Professional. 1. I can't edit any bilio's in Koha as they are all blank (not visible in Opac either), although the book info is there (if selecting "normal" you can see the detail). How can I fix this problem? 2. How can I access the database in MYSQL, would it automatically have saved to Mysql. If not how do I set it up to be able to do both a manual and auto back-up. I have originally used the Marc-maker it import my data. Annelize RUC Lending Library annelizec@mtnloaded.co.za ______________________________________________________________________ This inbound email has been scanned by the MessageLabs Email Security System. ______________________________________________________________________ -- This message has been scanned for viruses and dangerous content by Pinpoint Securemail, and is believed to be clean. Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.
Annelize Cussons <annelize@...> writes: 2. How can I access the database in MYSQL, would it automatically have saved to Mysql. If not how do I set it up to be able to do both a manual and auto back-up.
I have originally used the Marc-maker it import my data.
Annelize
RUC Lending Libraryannelizec@mtnloaded.co.za
Good suggestions. Also if you want to set something up with Windows using a GUI, just download MySQL Admin. Link: http://dev.mysql.com/downloads/gui-tools/5.0.html The GUI tools are not perfect, but they can help out with some tasks. Good Luck. -Darrell Ulm
participants (4)
-
Annelize Cussons -
Chadwick, John, DCA -
Darrell Ulm -
gustavobiblio@h12o.es