title: mysql replicate a view won't work
body: <p>I am trying to replicate a specific view on mysql slave while ignoring the base table.
  I have created a view that select * from a specific table on a specific DB.
  In the slave my.cnf I have restricted the replication to the following:</p>
  
  <pre><code>replicate-do-db=DBNAME
  replicate-ignore-table=TABLENAME
  </code></pre>
  
  <p>When I start the replication on the slave, I get an sql error :</p>
  
  <pre><code>Last_SQL_Error: Error 'TABLENAME 'DBNAME.TABLENAME' doesn't exist' on query. Default database: 'DBNAME'. Query: 'CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `TABLENAMEVIEW` AS SELECT * FROM TABLENAME'
  </code></pre>
  
  <p>I am using mysql 5.5.1 and as per the following <a href="http://dev.mysql.com/doc/refman/5.5/en/replication-features-views.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.5/en/replication-features-views.html</a> a view can be replicated even if the table is ignored.</p>
  
  <p>Any idea how I can solve this ?</p>
  
  <p>Thanks, </p>