Posted By

nedf23 on 10/30/11

Tagged

mysql
data

Versions (?)

Last Edited at 10/30/11 05:19pm

Statistics

Viewed 2463 times

Favorited by 1 user(s)

Related snippets

MySQL Data Pull to Localhost

/ Published in: MySQL

What it does
<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>

How to use it
<p>Run from command prompt or terminal. Replace brackets with values.</p>

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

mysqldump -h [host_ip] --port=[3306] --user=[username] --password=[password] --opt --routines [database_name] | mysql -u [username] -p[password] --port=[3306] [database_name]