ms access - mysqlimport - issue with spaces in table name -
dealing incompetent database design here. moving app ms access mysql , moment important preserve table names. access db creator has spaces in table names... i tried doing import soft quotes, hard quotes, backticks, , no quotes give "check manual corresponds mysql server version right syntax use near 'citation table' @ line 1, when using table: chain citation table" i saw can escape spaces in commands eg rm chain\ citation\ table.txt same error that. here example: mysqlimport --host=mysql.myhost.com --user=dbuser -p \ --local --delete \ --fields-optionally-enclosed-by='|' \ --fields-terminated-by=';' \ --lines-terminated-by='\n' \ dbname "chain citation table.txt" what right way handle messed situation? have make holding table named somethingwithoutspaces , import , copy across? thanks advice. you try using access mysql converter , has worked me in past.