Transfer database and tables from one server to another

Revision: 37152

at December 4, 2010 23:23 by bionic

Initial Code

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

Initial URL

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

Initial Description

Right at the bottom

Initial Title

Transfer database and tables from one server to another

Initial Tags

mysql, Bash, linux

Initial Language

Bash

Choose a language for easy browsing: