Specifically, these: echo "some SQL" | sudo koha-mysql <instance> sudo koha-mysql <instance> < somefile.sql I tend to forget the exact syntax, at least for the first one, so having them in the manpage would be nice.
Created attachment 19988 [details] [review] Bug 9247 - Add two more usage examples to the manpage for koha-mysql It might not be immediately obvious that it is possible to send SQL queries "directly" to the koha-mysql command, or that files from mysqldump can be loaded with it. This patch adds these as "example usage" to the man page for koha-mysql. To test: Run these commands and look at the formatted man page: $ xsltproc /usr/share/xml/docbook/stylesheet/docbook-xsl/manpages/docbook.xsl \ debian/docs/koha-mysql.xml $ man -l koha-mysql.8 Make sure this test passes: $ prove -v xt/verify-debian-docbook.t This patch also corrects a couple places where "Koha" was written as "koha".
Created attachment 20188 [details] [review] Bug 9247 - Add two more usage examples to the manpage for koha-mysql It might not be immediately obvious that it is possible to send SQL queries "directly" to the koha-mysql command, or that files from mysqldump can be loaded with it. This patch adds these as "example usage" to the man page for koha-mysql. To test: Run these commands and look at the formatted man page: $ xsltproc /usr/share/xml/docbook/stylesheet/docbook-xsl/manpages/docbook.xsl \ debian/docs/koha-mysql.xml $ man -l koha-mysql.8 Make sure this test passes: $ prove -v xt/verify-debian-docbook.t This patch also corrects a couple places where "Koha" was written as "koha". Signed-off-by: Mirko Tietgen <mirko@abunchofthings.net>
Created attachment 20665 [details] [review] [PASSED QA] Bug 9247 - Add two more usage examples to the manpage for koha-mysql It might not be immediately obvious that it is possible to send SQL queries "directly" to the koha-mysql command, or that files from mysqldump can be loaded with it. This patch adds these as "example usage" to the man page for koha-mysql. To test: Run these commands and look at the formatted man page: $ xsltproc /usr/share/xml/docbook/stylesheet/docbook-xsl/manpages/docbook.xsl \ debian/docs/koha-mysql.xml $ man -l koha-mysql.8 Make sure this test passes: $ prove -v xt/verify-debian-docbook.t This patch also corrects a couple places where "Koha" was written as "koha". Signed-off-by: Mirko Tietgen <mirko@abunchofthings.net> Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> Test plan, all tests and QA script pass.
Pushed to master. Thanks, Magnus!
This patch has been pushed to 3.12.x, will be in 3.12.5. Thanks Magnus!
Pushed to 3.10.x, will be in 3.10.12