Simple exporting of MySQL tables into a file

echo "select * from [table];" | mysql -u[user] -h[server] -p[password] [database] > [output_file]