Skip to content

Instantly share code, notes, and snippets.

@greeness
Created December 13, 2012 02:53
Show Gist options
  • Save greeness/4273631 to your computer and use it in GitHub Desktop.
Save greeness/4273631 to your computer and use it in GitHub Desktop.
fast way of loading data into mysql table
cat mysql-statement
> insert into mytable (k, v) values (1,2);
> insert into mytable (k, v) values (2,2);
> insert into mytable (k, v) values (3,2);
scp mysql-statement to an ec2 machine
ssh to the ec2 machine
$ mysql -h hostname -u username -p password database_name < mysql-statement
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment