CODEWITHSUNDEEP
mysqlruby-on-railsheroku
V.J.
V.J.

Reputation: 9580

Error while pulling mysql database in local mysql database

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.

Upvotes: 5

Views: 443

Answers (2)

Unni
Unni

Reputation: 165

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/

Upvotes: 3

c2h5oh
c2h5oh

Reputation: 4560

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.

Upvotes: 4

Related Questions