LOAD DATA FROM MASTER ... skips mysql.* tables!

It seems that "LOAD DATA FROM MASTER" in 4.0 doesn't load any of the
tables in the "mysql" database. The result is that users and
permissions on the master are not carried over to the slave.

This is not documented. It should probably be an option, because
there are many times when you *do* want ALL the tables cloned.

How-To-Repeat:

Create a new user on the master.

Execute LOAD DATA FROM MASTER on a new slave.

Notice that the user is missing on the slave.

Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
| http://jeremy.zawodny.com/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12894@lists.mysql.com
To unsubscribe, e-mail

LOAD DATA FROM MASTER ... skips mysql.* tables!

Hi!

Found this while going through my email backlog...
(Sorry for the late response)

>>>>> "Jeremy" == Jeremy Zawodny writes:

Jeremy> It seems that "LOAD DATA FROM MASTER" in 4.0 doesn't load any of the
Jeremy> tables in the "mysql" database. The result is that users and
Jeremy> permissions on the master are not carried over to the slave.

Jeremy> This is not documented. It should probably be an option, because
Jeremy> there are many times when you *do* want ALL the tables cloned.

Jeremy> How-To-Repeat:

Jeremy> Create a new user on the master.

Jeremy> Execute LOAD DATA FROM MASTER on a new slave.

Jeremy> Notice that the user is missing on the slave.

I have now put adding an option to also copy the MySQL database on our TODO.

Regards,
Monty

--
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13263@lists.mysql.com
To unsubscribe, e-mail