I have a WordPress database that I want to import into the DH MySQL. My panel shows the hostname as mysql.mydomain.com but since I haven’t transferred my domain yet that isn’t valid. I see the name mcgruff:dsouza in the panel, and I found the following command for importing a database form shell, but it’s telling me it can’t get to the database:
mysql -h mcgruff:dsouza -umyuser -pmypsw dbname < blog.sql
To be specific, if I just use “-h mcgruff” I get:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘mcgruff’ (111)
and for anything else I get:
ERROR 2005 (HY000): Unknown MySQL server host
so I think mcgruff is valid.
I’ve created a new subdomain called mysql.mysubdomain.dreamhosters.com but I’m not sure how long it will take for the DNS reference to propagate, or if I even did that right. Then I added that in the panel as a MySQL hostname. So far of course using that as a hostname doesn’t work.