• 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?

Viewing 1 replies (of 1 total)
  • “MySQL server has gone away” is a timeout error at your host. Ask them why the server is crashing and how to increase the timeout.

Viewing 1 replies (of 1 total)
  • The topic ‘Error Importing Database w/ Bigdump: MySQL server has gone away’ is closed to new replies.