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?
