Save MySQL query to a text file from shell

Question

I came across what I thought was a relatively simple problem, but haven't been able to find a solution. I wrote an extremely complex query in the MySQL shell and I'd like to save the query to a text file to use later and across systems (to use across redundant copies of the DB, and I unfortunately cannot copy paste).

Is there a simple way to do this, or will I have to manually retype the query into a text file?

Why can't you just copy/paste the sql text to a file like notepad? which shell you are using BTW? every shell has copy/paste feature. — Rahul
– Rahul, Commented Sep 11, 2015 at 19:53
I am using ubuntu server on a different macine than I'm on now. I'm logged into the mysql shell using mysql -u root -p — asdf
– asdf, Commented Sep 11, 2015 at 19:54
@Rahul I have a screen plugged into the server. So the host machine — asdf
– asdf, Commented Sep 11, 2015 at 19:56

Mureinik · Accepted Answer · 2015-09-11 19:54:53Z

2

Typing \e will open your default $EDITOR (usually vi or vim) with the last query you ran. You can then type : to input commands and save the file using w /path/to/myfile.sql.

answered Sep 11, 2015 at 19:54

Mureinik

316k54 gold badges401 silver badges405 bronze badges

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

3 Comments

asdf Over a year ago

Thank you, this is exactly what I was looking for

Bernd Buffen Over a year ago

You can also use a client on your mac or pc. they can connect via ssh tunnel if the database not direct reach. So its easyer to work. But the answer from Mureinik is also OK

asdf Over a year ago

@BerndBuffen I know you can, but I wanted a way to save it on the shell specifically

Collectives™ on Stack Overflow

Save MySQL query to a text file from shell

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related