Bug #16578 load table from master need better err msg whe not supported
| Submitted: | 17 Jan 2006 19:02 | Modified: | 31 Aug 2006 19:00 |
|---|---|---|---|
| Reporter: | Jonathan Miller | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.1.6-alpha | OS: | Linux (Linux) |
| Assigned to: | CPU Architecture: | Any |
[17 Jan 2006 19:02]
Jonathan Miller
[6 Feb 2006 13:57]
Tomas Ulin
load table from master is only supported for myisam, maybe better error message should be implemented in the server when trying to load a non myisam table
[18 Apr 2006 6:47]
Jon Stephens
Already documented in Cluster Limitations.
[18 Apr 2006 10:46]
Jonathan Miller
A better error message is needed for this issue.
[31 Aug 2006 19:00]
Trudy Pelzer
Since the current implementation of LOAD DATA FROM MASTER and LOAD TABLE FROM MASTER is very limited, these statements are deprecated in versions 4.1, 5.0 and 5.1 of MySQL. We will introduce a more advanced technique (online backup) in a future (>5.1) version, that will have the added advantage of working with more storage engines. For 5.1 and earlier, the recommended alternative solution to using LOAD DATA|TABLE FROM MASTER is mysqldump on the master piped (or output copied) to the mysql client on the slave. This also has the advantage of working for all storage engines. Another alternative is mysqlhotcopy, which is faster because it does a binary copy, but works only for MyISAM tables. A deprecation warning has been added for these statements in 4.1, 5.0 and 5.1.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.064 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.