Error while pulling mysql database in local mysql database

Question

I am trying to pull heroku mysql database into my local mysql database but it gives me some error.

I have posted the issue on github. Here is the issue which i have posted on github. I also post the log of error.

please help me to solve out this problem.

Is there any other way to get heroku database into my local database..?

I am also trying to fetch data via chunksize but it fetch only 60 to 70% data after that it gives the same error.

Answer 1

It's likely MySQL has reached net_read_timeout during operation - it defaults to 30 seconds (it happens with heroku).

Add in your MySQL configuration file:

net_read_timeout = 300
net_write_timeout = 300

restart MySQL and try again.

Answer 2

You can use command prompt for importing the DB, otherwise size constraint is there.

Use mysql command for the same. Refer: http://www.cyberciti.biz/faq/mysql-import-command/