mysql total replication question

2005-06-05 Thread Shannon R.
Hi All!

I'm using the latest mysql 4.0.x and I've successfully
set-up database replication on it over 2 machines.

I have noticed though that mysql doesn't seem to
replicate CREATE TABLE operations on the master to the
slave. Is this a limitation? Or I just missed
something. If so, can someone please give me a clue or
point me to the right place documentations?

Also, is it possible to setup replication so that
everything in the master is replicated to the slave,
included CREATE DATABASE operations?

Many Thanks!
Shannon


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: mysql total replication question

2005-06-05 Thread Gleb Paharenko
Hello.



In my replication setup with 4.1.11 master and 5.0.4 slave

CREATE TABLE and CREATE DATABASE  statements are replicated

perfectly.







Shannon R. [EMAIL PROTECTED] wrote:

 Hi All!

 

 I'm using the latest mysql 4.0.x and I've successfully

 set-up database replication on it over 2 machines.

 

 I have noticed though that mysql doesn't seem to

 replicate CREATE TABLE operations on the master to the

 slave. Is this a limitation? Or I just missed

 something. If so, can someone please give me a clue or

 point me to the right place documentations?

 

 Also, is it possible to setup replication so that

 everything in the master is replicated to the slave,

 included CREATE DATABASE operations?

 

 Many Thanks!

 Shannon

 

 

 __

 Do You Yahoo!?

 Tired of spam?  Yahoo! Mail has the best spam protection around 

 http://mail.yahoo.com 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]