Bug 28749: Restore the database name to Koha dumps
authorJason Boyer <JBoyer@equinoxOLI.org>
Wed, 28 Jul 2021 14:01:25 +0000 (14:01 +0000)
committerKyle M Hall <kyle@bywatersolutions.com>
Fri, 6 Aug 2021 11:46:44 +0000 (07:46 -0400)
commit692b78e496d7b2ee5ea1b2a0de3fbf3ce379b41c
treefdec04c67be89bfb7627213b77b2a020bf287ab2
parent5d922670184c66a48de07c0e9683824364b8e0be
Bug 28749: Restore the database name to Koha dumps

The line to use the --databases flag with mysqldump by default was accidentally
removed from koha-dump when the --schema-only option was added. This makes all
backups act as if koha-dump is called with the --without-db-name flag, causing
koha-restore to fail to restore the database because it's neither CREATEd or USEd.

This patch restores that line

To test:
1 - sudo debian/scripts/koha-dump kohadev
2 - zcat /var/spool/koha/kohadev/kohadev-2021-07-28.sql.gz | grep DATABASE
3 - Notice no output
4 - Apply patch
5 - sudo debian/scripts/koha-dump kohadev
6 - zcat /var/spool/koha/kohadev/kohadev-2021-07-28.sql.gz | grep DATABASE
7 - You get the line:
    CREATE DATABASE /*!32312 IF NOT EXISTS*/ `koha_kohadev` /*!40100 DEFAULT CHARACTER SET latin1 */;

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
debian/scripts/koha-dump