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 ```

Accepted Answer

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 -u -p < ```

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

Solution

Problem