How to export a query in mysql to a .sql file?

Question

I want to save the query I wrote in mysql console to a .sql file... for example :

"CREATE TABLE Employee(id...,name...,salary);"

I want to save the code instead of it's result. thanks

How are you executing this query? On the terminal, through a shell script... How? — Yusuf Hassan
– Yusuf Hassan, Commented Dec 26, 2017 at 4:26

Yusuf Hassan · Accepted Answer · 2017-12-26 04:48:40Z

0

Pass the query in a variable and then execute it. This way, variable will hold the query and you'll be able to do whatever you want:

query="CREATE TABLE Employee(id...,name...,salary)";

mysql -u root -h localhost -P 3306 -p -e "$query"

echo $query >> query.sql

This'll print the data as well as populate a file query.sql in your PWD. The above example is a part of a shell script.

answered Dec 26, 2017 at 4:40

Yusuf Hassan

2,0131 gold badge14 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

I just want to have .sql file that's written in it ,say,"CREATE DATABASE Company;"

But I want to save this file using the mysql console environment

Happy to help :) Please accept/upvote it if it serves what you were looking for.

To avoid printing anything, simply skip the execution part i.e. mysql -u root -h localhost -P 3306 -p -e ""