I setup MySQL master slave replication, but none of the databases, tables, and data is being copied over to the slave from the master.

Here is the relevant configuration on the master:


And here is the relevant slave configuration:


I am assuming I don't need to manually import all the data into the slave, I assume, the master automatically syncs the information correct?


No, your assuming is wrong. You must take a data snapshot and configure the slave with the replication coordinates from the master. Take a look at this for more details.


You need to create a snapshot of the data and import that in to your slave before you start the replication slave. Typically that is done with mysqldump.

On you master check "show Master status", and on your slave check "show slave status".

That will give you any errors.

And follow what quanta link you to.

  • Do I include the mysql and information_schema databases in the dump?` – Justin Oct 28 '11 at 0:55
  • It depends if you want to replica them. On the systems I setup I didn't choose to replicate mysql and information_schema. – Squidly Oct 28 '11 at 0:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.