Migrating MYSQL


#1

Hi all,

I’m trying to import my SQL file from my old server to dreamhost. It’s saved on my computer and it’s over 7mb so I’m following the wiki instructions - I have a dreamhosters mirror set-up, I have my new mysql database set-up and everything should work but when I try importing through the shell with:

mysql -h mysql.example.com -u username -ppassword dbname < outfile.sql

filling in everything correctly (I hope), I get:

“ERROR 1045 (28000): Access denied for user ‘username’@‘homam.dreamhost.com’ (using password: YES)”

Any ideas? [hr]
nevermind - got it. was using the wrong username and password combo.


#2

Are you able to ping your mysql host?