Revision: 52701
Updated Code
at October 30, 2011 17:20 by nedf23
Updated Code
mysqldump -h [host_ip] --port=[3306] --user=[username] --password=[password] --opt --routines [database_name] | mysql -u [username] -p[password] --port=[3306] [database_name]
Revision: 52700
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 30, 2011 17:19 by nedf23
Initial Code
mysqldump -h [host_ip] --port=[3306] --[user=username] --password=[password] --opt --routines [database_name] | mysql -u [username] -p[password] --port=[3306] [database_name]
Initial URL
Initial Description
<h1>What it does</h1> <p>This snippet is used to pull data from one server to another. I primarily use it to get the latest data from our production to our development environments. The first part of the command is where the data is pulling from and the part after the "|" is where it is going to. In this case, it's localhost.</p> <h1>How to use it</h1> <p>Run from command prompt or terminal. Replace brackets with values.</p>
Initial Title
MySQL Data Pull to Localhost
Initial Tags
mysql, data
Initial Language
MySQL