Error Importing Database w/ Bigdump: MySQL server has gone away
-
I’m trying to import a 32mb database using Bigdump as Phpmyadmin can’t handle anything that large.
I get an error about 1/3 of the way through the import stating:
“MySQL server has gone away”
Reading around, it is suggested that this error occurs if the database has extended inserts. Mine does not. I’ve also played around with $linespersession and $delaypersesssion but the import always times out at line 15001 of my DB which is:
INSERT INTO
wp_comments
(comment_ID
,comment_post_ID
,comment_author
,comment_author_email
,comment_author_url
,comment_author_IP
,comment_date
,comment_date_gmt
,comment_content
,comment_karma
,comment_approved
,comment_agent
,comment_type
,comment_parent
,user_id
) VALUES(14281, 1307, ‘Heather of Kitchen Concoctions’, ”, ”, ”, ‘2011-03-03 11:15:07’, ‘2011-03-03 18:15:07’, ‘Immediately when I saw these I thought to use them crushed up to add to homemade ice cream! Cookie Dough Ice Cream is my favorite way to eat cookie dough!’, 0, ‘1’, ”, ”, 0, 0);Nothing more special than a comment.
Has anyone used Bigdump and overcome a similar error?
If not, is there an alternative way of importing a large DB?
- The topic ‘Error Importing Database w/ Bigdump: MySQL server has gone away’ is closed to new replies.