Skip to content
This repository was archived by the owner on Oct 8, 2025. It is now read-only.
This repository was archived by the owner on Oct 8, 2025. It is now read-only.

Ensure database usernames and database names are in back ticks #191

Closed

Description

@gregharvey

We had a build fail because the database / username had a hyphen. The task was:

TASK [database_backup/database_backup-mysql : Create/update mysql user for TCP connections.] ***

The error seemed to be caused by the lack of back-ticks around the longer db name with a hyphen in the queries, for example, this failed...

TRIGGER ON somedatabase_contact-us.*

...but this succeeded:

TRIGGER ON `somedatabase_contact-us`.*

We should check for / clean up queries like this.

Activity

  1. gregharvey commented on Apr 12, 2023

    @gregharvey
    MemberAuthor

    Probably related to this:

    We could also look at handling databases properly via the MySQL plugin instead.

  2. gregharvey commented on Apr 21, 2023

    @gregharvey
    MemberAuthor

    This got done in #258 !

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workinggood first issueGood for newcomers

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions