Web Hosting Talk







View Full Version : Trouble with importing SQL into database - Will pay for solution


webhostingj
04-09-2005, 10:03 PM
Hi

I've got a old phpbb database dump. I want to put this up again on my site along with the rest of the forum.

However when I try to upload the sql file through phmyadmin I keep getting an "Internal Server Error" I have contacted my host but I have a feeling its more to do with the size of the file, the SQL file is 2653kB .

What do I do. And I'm also looking for a phpbb pro who will be able to get my old forum running again. I've got all the files to a custom design that I got made.

MMania
04-09-2005, 10:11 PM
Please PM me your AIM or MSN handle. I have had these errors happen to me as well and I can fix them.

Robotical_Computer
04-09-2005, 10:38 PM
PM me your MSN, AIM, ICQ, or YIM, I can fix it as well. :)

Voxxit
04-09-2005, 11:08 PM
You could either gzip the file using SSH, or dump it manually through SSH. Either way will work.

Cheers,
Josh

assistanz247
04-10-2005, 02:06 PM
Ask your hosting support team to increase the size in the following line in /etc/my.cnf file :

set-variable = max_allowed_packet=xxxM

And make a try again...;)