Joey,
from what I can see from your email you lack of a lot of basics and I
suggest you to read some documentation before proceeding.
Maatkit is now Percona Toolkit and contains some of the best tools for
MySQL.
Cheers
Claudio
2012/6/5 Joey L <mjh2...@gmail.com>
> Hi -
> I have setup mysql mult master setup on debian squeeze.
> I have realized that the databases have to be initially in sync before
> multi master can operate properly.
>
> This can require a lot of down time on the one functioning server.
> Is there a way to do an automatic sync from the 1 server that is still
> running ??
>
> I have found a tool dpkg package called Maakit , but having trouble
> running it - get this error on the master:
>
> mk-table-sync -u sl2 -ppswd --print --sync-to-master --replicate
> mailserver 192.168.1.11
> DBI connect(';host=192.168.1.11;mysql_read_default_group=client','sl2',...)
> failed: Access denied for user 'sl2'@'mybox.somedomain.com' (using
> password: YES) at /usr/bin/mk-table-sync line 1284
>
> can anyone assist with the error ?
> Or can someone tell me of a better opensource tool to use to sync the
> servers without a mysql dump ? my db is rather large.
>
> thanks
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
--
Claudio
