phpmyadmin File Import

[marcusm88]

I'm trying to import a file into the database using phpmyadmin, I keep getting an Internal Server Error Msg... Has anyone else experienced this problem?

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, edge100x@nuclearfallout.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Apache/2.0.54 (Gentoo/Linux) Server at hostileweb.nuclearfallout.net Port 80

[Nick|NFo]

How big is this sql file? Looks like this file is excessively large to upload at once, so you should try breaking up the sql file and uploading it in parts.

[marcusm88]

1mb gzipped

[marcusm88]

6mb regular .sql I'll try splitting it up in to a few files.

[Nick|NFo]

try using regular .sql and about 1 mb each

[marcusm88]

Sweet. Yep it's working. Thnx.

BTW phpmyadmin is the only remotesql script tool i've ever used... Are there any others that are as good or better?

[Nick|NFo]

BTW phpmyadmin is the only remotesql script tool i've ever used... Are there any others that are as good or better?

phpmyadmin is the best one in my book

[yodaky]

try using regular .sql and about 1 mb each

i hate to revive an old thread but how does one "break up" the file? just cut and paste some stuff from the main one until it is smaller?

i have emailed support about a similar error but if this solves it then i will be relieved lol.

[Nick|NFo]

You can break it up after any ; in the sql file.