I'm having a difficult time synchronizing my Master and Slave Servers.
I've been doing this using MySQL Binary Logs, where the Master rotates the
logs at 1 hour times, and the slave downloads it and imports it.
What happens why I try to pipe the binlog into mysql is that it reports and
error that there is a duplicate entry. Basically what I want to do, is
overwrite the duplicate with the data from the binlog, but I can't find a
way? thoughts?
MySQL Slave import command that I've been using and having fail
for i in dbbin*; do /usr/local/bin/mysqlbinlog $i |
/usr/local/bin/mysql -f -u root --password=l4ka5Tdj databasename; done
I can see there is a -r function in mysqlimport, but of course the BinLogs
are in SQL format and this will not work
Any help would be GREATLY appreciated
p.s. suggesting that I use mysql's built in replication is not help.
Thanks,
Michael McConnell
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php