mysql table replication on just some records? I have a big database which contain a table with about 26 million records. Now i need to make some reports on it from a special period of time.

So how to make a replication from that table from a special time, for example, just show replicate the records from 2015-01-01 till now?
I suggest using mysqldump instead of replication.

mysqldump &lt;other-params&gt; --where="date &gt;= '2015-01-01'" db table &gt; dump.sql


That way you have dump file which can be reused. Import will take some time, but setup is much simpler - you can import it anywhere and do what you need.