yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html -Sheeri On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote: > > No ideas? > > I tried playing around with read/write timeouts (even thought the > replication is fast), all size limits are greater than the whole > replicated db. The last table with accesses MYD and zero size is a small > one (a couple of dozens kBs). > > Bgs wrote: > >> >> Greetings, >> >> I played around with load data from master (ldfm) and it worked fine >> in test environment. Now I want to replicate our actual db to a slave. >> When I issue the ldfm command, it starts the replication. I get Query >> OK, but only about 5% of the db is replicated. Apparently all tables >> that are on the slave in the end are exact copies of the master >> tables, but most MYD files are zero sized.... >> >> >> Any ideas? >> >> Thanks in advance >> Bgs >> >> > Hi - Which storage engine are you using for the tables or database which you're trying to replicate? Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
