[
https://issues.apache.org/jira/browse/SQOOP-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14989710#comment-14989710
]
Jarek Jarcec Cecho commented on SQOOP-2658:
-------------------------------------------
Per [MySQL
documentation|http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_schema]
the words {{schema}} and {{database}} are synonyms. Hence MySQL really doesn't
have support of schema in the same sense as
[PostgreSQL|http://www.postgresql.org/docs/9.4/static/ddl-schemas.html] or
[Microsoft SQL Server|https://msdn.microsoft.com/en-us/library/ms189462.aspx].
That is why the MySQL connector does not have support for {{\-\-schema}}
argument as those two connectors.
> MySQL doesn't take a schema parameter
> -------------------------------------
>
> Key: SQOOP-2658
> URL: https://issues.apache.org/jira/browse/SQOOP-2658
> Project: Sqoop
> Issue Type: Bug
> Components: connectors/mysql
> Affects Versions: 1.4.6
> Reporter: xplenty
> Labels: mysql, sqoop
>
> When using MySQL with sqoop user cannot connect to a different schema than
> that connected to (in the connection string) even though MySQL supports it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
