Dear Koha Community, Here is a problem that someone here in this community might come across or know to share how to solve this problem; I talked with my ICT administrator to solve this issue to have access to the koha mysql but was unable to do so to fix the DBMS auto increment problem. The issue of the "unknown variable" in the script is; *mysql: [ERROR] unknown variable 'init-file=/var/lib/mysql/init-file_koha_library.sql'* I can do the mysqldump and run the backup on the test server but on the production server, I have no access at all. Looking into the past forum emails, wikis there is not much help. Thanking everyone here in advance for their invaluable insight and pointing me towards solving the problem. Kind regards *Decka David* Matheson Librarian | PNG University of Technology | PMB | Lae, 411 | Morobe Province | PAPUA NEW GUINEA Alternate E: decka.david@gmail.com | P: 657 4734353 <%28657%29%20473-4353> | F: 675 4374363
You need to add a line to one of mysql's configuration files, you may create one just for this, the complete file would look like: [mysqld] init-file = /var/lib/mysql/init-file_library.sql you may change "library" with your own libraries name. And you must create that file, with the sql from the wiki. from the error message, my guess is your sysadmin put this line outside the scope of a [mysqld] section. [mysql] is not good enough, as it refers to mysql's CLIENT program, not your database server. On 3/21/23 20:59, Decka David wrote:
Dear Koha Community,
Here is a problem that someone here in this community might come across or know to share how to solve this problem; I talked with my ICT administrator to solve this issue to have access to the koha mysql but was unable to do so to fix the DBMS auto increment problem. The issue of the "unknown variable" in the script is;
*mysql: [ERROR] unknown variable 'init-file=/var/lib/mysql/init-file_koha_library.sql'*
I can do the mysqldump and run the backup on the test server but on the production server, I have no access at all. Looking into the past forum emails, wikis there is not much help.
Thanking everyone here in advance for their invaluable insight and pointing me towards solving the problem.
Kind regards
*Decka David* Matheson Librarian | PNG University of Technology | PMB | Lae, 411 | Morobe Province | PAPUA NEW GUINEA Alternate E: decka.david@gmail.com | P: 657 4734353 <%28657%29%20473-4353> | F: 675 4374363 _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Hector Gonzalez cacho@genac.org
Thank you, the IT manager proceeded with the hint and I am now able to access mysql to clean the DBMS increment issues. Kind regards *Decka David* On Thu, Mar 23, 2023 at 10:39 AM Hector Gonzalez Jaime <cacho@genac.org> wrote:
You need to add a line to one of mysql's configuration files, you may create one just for this, the complete file would look like:
[mysqld] init-file = /var/lib/mysql/init-file_library.sql
you may change "library" with your own libraries name.
And you must create that file, with the sql from the wiki.
from the error message, my guess is your sysadmin put this line outside the scope of a [mysqld] section. [mysql] is not good enough, as it refers to mysql's CLIENT program, not your database server.
Dear Koha Community,
Here is a problem that someone here in this community might come across or know to share how to solve this problem; I talked with my ICT administrator to solve this issue to have access to the koha mysql but was unable to do so to fix the DBMS auto increment problem. The issue of the "unknown variable" in the script is;
*mysql: [ERROR] unknown variable 'init-file=/var/lib/mysql/init-file_koha_library.sql'*
I can do the mysqldump and run the backup on the test server but on the production server, I have no access at all. Looking into the past forum emails, wikis there is not much help.
Thanking everyone here in advance for their invaluable insight and
On 3/21/23 20:59, Decka David wrote: pointing
me towards solving the problem.
Kind regards
*Decka David* Matheson Librarian | PNG University of Technology | PMB | Lae, 411 | Morobe Province | PAPUA NEW GUINEA Alternate E: decka.david@gmail.com | P: 657 4734353 <%28657%29%20473-4353> | F: 675 4374363 _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Hector Gonzalez cacho@genac.org
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Decka David -
Hector Gonzalez Jaime