Hi,
I've spent the last few days trying to set up basic Master Slave
replication with auto-backup on the Slave:
Xserve G5 (10.4.11 Server) -- PowerMac G5 (10.5.8 Client)
-- Both running MySQL 5.1.39 64-bit PowerPC
I've followed the docs and several online articles meticulously, and
got
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch which makes it much faster if you have
Hello,
I have a Python application that is using MySQL to store records of
transactions about 3 tables with ~1k records each.
How can I periodically copy the records off the production on to an archive
server? I would like to this for two reasons:
1) To run data-mining queries on a copy