i'm using mysql2pgsql migrate database mysql postgres. can log mysql command line fine. i'm using .yml file make conversion, contains normal login details:
mysql: hostname: localhost port: 3306 socket: /tmp/mysql.sock username: root password: ************* database: user_data compress: false destination: # if file given, output goes file, else postgres file: postgres: hostname: localhost port: 5432 username: root password: ************ database: user_data
for reason i'm getting mysql socket error:
_mysql_exceptions.operationalerror: (2002, "can't connect local mysql server through socket '/tmp/mysql.sock' (2)")
any ideas how fix this?
check location of socket running
mysqladmin variables
replace socket:
returned
you remove socket key config. if remove socket key connect via tcp.