Posted By

bionic on 12/04/10


Tagged

mysql Bash linux mysqldump


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

titosemi


Transfer database and tables from one server to another


 / Published in: Bash
 

URL: http://answers.google.com/answers/threadview?id=24558

Right at the bottom

  1. mysqldump --opt --compress --user=USERHERE --password=PWHERE
  2. --host=SOURCE.HOST.HERE SOURCE_DB_NAME | mysql --user=USERHERE
  3. --password=PWHERE --host=TARGET.HOST.HERE -D TARGET_DB_NAME -C
  4. TARGET_DB_NAME

Report this snippet  

You need to login to post a comment.