MySQL执行sql查询并上传至远程服务器
标签：
MySQL执行sql查询并上传至远程服务器
=‘your_db_address‘
db_port=3306
db_username=‘user‘
db_password=‘password‘
db_name=‘your_db_name‘
table_name=‘your_table_name‘
output_file=‘/tmp/output.txt‘
sql_stmt="USE ${db_name}; \
SELECT * FROM ${table_name}"
mysql -h $db_host -P $db_port -u $db_username --password=$db_password -e "$sql_stmt" -B > $output_file