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.da...@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
ca...@genac.org
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
