Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Answer: What's the best way to copy LOTS! of records between 2 mySQL servers?

by Russ (Deacon)
on Aug 24, 2000 at 03:27 UTC ( #29354=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > What's the best way to copy LOTS! of records between 2 mySQL servers? - Answer contributed by Russ

MySQL also has
SELECT * FROM skr INTO OUTFILE 'filename'; LOAD DATA INFILE "filename" INTO TABLE skr;
The MySQL team says this is a very fast way to copy data from one server to another.

Check the MySQL Manual for more info.

Russ

  • Comment on Answer: What's the best way to copy LOTS! of records between 2 mySQL servers?
  • Download Code
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
[MidLifeXis]: Project Admin, a while ago: "No, I would prefer you didn't close that ticket yet confirming $vendor's support process yet. Continue to periodically check back to see if it has changed."...
[MidLifeXis]: Project Admin, today, after many periodic updates from me: "Why hasn't this been closed yet? Is there anything I can do to get this closed?" <facepalm>

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (11)
As of 2017-01-19 12:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (170 votes). Check out past polls.