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

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

by Anonymous Monk
on Aug 23, 2000 at 15:24 UTC ( #29180=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 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)

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

What's my password?
Create A New User
Chatterbox?
[Corion]: ovedpo15: You could split on comma, and then join everything together, except the last part. Or you could match and make sure that the last part has no comma, like qr!,[^,]+$!, or you could use rindex.
[ovedpo15]: But I don't know the length of the string. will it still work?
[ovedpo15]: The only thing I know is that there is a comma at the end and a value after that
[hippo]: Try it and see. Your computer won't explode.
[Corion]: length will tell you the length of a string.
[Corion]: But if you are parsing CSV, again, let me point to Text::CSV_XS, which you should use instead
[hippo]: +1 for Text::CSV_XS
[ovedpo15]: Im not allowed to use additional modules, so I can't use it. looking for a simple regex to do this task though..
[Corion]: Ah, so this is homework? Then most likely, you should review your course material closer. It would greatly surprise me if the course material wouldn't mention the topics that will be used in the homework...
[Corion]: I already showed you the simple regex to match the last part of a string without a comma in it

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (10)
As of 2018-05-27 10:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?