Nope... pure myisam...
sheeri kritzer wrote:
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]
