If you specify the database uri then it will not read your database.yml and relies on your mysql client configuration.
You can fix your problem by creating a file called .my.cnf in your home directory containing --> [client] socket=/opt/lampp/var/mysql/mysql.sock ... then just run the heroku command again heroku db:pull mysql://root:elr...@localhost/Reviewsite_development?encoding=utf8 On Mar 29, 2:41 am, GreenAsJade <[email protected]> wrote: > > heroku db:pull mysql://root:elr...@localhost/Reviewsite_development > > Failed to connect to database: > Sequel::DatabaseConnectionError -> Mysql::Error Can't connect to > local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) > > > > database.yml says: > > production: > adapter: mysql > encoding: utf8 > database: ReviewSite_development > pool: 5 > username: root > password: > socket: /opt/lampp/var/mysql/mysql.sock > > ... as you can see, heroku should not be trying to access /var/lib/ > mysql/mysql.sock ... database.yml is pointing to a socket under /opt --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
