Dear Amir<br><br>Please post your question on the entire list of Koha so that others can suggest you some solution.<br><br>It is better to get the backup of your previous database with mysqldump command. Then upgrade Koha and Import this database into new Koha. You need not to import anything else separately.<br>
<br>Regards,<br><br><div id="WISESTAMP_SIG_4431"><div style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif"><div style="margin:0 0 8px 0"><p style="margin:0"><span style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif"> </span></p>
<div style="margin:0pt 0pt 8px">
<p style="margin:0;margin:0pt"><span style="font-size:medium;color:#333333">Ata ur Rehman</span></p>
<hr>
</div>
<p style="margin:0"> </p>
<table border="0" height="95" width="487">
<tbody>
<tr>
<td><span style="font-size:small;color:#888888">Manager (Library),</span><br><span style="color:#888888"><span style="font-size:small">National Centre for Physics(NCP), <br>Islamabad</span></span><br> <span style="font-size:small;color:#888888"><a href="http://www.ncp.edu.pk/" target="_blank">http://www.ncp.edu.pk/</a><br>
<a href="http://www.ncplib.co.cc/" target="_blank">http://www.ncplib.co.cc/</a></span></td>
<td><span style="font-size:small;color:#888888">Coordinator,</span><br><span style="color:#888888"><span style="font-size:small">LISolutions</span>®</span><br><span style="font-size:small;color:#888888"><a href="mailto:info@lisolutions.org" target="_blank">info@lisolutions.org</a><br>
<a href="http://www.lisolutions.org/" target="_blank">http://www.lisolutions.org</a></span></td>
</tr>
</tbody>
</table>
<p style="margin:0"><span style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif"> </span></p><div style="clear:both"></div></div><a href="http://www.facebook.com/ataurrehman/" style="text-decoration:underline"><img alt="Facebook" style="padding: 0px 0px 5px 0px; vertical-align: middle;" src="http://images.wisestamp.com/facebook.png" border="0" height="16" width="16"></a> <a href="http://twitter.com/#%21/ataurrehman" style="text-decoration:underline"><img alt="Twitter" style="padding: 0px 0px 5px 0px; vertical-align: middle;" src="http://images.wisestamp.com/twitter.png" border="0" height="16" width="16"></a> <a href="http://pk.linkedin.com/in/ataurrehman" style="text-decoration:underline"><img alt="LinkedIn" style="padding: 0px 0px 5px 0px; vertical-align: middle;" src="http://images.wisestamp.com/linkedin.png" border="0" height="16" width="16"></a> <a href="http://www.flickr.com/photos/lisolutions/" style="text-decoration:underline"><img alt="Flickr" style="padding: 0px 0px 5px 0px; vertical-align: middle;" src="http://images.wisestamp.com/flickr.png" border="0" height="16" width="16"></a><br>
<img src="http://p1.wisestamp.com/pixel.png?p=mozilla&v=3.9.12&t=1324874688853&u=c7c0db840c4ca423" height="1" width="1"></div></div><br><br><div class="gmail_quote">On Mon, Dec 26, 2011 at 9:34 AM, Aamir Abbas <span dir="ltr"><<a href="mailto:syed.aamirabbas@hotmail.com">syed.aamirabbas@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
AOA Sir Ata,<br><br>I have made 1500 books record and 200+ patrons (mostly books issued) in my last running koha 3.4.1. Than I export all the bibliographic record / items, and import all the data through terminal,<br><br>
cat start.sh<br>export KOHA_CONF=/opt/koha/etc/koha-conf.xml<br>export PERL5LIB=/opt/koha/lib<br>/opt/koha/bin/migration_tools/<a href="http://bulkmarcimport.pl" target="_blank">bulkmarcimport.pl</a> -d -commit 1000 -file "here I gave file path" /<b>media/koha.mrc</b> (file path address)<br>
<br><br>Its worked..... (import all the data). <br><br>Then I rebuild zebra through the command below...<br><br>export PERL5LIB=/opt/koha/lib<br>
/opt/koha/bin/migration_tools/<br>./<a href="http://rebuild_zebra.pl" target="_blank">rebuild_zebra.pl</a> -b- -r -a<br><br><br> all the bibliographic record shown in Koha 3.4.3 except patrons' record<br><br>Sir, may I be wrong or missed any other command, <br>
<br>Pl help me in this regard,<div class="im"><br><br><font color="#1f497d" face="Garamond"><b>Wtih Regards,</b></font><br>
<font color="#205867" face="Garamond"><b></b></font> <br>
<font color="#1f497d" face="Garamond"><b>SYED AAMIR ABBAS</b></font><br><font color="#31859b" face="Garamond">Assistant Librarian</font><br><font color="#31859b" face="Garamond">Air Universit Multan Campus</font><font color="#31859b" face="Garamond">,</font><br>
<font color="#31859b" face="Garamond">Multan Cantt- </font><br></div><div class="im"><font color="#31859b" face="Garamond"><font color="#1f497d">Ph:</font> <a href="tel:%2B92-61-4780091%20ext-246" value="+92614780091" target="_blank">+92-61-4780091 ext-246</a></font><br>
<font color="#31859b" face="Garamond"><font color="#1f497d">Cell: </font><a href="tel:%2B92-332-4173037" value="+923324173037" target="_blank">+92-332-4173037</a></font><br><font color="#1f497d" face="Garamond">Email: </font><a href="mailto:aamir.abbas@mail.au.edu.pk" target="_blank"><font color="#31859b" face="Garamond">aamir.abbas@mail.au.edu.pk</font></a><br>
<br><br><br></div><div><div class="hm HOEnZb"><div></div><hr>From: <a href="mailto:ata.rehman@gmail.com" target="_blank">ata.rehman@gmail.com</a><br>Date: Sat, 24 Dec 2011 23:28:23 +0500<br>Subject: Re: [Koha] how to export / import patron's data<br>
To: <a href="mailto:syed.aamirabbas@hotmail.com" target="_blank">syed.aamirabbas@hotmail.com</a><br>CC: <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a>; <a href="mailto:tls@lisolutions.org" target="_blank">tls@lisolutions.org</a></div>
<div><div class="h5"><br><br>Dear Aamir / All<br><br>No need to import all things separately if you use make upgrade command for upgration<br><br><br>Regards,<br><br><div><div style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif">
<div><p><span style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif"> </span></p>
<div>
<p><span style="font-size:medium;color:#333333">Ata ur Rehman</span></p>
<hr>
</div>
<p> </p>
<table border="0" height="95" width="487">
<tbody>
<tr>
<td><span style="font-size:small;color:#888888">Manager (Library),</span><br><span style="color:#888888"><span style="font-size:small">National Centre for Physics(NCP), <br>Islamabad</span></span><br> <span style="font-size:small;color:#888888"><a href="http://www.ncp.edu.pk/" target="_blank">http://www.ncp.edu.pk/</a><br>
<a href="http://www.ncplib.co.cc/" target="_blank">http://www.ncplib.co.cc/</a></span></td>
<td><span style="font-size:small;color:#888888">Coordinator,</span><br><span style="color:#888888"><span style="font-size:small">LISolutions</span>®</span><br><span style="font-size:small;color:#888888"><a href="mailto:info@lisolutions.org" target="_blank">info@lisolutions.org</a><br>
<a href="http://www.lisolutions.org/" target="_blank">http://www.lisolutions.org</a></span></td>
</tr>
</tbody>
</table>
<p><span style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif"> </span></p><div style="clear:both"></div></div><a href="http://www.facebook.com/ataurrehman/" style="text-decoration:underline" target="_blank"><img src="" alt="Facebook" style="padding:0px 0px 5px 0px;vertical-align:middle" border="0" height="16" width="16"></a> <a href="http://twitter.com/#%21/ataurrehman" style="text-decoration:underline" target="_blank"><img src="" alt="Twitter" style="padding:0px 0px 5px 0px;vertical-align:middle" border="0" height="16" width="16"></a> <a href="http://pk.linkedin.com/in/ataurrehman" style="text-decoration:underline" target="_blank"><img src="" alt="LinkedIn" style="padding:0px 0px 5px 0px;vertical-align:middle" border="0" height="16" width="16"></a> <a href="http://www.flickr.com/photos/lisolutions/" style="text-decoration:underline" target="_blank"><img src="" alt="Flickr" style="padding:0px 0px 5px 0px;vertical-align:middle" border="0" height="16" width="16"></a><br>
<img src="" height="1" width="1"></div></div><br><br><div>2011/12/24 Aamir Abbas <span dir="ltr"><<a href="mailto:syed.aamirabbas@hotmail.com" target="_blank">syed.aamirabbas@hotmail.com</a>></span><br>
<blockquote style="border-left:1px #ccc solid;padding-left:1ex">3.4.1 </blockquote></div><br></div></div></div> </div></div>
</blockquote></div><br>