\u6709\u65f6\u5019\uff0c \u8981\u6279\u91cf\u6267\u884csql\u8bed\u53e5\uff0c \u600e\u4e48\u641e\u8d77\u5462\uff1f \u5728\u4e0d\u4f1ashell\u4e4b\u524d\uff0c \u6211\u8fd9\u4e48\u641e\uff1a \u5148\u5199\u4e00\u5927\u5806\u547d\u4ee4\uff0c \u4e00\u8d77\u590d\u5236\u5230mysq\u4e2dl\u6267\u884c\uff0c \u5475\u5475\u54d2\uff0c \u867d\u80fd\u7b11\u6389\u5927\u7259\uff0c \u4f46\u5076\u5c14\u4f1a\u6709\u7528\u3002 \u5f88\u4f4e\u7ea7\u3002\u4e0b\u9762\uff0c \u6211\u4eec\u4e00\u8d77\u6765\u770b\u770b\u6bd4\u8f83\u597d\u7684\u59ff\u52bf\u3002<\/p>\n
\u59ff\u52bf\u4e00\uff1a shell\u811a\u672c\u4e2d\u5199sql\u8bed\u53e5\uff0c \u8fd9\u662f\u6211\u4eec\u6700\u5bb9\u6613\u60f3\u5230\u7684<\/p>\n
\u6765\u770b\u770b\uff0c db.sh\u6587\u4ef6\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n
#! \/bin\/bash
\nhost=\"xxx\"
\nport=\"xxx\"
\nuserName=\"xxx\"
\npassword=\"xxx\"
\ndbname=\"xxx\"
\ndbset=\"--default-character-set=utf8 -A\"<\/p>\n
cmd=\"show tables\"<\/p>\n
mysql -h${host} -u${userName} -p${password} ${dbname} -P${port} -e \"${cmd}\"
\n\u6267\u884c.\/db.sh\uff0c \u83b7\u53d6\u5230\u4e86\u6b63\u786e\u7684\u7ed3\u679c\u3002 \u6ce8\u610f: cmd\u4e2d\u53ef\u4ee5\u5305\u542b\u591a\u6761\u547d\u4ee4<\/p>\n
#! \/bin\/bash
\nhost=\"xxx\"
\nport=\"xxx\"
\nuserName=\"xxx\"
\npassword=\"xxx\"
\ndbname=\"xxx\"
\ndbset=\"--default-character-set=utf8 -A\"<\/p>\n
cmd=\"show tables;
\nshow table;
\nshow table;\"<\/p>\n
mysql -h${host} -u${userName} -p${password} ${dbname} -P${port} -e \"${cmd}\"<\/p>\n
\u5f53\u7136\uff0c \u4f60\u4e5f\u53ef\u4ee5\u8fd9\u4e48\u641e\uff1a<\/p>\n
#! \/bin\/bash
\nhost=\"xxx\"
\nport=\"xxx\"
\nuserName=\"xxx\"
\npassword=\"xxx\"
\ndbname=\"xxx\"
\ndbset=\"--default-character-set=utf8 -A\"<\/p>\n
mysql -h${host} -u${userName} -p${password} ${dbname} -P${port} << EOF<\/p>\n
show tables;
\nshow tables;
\nshow tables;<\/p>\n
EOF
\n\u4e3a\u4e86\u4fdd\u9669\u8d77\u89c1\uff0c \u6839\u636e\u7ecf\u9a8c\uff0c \u7ecf\u5e38\u9700\u8981\u5728\u4e0a\u8ff0sql\u8bed\u53e5\u540e\u52a0\u4e0a exit;\u8bed\u53e5\uff0c \u786e\u4fddmysql\u9000\u51fa\u3002<\/p>\n
\u59ff\u52bf\u4e8c\uff1a \u5199sql\u6587\u4ef6\uff0c \u7136\u540e\u5728shell\u4e2d\u6267\u884c\uff0c test.sql\u6587\u4ef6\u5185\u5bb9\u4e3a\uff1a<\/p>\n
show tables;
\n\u6267\u884c\uff1a
\nmysql -hDbIP -uUserName -pPassword DbName -PDbPort --default-character-set=utf8 -A < \"test.sql\"
\n\u8bf7\u6ce8\u610f\u66ff\u6362\u8be5\u66ff\u6362\u7684\uff0c \u5982DbIP, UserName, Password, DbName, DbPort
\n\u8bd5\u4e86\u4e00\u4e0b\uff0c OK\u7684\uff0c \u7ed3\u679c\u7b26\u5408\u9884\u671f\u3002<\/p>\n
\u4e0a\u8ff0\u6267\u884c\u8bed\u53e5\u4e5f\u53ef\u4ee5\u6539\u4e3a\uff1a<\/p>\n
mysql -hDbIP -uUserName -pPassword DbName -PDbPort --default-character-set=utf8 -A -e \"source test.sql\"
\n\u4ea6\u53ef\u3002<\/p>\n