April 2008
Intermediate to advanced
566 pages
21h 55m
English
Content preview from MySQL in a Nutshell, 2nd EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Name
LOAD DATA FROM MASTER
Synopsis
LOAD DATA FROM MASTER
This statement has been deprecated and will be removed from
future releases of MySQL. It never worked very well. It was meant to
make a copy of all the databases on the master server (except the
mysql database) and copy them to the slave servers.
It gets a global read lock on all tables while it takes a snapshot of
the databases, and releases the lock before copying them to the
slaves. The MASTER_LOG_FILE and the
MASTER_LOG_POS variables will be updated so that
the slave knows where to begin logging.
This statement works only with MyISAM tables. The user for the
connection must have RELOAD,
SELECT, and SUPER privileges on
the master server. The user must also have CREATE and DROP
privileges on the slave server. For large databases, increase the
values of the net_read_timeout and
net_write_timeout variables with the
SET statement. To load a specific table from the
master server, use the LOAD TABLE...FROM MASTER statement.
Again, this statement does not work very well: it’s not
dependable and usually has problems with properly copying data from
the master to the slave. Instead, use a utility such as
mysqldump to copy the data on the master and then
transfer the resulting file to the slave, as described in detail in
the tutorial section at the start of this chapter.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.