{"id":13117,"date":"2023-05-26T04:16:29","date_gmt":"2023-05-26T08:16:29","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=13117"},"modified":"2023-05-26T04:16:33","modified_gmt":"2023-05-26T08:16:33","slug":"how-to-move-your-old-koha-database-to-new-upgraded-koha-installation","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/","title":{"rendered":"How to Move Your old Koha Database to new Upgraded Koha Installation"},"content":{"rendered":"\n<p>This guide will walk you through the steps you need to take to move your old koha database to a newly installed Koha setup. The instructions shown here will be run on an Ubuntu server as a reference.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Backup Your Koha Database<\/h2>\n\n\n\n<p>Start by taking backup of your existing Koha database by running the following command in your Ubuntu server terminal. These commands will result in storing the backup in your current directory. We also assume your koha database is named koha_library. You should replace <strong>koha_library<\/strong> with whatever your database is named.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo su<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\"># mysqldump --single-transaction -u root -p koha_library &gt; koha_library.sql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2. Install Koha<\/h2>\n\n\n\n<p>Do this if you have not yet installed Koha by <a href=\"https:\/\/wiki.koha-community.org\/wiki\/Koha_on_ubuntu_-_packages\" target=\"_blank\" rel=\"noreferrer noopener\">following these instructions on the Koha wiki<\/a>.<\/p>\n\n\n\n<p>If you have already installed Koha then you should upgrade your system using the following commands one by one:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\"># apt-get update\n\n# apt-get upgrade\n\n# apt-get install koha-common <\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3. Restore old Koha Database into the new Koha Installation<\/h2>\n\n\n\n<p>Start by remove the existing database in the new Koha installation using these commands:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\"># sudo mysql -u root -p<\/code><\/pre>\n\n\n\n<p>[Enter the Linux \/ MySQL Root password depending on your setup]<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">mysql&gt; drop database koha_library;\nmysql&gt; create database koha_library;\nmysql&gt; quit;<\/code><\/pre>\n\n\n\n<p>Go to the directory where you saved your backup of the old Koha sql file. If it is from a portable media such as a pen drive or external hard drive then yo should copy it to your home directory.<\/p>\n\n\n\n<p>Once you are ready run the following command:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\"># mysql -u root -p koha_library &lt; koha_library.sql<\/code><\/pre>\n\n\n\n<p>Where koha_library is the name of the database and koha_library.sql is the backup from the old setup.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. Upgrade Koha Database Schema<\/h2>\n\n\n\n<p>The Koha database schema of old Koha installation should upgrade to match with the new version (ideally above version 19). Run the following commands in a terminal:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo service memcached restart\n\n$ sudo koha-upgrade-schema library<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">5. Rebuild the Zebra Index<\/h2>\n\n\n\n<p>Run the following command in your server terminal:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo koha-rebuild-zebra -v -f library<\/code><\/pre>\n\n\n\n<p>That&#8217;s it, you have now upgraded your old Koha database to a newer Koha installation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This guide will walk you through the steps you need to take to move your old koha database to a newly installed Koha setup. The instructions shown here will be&#8230;<\/p>\n","protected":false},"author":1,"featured_media":13118,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,23,9,25,28,16],"tags":[1265,354,424,433,449,591,598],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Move an old Koha Database to new Koha Installation<\/title>\n<meta name=\"description\" content=\"Here we will show you how to move your old koha database to a newly installed Koha setup with reference to Ubuntu server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Move an old Koha Database to new Koha Installation\" \/>\n<meta property=\"og:description\" content=\"Here we will show you how to move your old koha database to a newly installed Koha setup with reference to Ubuntu server\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-26T08:16:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-26T08:16:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"680\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"How to Move Your old Koha Database to new Upgraded Koha Installation\",\"datePublished\":\"2023-05-26T08:16:29+00:00\",\"dateModified\":\"2023-05-26T08:16:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\"},\"wordCount\":303,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg\",\"keywords\":[\"Koha\",\"Linux\",\"Open Source\",\"Optimization\",\"Performance\",\"Tools\",\"Ubuntu\"],\"articleSection\":[\"Articles\",\"Guides\",\"How To\",\"Libraries\",\"Software\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\",\"url\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\",\"name\":\"How to Move an old Koha Database to new Koha Installation\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg\",\"datePublished\":\"2023-05-26T08:16:29+00:00\",\"dateModified\":\"2023-05-26T08:16:33+00:00\",\"description\":\"Here we will show you how to move your old koha database to a newly installed Koha setup with reference to Ubuntu server\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg\",\"width\":1280,\"height\":680,\"caption\":\"Old Koha Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Move Your old Koha Database to new Upgraded Koha Installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/x.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Move an old Koha Database to new Koha Installation","description":"Here we will show you how to move your old koha database to a newly installed Koha setup with reference to Ubuntu server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/","og_locale":"en_US","og_type":"article","og_title":"How to Move an old Koha Database to new Koha Installation","og_description":"Here we will show you how to move your old koha database to a newly installed Koha setup with reference to Ubuntu server","og_url":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2023-05-26T08:16:29+00:00","article_modified_time":"2023-05-26T08:16:33+00:00","og_image":[{"width":1280,"height":680,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg","type":"image\/jpeg"}],"author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"How to Move Your old Koha Database to new Upgraded Koha Installation","datePublished":"2023-05-26T08:16:29+00:00","dateModified":"2023-05-26T08:16:33+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/"},"wordCount":303,"commentCount":0,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg","keywords":["Koha","Linux","Open Source","Optimization","Performance","Tools","Ubuntu"],"articleSection":["Articles","Guides","How To","Libraries","Software","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/","url":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/","name":"How to Move an old Koha Database to new Koha Installation","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg","datePublished":"2023-05-26T08:16:29+00:00","dateModified":"2023-05-26T08:16:33+00:00","description":"Here we will show you how to move your old koha database to a newly installed Koha setup with reference to Ubuntu server","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2023\/05\/old-koha-database.jpg","width":1280,"height":680,"caption":"Old Koha Database"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/how-to-move-your-old-koha-database-to-new-upgraded-koha-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"How to Move Your old Koha Database to new Upgraded Koha Installation"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/x.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/13117"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=13117"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/13117\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/13118"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=13117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=13117"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=13117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}