[Koha] Koha mysql DBMS fix

[Hector Gonzalez Jaime]

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 at gmail.com | P: 657 4734353 <%28657%29%20473-4353> |
> F: 675 4374363
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Hector Gonzalez
cacho at genac.org