Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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

by whahoo (Acolyte)
on Aug 23, 2000 at 09:00 UTC ( #29165=categorized question: print w/replies, xml ) Need Help??
Contributed by whahoo on Aug 23, 2000 at 09:00 UTC
Q&A  > database programming


Answer: What's the best way to copy LOTS! of records between 2 mySQL servers?
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

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

mysqldump -u<username> -p<password> \ -h<remote_host> -c <databasename> | mysql \ -u<localuser> -p<localpassword> newdatabase you may add --add-drop-table on the left side of the pipe if the database tables already exists locally and -C if you are on a slow connection (uses a compressed protocol for data tranfer)

Please (register and) log in if you wish to add an answer



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    [davido]: when i do get to that point I think I'll do it in a vm snapshot just in case. :)
    [oiskuu]: tye, you were right: loginuid/sessionid are part of task struct if compiled with AUDITSYSCALL. I have some doubts if you should actually depend on that feature.
    [Corion]: oiskuu: Depends on what you want to do with that information
    [tye]: I'm not depending on that feature. But I could in this environment. I'm using getlogin(). shrug
    [Corion]: For benign logging (which user started this DB instance), it's OK
    [tye]: We use auditd for security monitoring. So we can rely on auditing being enabled. I'm not sure who would want to not be able to audit. Maybe some VM inside another system with audit?
    [SuicideJunkie]: spies would want a system to not be able to audit.

    How do I use this? | Other CB clients
    Other Users?
    Others surveying the Monastery: (8)
    As of 2017-06-23 20:14 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?
      How many monitors do you use while coding?















      Results (555 votes). Check out past polls.