Restore db from sql file

Question

I am tring import data from sql file using command line like this:

mysys-12: mysql -u root -p my_db_t < my_db_t_2022_10_12.sql

but I got:

mysql: [ERROR] unknown variable 'sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTIO

How can I import data? Should I add any params?

run Mysql console, connect to server, and run source commande : source file.sql; — bigtheo
– bigtheo, Commented Oct 12, 2022 at 10:17
Before.. I dump final DB to copy test version, mysqldump -u root -p dbx12_final > my_db_t_2022_10_12.sql — Blazej Kita
– Blazej Kita, Commented Oct 12, 2022 at 10:18
Well, when I put mysql -v I got the same error: mysql -v sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'. — Blazej Kita
– Blazej Kita, Commented Oct 12, 2022 at 11:52

RP.S · Accepted Answer · 2022-10-12 11:51:51Z

1

It seems that the content in the sql file conflicts with the constraint of sql_mode. There are two methods. The first method is to modify the content of the file to meet the constraint of sql_mode. The second method is to set SQL _ mode ='' in mysql. Then import the data and change it back.

answered Oct 12, 2022 at 11:51

RP.S

8377 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Blazej Kita · Accepted Answer · 2022-10-12 13:02:59Z

0

Problem solved, I removed sql-mode from client configuration, file: etc/mysql/conf.d/mysql.cnf

Server configuration - No change

answered Oct 12, 2022 at 13:02

Blazej Kita

1351 gold badge1 silver badge12 bronze badges

Collectives™ on Stack Overflow

Restore db from sql file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related