Hi Great Ones, Had a problem with my old koha server machine. i have currently installed koha 18.04 with mysql 5.7 database on ubuntu 18.11. on the old server machine, koha 17.11 with mariadb database was running on ubuntu 16.11. now i have a backup of the old server and i used this command *mysqldump -uroot -p koha_library<koha_library.sql* to import the backup to the new server. the mysqldump command runs without an error but no data is migrated to the new server. please any help on what do do? Thank you. Murphy Igbudu Systems Librarian Benue State University Library & Information Services, Benue State University Makurdi. Nigeria.
Hello, You may please refer here for proper operations http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi* On Wed, Nov 21, 2018 at 3:48 PM Igbudu Tersoo <murphyigbudu@gmail.com> wrote:
Hi Great Ones, Had a problem with my old koha server machine. i have currently installed koha 18.04 with mysql 5.7 database on ubuntu 18.11. on the old server machine, koha 17.11 with mariadb database was running on ubuntu 16.11. now i have a backup of the old server and i used this command *mysqldump -uroot -p koha_library<koha_library.sql* to import the backup to the new server. the mysqldump command runs without an error but no data is migrated to the new server. please any help on what do do? Thank you.
Murphy Igbudu Systems Librarian Benue State University Library & Information Services, Benue State University Makurdi. Nigeria. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Murphy, Have you tried with mysql instead mysqldump ? mysql -uroot -p koha_library < koha_library.sql Cheers ! Eric Bégin Solutions inLibro inc. Le 21 nov. 2018 à 05:18, à 05:18, Igbudu Tersoo <murphyigbudu@gmail.com> a écrit:
Hi Great Ones, Had a problem with my old koha server machine. i have currently installed koha 18.04 with mysql 5.7 database on ubuntu 18.11. on the old server machine, koha 17.11 with mariadb database was running on ubuntu 16.11. now i have a backup of the old server and i used this command *mysqldump -uroot -p koha_library<koha_library.sql* to import the backup to the new server. the mysqldump command runs without an error but no data is migrated to the new server. please any help on what do do? Thank you.
Murphy Igbudu Systems Librarian Benue State University Library & Information Services, Benue State University Makurdi. Nigeria. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Great ones, Thanks to each and every one of you for your immense contribution. DATABASE MIGRATION ISSUES RESOLVED. Murphy Igbudu Systems Librarian Benue State University Library & Information Services Makurdi, Benue State. Nigeria. On Wed, Nov 21, 2018 at 1:37 PM Eric Bégin <eric.begin@inlibro.com> wrote:
Murphy,
Have you tried with mysql instead mysqldump ?
mysql -uroot -p koha_library < koha_library.sql
Cheers !
Eric Bégin Solutions inLibro inc. Le 21 nov. 2018, à 05:18, Igbudu Tersoo <murphyigbudu@gmail.com> a écrit:
Hi Great Ones, Had a problem with my old koha server machine. i have currently installed koha 18.04 with mysql 5.7 database on ubuntu 18.11. on the old server machine, koha 17.11 with mariadb database was running on ubuntu 16.11. now i have a backup of the old server and i used this command *mysqldump -uroot -p koha_library<koha_library.sql* to import the backup to the new server. the mysqldump command runs without an error but no data is migrated to the new server. please any help on what do do? Thank you.
Murphy Igbudu Systems Librarian Benue State University Library & Information Services, Benue State University Makurdi. Nigeria. ------------------------------
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Eric Bégin -
Igbudu Tersoo -
vinod mishra