AnatolyUss / nmig

NMIG is a database migration tool, written in Node.js and highly inspired by FromMySqlToPostgreSql.
GNU General Public License v3.0
451 stars 83 forks source link

dbname with reserved chars #111

Closed jhere1 closed 1 year ago

jhere1 commented 1 year ago

account for db names with reserved chars, such as "-"

AnatolyUss commented 1 year ago

Hello Jian, Just wondering, does MySQL (or MariaDB) allow to have DB name, consisting of several words (or reserved word[s])? Could you provide an example please?

On Tue, Aug 22, 2023 at 12:17 AM Jian He @.***> wrote:

account for db names with reserved chars, such as "-"

You can view, comment on, or merge this pull request online at:

https://github.com/AnatolyUss/nmig/pull/111 Commit Summary

File Changes

(1 file https://github.com/AnatolyUss/nmig/pull/111/files)

Patch Links:

— Reply to this email directly, view it on GitHub https://github.com/AnatolyUss/nmig/pull/111, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADHR7N7Z6366HCPLTCM3DGDXWPF7FANCNFSM6AAAAAA3Y6QRGE . You are receiving this because you are subscribed to this thread.Message ID: @.***>

AnatolyUss commented 1 year ago

Ah, ok, I see ))

On Sun, Aug 27, 2023 at 7:33 PM Anatoly Khaytovich @.***> wrote:

Hello Jian, Just wondering, does MySQL (or MariaDB) allow to have DB name, consisting of several words (or reserved word[s])? Could you provide an example please?

On Tue, Aug 22, 2023 at 12:17 AM Jian He @.***> wrote:

account for db names with reserved chars, such as "-"

You can view, comment on, or merge this pull request online at:

https://github.com/AnatolyUss/nmig/pull/111 Commit Summary

File Changes

(1 file https://github.com/AnatolyUss/nmig/pull/111/files)

Patch Links:

— Reply to this email directly, view it on GitHub https://github.com/AnatolyUss/nmig/pull/111, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADHR7N7Z6366HCPLTCM3DGDXWPF7FANCNFSM6AAAAAA3Y6QRGE . You are receiving this because you are subscribed to this thread.Message ID: @.***>

jhere1 commented 1 year ago

an example we had would be a db name such as "test-database" the "-" is a reserved char.

AnatolyUss commented 1 year ago

@jhere1 Sorry, I had to revert this change. It breaks on MySQL 8.0.33 ... Could you share which MySQL version did you use?