修复1064 SQL错误将数据库导入Wampserver [英] Fixing 1064 SQL Error Importing Database into Wampserver

问题描述

将我的636MB数据库导入Wampserver时，我得到以下错误。有趣的是，我的最大执行时间设置为5000（php.ini）。我也尝试了大量的导入方法和压缩类型，所有具有相同的结果：MySql控制台，PhpMyAdmin控制台，BigDump，zip，gzip和最后使用config.inc.php上传指定的目录。感谢您的所有帮助，建议&建议。

When importing my 636MB database into Wampserver I get the below error. What is interesting is that I have max execution time set to 5000 in (php.ini). I have also tried numerous import methods and compression types all with the same results: MySql Console, PhpMyAdmin Console, BigDump, zip, gzip and finally using config.inc.php to upload a specified directory. Thank you for all help, suggestions & advice.

当前设置：


php.ini： >
post_max_size = 750M

upload_max_filesize = 750M

max_execution_time = 5000

max_input_time = 5000

memory_limit = 1000M



config.inc.php：

//最大执行时间（秒）（0表示无限制）

$ cfg ['ExecTimeLimit'] = 0;



my.ini：

max_allowed_pa​​cket = 200M

Current Settings:

php.ini:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

config.inc.php:
// maximum execution time in seconds (0 for no limit)
$cfg['ExecTimeLimit'] = 0;

my.ini:
max_allowed_packet = 200M

MySQL said: 
1064 - Erreur de syntaxe près de '<br />
Fatal error:  Maximum execution time of 300 seconds exceeded in <b' Ã  la ligne 141

Error
SQL query: 

INSERT INTO `log_url_info` (`url_id`, `url`, `referer`) VALUES
(2287337, 'http://www.website12345.com/sendfriend/product/send/id/44894/', NULL),
(2287338, 'http://www.website12345.com/sendfriend/product/send/id/44894/', NULL),
(2287339, 'http://www.website12345.com/sendfriend/product/send/id/44894/', NULL),
(2287340, 'http://www.website12345.com/catalog/category/view/id/66', NULL),
(2287341, 'http://www.website12345.com/catalog/category/view/id/718?multi_select_color_filter=2040', NULL),
(2287342, 'http://www.website12345.com/catalog/category/view/id/879?price=1000-2000', NULL),
(2287343, 'http://www.website12345.com/catalog/category/view/id/152?

limit=15&manufacturer=351&mode=list&multi_select_finish_filter=2602&multi_select_material_filter=2060&price=-1000', NULL),
(2287344, 'http://www.website12345.com/sendfriend/product/send/id/30583/', NULL),
(2287345, 'http://www.website12345.com/catalog/category/view/id/673?multi_select_finish_filter=2025', NULL),
(2287346, 'ht[...]

推荐答案

解决了！我不得不截断&优化日志表，并在导出时选择禁用外键检查。并且数据库导入！无需其他更改。

SOLVED! I had to truncate & optimize log tables and select "Disable foreign key checks" upon exporting. And the database imported! No other changes required.

这篇关于修复1064 SQL错误将数据库导入Wampserver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！