magento sql 4G 匯入報錯
http://injustfiveminutes.com/2013/02/14/errors-restoring-mysql-database-dump-on-wamp-environment/
Errors restoring MySQL database dump on WAMP environment
You have maybe happened to get lots of errors when sourcing a .SQL database dump into a new WAMP installation, looking like these:
ERROR
1231 (42000): Variable ‘time_zone’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘foreign_key_checks’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘unique_checks’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘character_set_client’ can’t be set to the value of ‘NULL’
Query OK, 0 rows affected (0.00 sec)
ERROR
1231 (42000): Variable ‘collation_connection’ can’t be set to the value of ‘NULL’
ERROR 1231 (42000): Variable ‘sql_notes’ can’t be set to the value of ‘NULL’
The above errors where thrown trying to restore a Drupal database dump and lead to think there’s a clash among MySQL servers versions.
However, it all has to do with the maximum allowed size of blog fields within the database which defaults to 16MB.
Try to make it arbitrarily high temporarily by typing in:
mysql> set global max_allowed_packet=1000000000;
Then source your dump again:
mysql> source ./my_db.sql;
Finally restart your Wamp server to leave max_allowed_packet back to its default value.
相關文章
- mysqlimport匯入報錯的排查MySqlImport
- Mysql資料庫使用Navicat Mysql匯入sql檔案報錯MySql資料庫
- PythonMySQLdb匯入libmysqlclient報錯PythonMySqlIBMclient
- mysql匯入報錯Variable 'sql_notes' can't be set to the value of 'NULL'MySqlNull
- 匯入sql時報日期型別錯誤SQL型別
- 【MySQL篇】Navicat匯入SQL大檔案報錯終極解決方案MySql
- mysql匯入報錯怎麼解決?MySql
- expdp 全庫匯入報錯總結
- navlicat 匯入匯出SQLSQL
- 匯入專案@override 報錯處理IDE
- oracle 匯入報錯:field in data file exceeds maximum lengthOracle
- exp/imp匯入匯出版本問題和ORA-6550報錯
- STS(SQL Tuning Set)匯入匯出過程及錯誤處理SQL
- mysql 匯入匯出 sql檔案MySql
- SQL語句匯入匯出大全SQL
- Python匯入包報錯(沒有這個包)Python
- mysql匯入sql檔案報錯 ERROR 2013 2006 2002MySqlError
- 【ORACLE 匯入匯出】exp 錯誤Oracle
- xampp 用 shell 匯入sqlSQL
- 【SQL*Loader】sqlldr匯入SQL
- 從Excel匯入sql serverExcelSQLServer
- oracle匯入TYPE物件報錯ORA-02304Oracle物件
- magento2 後臺資料展示+csv匯出
- .sql檔案匯入到sql server中SQLServer
- SQL資料庫的匯入和匯出SQL資料庫
- Navicat如何匯入和匯出sql檔案SQL
- (轉)excel和sql server的匯入匯出ExcelSQLServer
- [zt] SQL Server匯出匯入資料方法SQLServer
- 資料泵匯入分割槽表統計資訊報錯(七)
- 資料泵匯入分割槽表統計資訊報錯(二)
- 資料泵匯入分割槽表統計資訊報錯(四)
- 資料泵匯入分割槽表統計資訊報錯(三)
- 資料泵匯入分割槽表統計資訊報錯(六)
- 資料泵匯入分割槽表統計資訊報錯(五)
- 若依框架匯入阿里OSS報錯問題解決方案框架阿里
- SQL server資料匯入OracleSQLServerOracle
- Excel 匯入 SQL Server 步驟:ExcelSQLServer
- ubuntu 下mysql匯入和匯出.sql檔案UbuntuMySql