开发者

Error when importing mysql database (about 80mb's) using BigDump

开发者 https://www.devze.com 2023-03-01 03:22 出处:网络
So I have this mysql database that is way to huge to import via phpmyadmin. When I set it up with bigdump I get this error right off the bat

So I have this mysql database that is way to huge to import via phpmyadmin. When I set it up with bigdump I get this error right off the bat

Stopped at the line 339.

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts."

So after 300 lines with no break it crashes. I went in and pasted this string in line 200 just to make sure that much was correct:

INSERT DELAYED INTO `invites_statistic` 
(`user_id`,`purchaseid`,`prodid`,`reg_length`,`invites_count`,`used`,`code`)
VALUES

I tried changing the length of the "Maximum length of created que开发者_如何学Cry" in phpmyadmin but then I was getting even more errors telling me I couldn't have that string in certain places.

I jumped around the SQL file adding the previous string a few lines before everytime it broke and that was working but this is a HUGE file 400k lines. Anyone know a good solution? Am I doomed?


I solved this problem by changing the $max_query_lines value from 300 to a higher number.

// How many lines may be considered to be one query (except text lines)
$max_query_lines = 10000;
0

精彩评论

暂无评论...
验证码 换一张
取 消