Replicate-do-table cannot start slave mysql

Question

I'm having trouble starting a slave server when I add replicate-do-table. Current configuration that works:

server-id=2 master-host=10.100.27.99 master-user=slejv master-password=<pass> master-connect-retry=60 replicate-do-db=piksearch 

Configuration that does not work:

 server-id=2 master-host=10.100.27.99 master-user=slejv master-password=<pass> master-connect-retry=60 replicate-do-db=piksearch replicate-do-table=artikli replicate-do-table=artikli_polja replicate-do-table=artikli_posjete8 replicate-do-table=artikli_view replicate-do-table=kategorije replicate-do-table=online replicate-do-table=pitanje_artikal replicate-do-table=polja 

server02: / etc / mysql # / etc / init.d / mysql restart
Stopping the MySQL database server: mysqld.
Starting MySQL database server: mysqld. ,,,,,,, failed!

Answer 1

see link:

replicate-do-db is different than replicate-do-table

you must remove:

 replicate-do-db=piksearch replicate-do-table=artikli replicate-do-table=artikli_polja replicate-do-table=artikli_posjete8 replicate-do-table=artikli_view replicate-do-table=kategorije replicate-do-table=online replicate-do-table=pitanje_artikal replicate-do-table=polja 

and write:

 replicate-do-table=piksearch.artikli replicate-do-table=piksearch.artikli_polja ...