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