Search code examples
mysqllinuxreplicationpid

Replicate Remote DB Mysql

I´m following this tutorial (http://www.linux-party.com/42-mysql/8628-como-replicar-una-de-base-de-datos-de-mysql-2-de-2)..

When I configure slave (my.cnf) with this parameters:

server-id=2
master-host=xxx.xxx.xxx.xxx
master-user=root
master-password=xxxxxxxxx
master-connect-retry=60
replicate-do-db=db_mirror

And restart mysql, I get the following error:

ERROR! MySQL server PID file could not be found!
Starting MySQL.. ERROR! The server quit without updating PID file 
(/var/lib/mysql/xxxxxxxxx.com.pid)

Any suggestions?

Thanks

Solution

  • File my.cnf was bad configurated....