How do I push my mysql database from phpmyadmin to heroku's cleardb?

Question

I'm using WAMP server for running my php app. I have a database BOOK in phpmyadmin. How can I push this data to heroku. I have used add on to add cleardb to my app.

heroku config shows the database url too.

I tried

db:push mysql://root@localhost/BOOK 

but it didn't work.

ERROR -->

 Failed to connect to database:
 Sequel::AdapterNotFound -> LoadError: cannot load such file -- mysql

Answer 1

ClearDB recommends using mysql and mysqldump for importing data. From Frequently Asked Questions on ClearDB.com:

For importing data into your MySQL database, we recommend that you use both the mysql command line client as well as the mysqldump database backup utility.

Syntax for importing is something like this:

$ mysql <dbname> -u <username> -p<password> < <file.sql>