Dear Mr. Chandru, Take the complete backup of the SQL file from Y machine and replace the SQL file of Koha in X Machine. You are done !!
Regards R Sunil Kumar Manager (Library Division) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: 22 September 2013 05:30 To: [email protected] Subject: Koha Digest, Vol 95, Issue 31 Send Koha mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Koha Backup (chandru1782) 2. Re: Koha Backup (Paul) 3. Re: Koha Backup (Olugbenga Adara) ---------------------------------------------------------------------- Message: 1 Date: Sat, 21 Sep 2013 03:42:14 -0700 (PDT) From: chandru1782 <[email protected]> To: [email protected] Subject: [Koha] Koha Backup Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii Dear all, I have made a fresh install of Koha 3.12.4 on a Debian machine X, with all the optional set of patrons, libraries, itemtypes etc.,. I have another instance of Koha running in a seperate Debian machine Y. Now I want to restore the data from Y to X without any change to the data in my fresh install X. I request some of the experts here to help me out with the above problem. Thanking you, A. Chandrashekaran School of Mathematics and Computer Sciences Central University of Tamil Nadu Tiruvarur, INDIA -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Backup-tp5771359.html Sent from the Koha-general mailing list archive at Nabble.com. ------------------------------ Message: 2 Date: Sat, 21 Sep 2013 19:24:03 -0400 From: Paul <[email protected]> To: chandru1782 <[email protected]>, [email protected] Subject: Re: [Koha] Koha Backup Message-ID: <5.2.1.1.2.20130921191430.055aebd0@localhost> Content-Type: text/plain; charset="us-ascii"; format=flowed At 03:42 AM 9/21/2013 -0700, chandru1782 wrote: >Dear all, > >I have made a fresh install of Koha 3.12.4 on a Debian machine X, with >all the optional set of patrons, libraries, itemtypes etc.,. I have >another instance of Koha running in a seperate Debian machine Y. Now I >want to restore the data from Y to X without any change to the data in >my fresh install X. > >I request some of the experts here to help me out with the above problem. DUMP you@Y:/$ cd /var/lib/mysql mysqldump --user=[koha] --password=[pw] koha_db_name > /wherever_you_want_it/koha_db_name_dump.sql RESTORE you@X:/$ cd /var/lib/mysql mysqldump --user=[koha] --password=[pw] koha_db_name < /wherever_you_have_it/koha_db_name_dump.sql Best - Paul ------------------------------ Message: 3 Date: Sat, 21 Sep 2013 16:35:37 -0700 (PDT) From: Olugbenga Adara <[email protected]> To: chandru1782 <[email protected]>, "[email protected]" <[email protected]> Subject: Re: [Koha] Koha Backup Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii Hi, > >I have made a fresh install of Koha 3.12.4 on a Debian machine X, with >all the optional set of patrons, libraries, itemtypes etc.,. I have >another instance of Koha running in a seperate Debian machine Y. Now I >want to restore the data from Y to X without any change to the data in >my fresh install X. > I am assuming you want to keep your configuration and data already in X and only import data from Y into X. If that is the case, then you can go to the Tools, and click on "Export data". You would then be able to export out your bibliography and authority records. The next data you may want to get out will be patrons record. For that you will need to generate a report that you can download. You will then need to import the biblios and authority from the stage MARC for import link in Tools and also import your patrons from a link in the same Tools page. Cheers. Olugbenga Adara ------------------------------ _______________________________________________ Koha mailing list [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 95, Issue 31 ************************************ _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha

