search

EMCECS / ecs-sync

ecs-sync is a bulk copy utility that can move data between various systems in parallel
Apache License 2.0
61 stars 22 forks source link

MySQLDbService: could not create DB table objects. note: name may only contain alphanumeric or underscore #34

Closed jonathanw42 closed 5 years ago

jonathanw42 commented 6 years ago

Based on the error, it appears a sync will not work if the filename/path has characters other than alphanumeric or underscores. Since I have a path with slashes and a dash in the filename for the date, I am seeing this error. Is there a workaround or some way to pre-process to rename?

jrosenth commented 6 years ago

That would appear to be a MySQL limitation. Not Ecs-sync.

You could try escaping the "-" properly (see MySQL docs ).

Jay

Sent from my iPhone

On Aug 6, 2018, at 5:01 PM, Jonathan Wilson notifications@github.com wrote:

Based on the error, it appears a sync will not work if the filename/path has characters other than alphanumeric or underscores. Since I have a path with slashes and a dash in the filename for the date, I am seeing this error. Is there a workaround or some way to pre-process to rename?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

twincitiesguy commented 6 years ago

I would check the entire stacktrace of the error. That message is only a hint at what the problem might be.

Note that the problem is not in the table name though because it is using a name of “objects” (the default if you do not provide a name via the CLI or XML configuration).

My guess is you’ve provided a MySQL connection string but are not running MySQL or the connection string is wrong.

twincitiesguy commented 5 years ago

Assuming this is resolved.