Ok, so I just moved to this hosting and I’m trying to transfer my data on over from another server. I’ve got a sql export from my previous host to install on this server. Unfortunately it’s too big for PHP MyAdmin.
So I followed the directions from here http://wiki.dreamhost.com/Migrate_MySQL and uploaded the SQL file and attempted to import it using the following command (where info is changed to my details): mysql -h mysql.example.com -uusername -ppassword newdbname < outfile.sql
I got an error: Access denied for user ‘mydatabaseuser’@‘ipaddress/255.255.224.0’ to database ‘mydatabase’.
So I tried using my account name and account password and got:
ERROR 1045 (28000): Access denied for user ‘myusername’@‘gorgon.dreamhost.com’ (using password: YES)
The SQL file doesn’t have a “Create database” line in it. I just want to shove the data in the new database. What’s the correct command line? What am I missing?