7May/100
Howto Migrate MySQL DB or Table To Another Host
This is an easy script to move a database or table from one MySQL host to another quickly and easily. The following code can be run straight from the command line with a copy/paste of the variables, or put in a .sh file and run as a script.
fromuser=
frompass=
fromhost=
fromdatabase=
fromtable=
touser=
topassword=
tohost=
todatabase=
emailaddress=
date && mysqldump --user=$fromuser --password=$frompass - host=$fromhost --opt --skip-lock-tables --compress $fromdatabase $fromtable | mysql --user=$touser --password=$topassword --host=$tohost $todatabase && date && echo "script is done" | mailx -s "Script is done" $emailaddress
Gallery
Tags
80s
Add new tag
addons
amazon
baseball
boomcity
bug
cello
dance
drawing
facebook
fail
firefox
Funny
google
hip-hop
howto
jerklady
kids
linux
malachia
milk
movie
movies
mp3
mr men
music
photo
Pittsburgh
prom
robot
scenes
scifi
shows
snmp
stupid
T&R
tv
Tweets
ubuntu
video
videos
wpxi
wtf
youtube
Streb0r Tweets
- Loved School kills creativity (via Boxee) http://t.co/iWkcyEAe
- Loved M.I.A. - Bad Girls New single (via Boxee) http://t.co/UGzfsD8v
- Loved Cris Cab - Rihanna's Gun (Reggae with dubstep feel, from new EP) (via Boxee) http://t.co/hmRDuTV4
- Loved Sheep Cyclone. (via Boxee) http://t.co/V6z3zstt
- Loved After failed assault on bird's young, crab amputates its own damaged limb. (via Boxee) http://t.co/2RgsGuB4