MySQL Database migration

Recently in a hotel project, the outside network and do not let run data, can only run down the intranet. The data is then imported into the production environment. The amount of data is at the 100W level.

A simple command exports the specified database tables and then uploads them to the specified database server, which is imported into the specified database using command execution. The key is that during the day and do not let the operation of the production environment of the database, only midnight. Tangled Ah ...

1 command       u account  p password                               database name to      Export data table                               Export file        name 2 ---- Default-character-set=utf8 hotelbase_out hotelbase hotelimage hotelrela hotelroom > Hotelbase_out.sql 3        u account   p password  Import database  file 4--padmin  < 

Mysql Command

MySQL Database migration