Skip to content

Instantly share code, notes, and snippets.

@benoitjpnet
Created July 9, 2013 12:54
Show Gist options
  • Save benoitjpnet/5957102 to your computer and use it in GitHub Desktop.
Save benoitjpnet/5957102 to your computer and use it in GitHub Desktop.
Migrate MySQL users.
# SRC Server
mysql mysql -e "select * from user WHERE USER='user1' OR USER='user2' INTO OUTFILE '/tmp/mysql_user';"
mysql mysql -e "select * from db WHERE USER='user1' OR USER='user2' INTO OUTFILE '/tmp/mysql_db';"
# DST Server
scp server:/tmp/mysql_{db,user} /tmp
chmod 664 /tmp/mysql_{db,user}
mysql mysql -e "LOAD DATA INFILE '/tmp/mysql_user' INTO TABLE user;"
mysql mysql -e "LOAD DATA INFILE '/tmp/mysql_db' INTO TABLE db;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment