This article mainly introduces the solution to the error when importing mysql big data in Navicat. Friends who need it can refer to
Navicat's own data everywhere, and it cannot be imported when importing.
Finally choose to use the MySQL command import method to complete the data import
Use the command
use
shortcut\usource
shortcut Method\.
The shortcut can be queried through help
mysql>\u dataname mysql>\. d:\mysql\dataname.sql
Problems encountered during import and solutions
When importing Chinese garbled characters
Solution:
When exporting with Navicat, UTF8 encoding is used. When importing, MySQL uses its own default encoding method to import, and Chinese garbled characters are generated
Query with command
mysql>show variables like '%char%';
If you query, you will see that the encoding is gbk
and then use
mysql>set character_set_results=utf8; mysql>set .....(类同都修改成utf8)
to execute the import again, OK! The encoding is normal and the import is successful.
【Related Recommendations】
2.MYSQL Unlock Detailed explanation of examples of table locking and locking Error
The above is the detailed content of Detailed explanation of how to report errors when importing mysql big data into Navicat. For more information, please follow other related articles on the PHP Chinese website!