Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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:

server-id=1
log-bin=mysql-bin
sync_binlog=1
expire_logs_days=7

And here is the relevant slave configuration:

server-id=2
relay-log=mysqld-relay-bin
report-host=myhost.domain.com

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?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer

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.

share|improve this answer
    
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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