got problem import sql to dreamhost(large file)

hello

can u help me,

always got problem to move my database to dreamhost from servage

try use shell : message cannot conect database server,


via phpmadmin always corrupt

file size 200 mb and 40mb if zip

thx

 

You can use bigdump.php attached below to import large file

 

Make a fresh backup using SSH command
mysqldump -udbusername -pdbpassword --dbname >filename.sql

then move tht .sql file with wget command Using SSH
wget http://ursite.com/filename.sql

then extract tht sql file using SSH command
mysql -uusername -ppassword -- username < file.sql

If u have problem extracting the sql file simply ask your host they will do it easily.

 

That's good except for one thing. I would advise not putting the password in the command line. I would just put -p and it will prompt for a password which will be much safer.