Dump sql file to ClearDB in Heroku

You might be able to do something like this

mysql --host=us-cdbr-east.cleardb.com --user=b5xxxxx7 --password=37d8faad --reconnect heroku_xxxxxx < my_dump_file.sql

mysql ruby-on-rails ruby heroku

It doesn't work for me on the new version of mysql. So I tried following code:

mysql -h us-cdbr-east.cleardb.com -u b5xxxxx7 -p heroku_xxxxxx < my_dump_file.sql

and then it asks your password.

mysql ruby-on-rails ruby heroku

I was getting errors when I typed it all at once so I broke it down into small steps first I entered my MySQL details like so:

mysql --host=us-cdbr-iron-east-02.cleardb.net --user=xxxxxxxxxxxxxx --password=xxxxxxxx --reconnect

then once I got in I changed to the database like so:

mysql> use heroku_xxxxxxxxxx;

then I now imported the SQL file like so:

mysql> source path/to/file.sql;

CodeHunter