Copy MySQL database from one server to another remote server

from here

1 # on current server
      2 $ mysqldump -u user -p db-name > db-name.out
      3 # copy to other server
      4 $ scp -P 22 db-name.out user@remote.box.com:/backup
      5 # on new server
      6 $ mysql -u user -p db-name < db-name.out
      

Picture of Scott Motte

delicious facebook rss twitter

Spitfire Sky | github | archives | resume