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: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: 22 September 2013 05:30 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 95, Issue 31 Send Koha mailing list submissions to koha@lists.katipo.co.nz 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 koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz 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 <chandru1782@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] Koha Backup Message-ID: <1379760134672-5771359.post@n5.nabble.com> 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 <paul.a@aandc.org> To: chandru1782 <chandru1782@gmail.com>, koha@lists.katipo.co.nz 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 <gbengaadara@yahoo.com> To: chandru1782 <chandru1782@gmail.com>, "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Koha Backup Message-ID: <1379806537.47931.YahooMailNeo@web162002.mail.bf1.yahoo.com> 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 Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 95, Issue 31 ************************************