- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 6.0 Reference Manual :: 19 Replication :: 19.3 Replication Notes and Tips :: 19.3.1 Replication Features and Issues :: 19.3.1.10 Replication and LOAD DATA
Section Navigation [Toggle]
- 19.3.1 Replication Features and Issues
- 19.3.1.1 Replication and AUTO_INCREMENT
- 19.3.1.2 Replication and Character Sets
- 19.3.1.3 Replication of CREATE TABLE ... SELECT Statements
- 19.3.1.4 Replication and DIRECTORY Statements
- 19.3.1.5 Replication of Invoked Features
- 19.3.1.6 Replication with Floating-Point Values
- 19.3.1.7 Replication and FLUSH
- 19.3.1.8 Replication and System Functions
- 19.3.1.9 Replication and LIMIT
- 19.3.1.10 Replication and LOAD DATA
- 19.3.1.11 Replication During a Master Crash
- 19.3.1.12 Replication During a Master Shutdown
- 19.3.1.13 Replication with MEMORY Tables
- 19.3.1.14 Replication of the System mysql Database
- 19.3.1.15 Replication and Reserved Words
- 19.3.1.16 Slave Errors during Replication
- 19.3.1.17 Replication during a Slave Shutdown
- 19.3.1.18 Replication and Temporary Tables
- 19.3.1.19 Replication Retries and Timeouts
- 19.3.1.20 Replication and Time Zones
- 19.3.1.21 Replication and Transactions
- 19.3.1.22 Replication with Differing Tables on Master and Slave
- 19.3.1.23 Replication and Variables
- 19.3.1.24 Replication and Views
The LOAD DATA statement is not replicated
correctly to a slave running MySQL 5.1 or later from a master
running MySQL 4.0 or earlier.
When using statement-based replication, the LOAD DATA
INFILE statement's CONCURRENT
option is not replicated; that is, LOAD DATA CONCURRENT
INFILE is replicated as LOAD DATA
INFILE, and LOAD DATA CONCURRENT LOCAL
INFILE is replicated as LOAD DATA LOCAL
INFILE. The CONCURRENT option
is replicated when using row-based
replication. (Bug#34628)
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.