You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have the option "ANSI_QUOTES" in my original sql_mode. Which means the table names etc. get surrounded with double quotes in the exported sql
CREATE TABLE "my_table"
But on top of the exported sql there is this comment: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
So when importing the sql file again the sql_mode does not have the option ANSI_QUOTES anymore and the import fails fails because the dump has double quotes around table names and column names.
Solution is: if the option ANSI_QUOTES was present during the generation of the dump, it must stay present during the import too
The text was updated successfully, but these errors were encountered:
I have the option "ANSI_QUOTES" in my original
sql_mode
. Which means the table names etc. get surrounded with double quotes in the exported sqlCREATE TABLE "my_table"
But on top of the exported sql there is this comment:
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
So when importing the sql file again the sql_mode does not have the option ANSI_QUOTES anymore and the import fails fails because the dump has double quotes around table names and column names.
Solution is: if the option ANSI_QUOTES was present during the generation of the dump, it must stay present during the import too
The text was updated successfully, but these errors were encountered: