Database dump problem

[ItsManBearPig]

Hello,

Not sure if anyone could help me here, but i'm trying to transfer a database dump (.sql file of approx. 70 megs) from my local machine to my database on bluehost. I'm using the same php script that I used to dump the database from my old server to my local machine (where it worked fine), but its not working now on my bluehost server.

I have the sql file and php files uploaded into a temp directory within public-html on my server, and I changed the permissions to 777 in that folder for the time being.

In the script I had to enter the database info, so here's what i had:
$db_server = 'localhost';
$db_name = 'my database name';
$db_username = 'my username';
$db_password = 'my password';

I set up the database and username through the mySQL Databases, and there's no tables in the database, they should all just get dumped in. Also gave the user all priviledges to that database.

when i go to www.mydomain.com/dump/bigdump.php i get the following 500 Internal Server Error message:


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

Please contact the server administrator, 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.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Any thoughts?

[Basil]

Is there anything in the error log?

There may or may not be an error_log file in the folder with the script.

[ItsManBearPig]

No, there is no error log.

[Basil]

Unfortunately a server error is extremely difficult to diagnose without actually looking at the server, there are so many different variables.

Support may be able to help you with this.

[siguie]

Can't you use the MySQL Database Manager in CPanel? :)