Having trouble with mySQL also

[wjstev0]

I have someone who is trying to install a database for me on pulsar. He was using phpmyadmin on the pulsar server to install a database, but because of the size of the database dump file 10Meg it kept timing out before it could upload. So he broke it up into individual components where they were under a meg each but whenever phpAdmin attempts to use them it is giving a 500 error.

What gives? Is there a problem with the server or the a limitation on the size of the dump?

Thanks
BillStevens


__________________
wjstev0

[HalfaBee]

I think your best bet is to upload the file to the server and download a copy of phpshell.php from http://www.gimpster.com/php/phpshell/index.php

Make sure you secure this script with .htaccess/.htpasswd or just remove it when not needed.

Then type this in the command line

mysql -uusername -ppassword < file.sql

This should do the job.

HalfaBee

[wjstev0]

It doesn't get me to the mySQL database. And if I could find the SQL database how do I upload the file.


Thanks

[HalfaBee]

Sorry the command line should be

/usr/local/bin/mysql -uusername -ppassword DB < file.sql

Use an FTP program to upload the file.
I like SmartFTP but any ftp program should do.


You can't access the database directly. You have to use some kind of client.
mysql is the simple server interface.
phpmyadmin is a php based version.



HalfaBee