ERROR 1046 (3D000) at line 1: No database selected

[ixqbar]

change with mysql_exec "show tables;"

try fixed
mysql --defaults-file=/dev/stdin "${opts}" -e "use ${mysql_database}; ${query}"