[Koha] DATA MIGRATION

[Igbudu Tersoo]

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
***@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/lis

[vinod mishra]

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*

Post by Igbudu Tersoo
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
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/

[Eric Bégin]

Murphy,

Have you tried with mysql instead mysqldump ?

mysql -uroot -p koha_library < koha_library.sql

Cheers !

⁣Eric Bégin
Solutions inLibro inc.​

Post by Igbudu Tersoo
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
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https

[Igbudu Tersoo]

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.

Post by Eric Bégin
Murphy,
Have you tried with mysql instead mysqldump ?
mysql -uroot -p koha_library < koha_library.sql
Cheers !
Eric Bégin
Solutions inLibro inc.

Post by Igbudu Tersoo
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
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
h