mysql

# Connect to a database:
$ mysql database_name

# Connect to a database, user will be prompted for a password:
$ mysql -u user --password database_name

# Connect to a database on another host:
$ mysql -h database_host database_name

# Connect to a database through a Unix socket:
$ mysql --socket path/to/socket.sock

# Execute SQL statements in a script file (batch file):
$ mysql -e "source filename.sql" database_name

# Restore a database from a backup created with `mysqldump` (user will be prompted for a password):
$ mysql --user user --password database_name < path/to/backup.sql

# Restore all databases from a backup (user will be prompted for a password):
$ mysql --user user --password < path/to/backup.sql

# 跨库复制表格
$ mysqldump --opt --host=<DB_HOST> --port=<DB_PORT> --user=<DB_USER> \
    --password=<DB_PASSWD> <DB> <TABLE> | mysql -h <DB_HOST> -P <DB_PORT> \
    -u <DB_USER> -p'<DB_PASSWD>' -D <DB>