mysql迁往阿里云记录

• Posted on zydyh
• in linux
• on 5月 12, 2016
• No Comments.

原数据库上执行：/usr/local/webserver/mysql/bin/mysqldump –opt –default-character-set=utf8 –hex-blob search –skip-triggers > /tmp/xxxdb.sql
/usr/local/webserver/mysql/bin/mysqldump –opt –default-character-set=utf8 –hex-blob search -R | sed -e ‘s/DEFINER[ ]*=[ ]*[^*]*\*/\*/’ > /tmp/xxxdb.sql
密码：xxxxOo0YUzhZN7xxxx
mysql -uxxx -p -h’rdsxxx.mysql.rds.aliyuncs.com’ search < /tmp/tmp/xxxdb.sql