export saved MySQL query with database?

Question

I need to export my database, however when I done so and tested it by importing it again in do a different MySQL instance all my bookmarked queries were gone.

How do I export them with the database, so other people can run them by importing the database?

Is there another way?
I could just export each query as a table and have it as separate to the data base

You mean dump database or export query result? related questions:dump db and export query result — luoluo
– luoluo, Commented Aug 22, 2015 at 3:53
I can export the query results no issue, what I want to do is just export the single database with the bookmarked queries. — Ausghostdog
– Ausghostdog, Commented Aug 22, 2015 at 4:01
You mean using browser to share queries on tables with others? I don't think this is a good practice. Try write a simple script of the queries on the tables would be more convenient. — luoluo
– luoluo, Commented Aug 22, 2015 at 4:12

e4c5 · Accepted Answer · 2015-08-22 09:06:47Z

1

Bookmarked queries have nothing to do with the database. It's a feature of the client. For example that standard linux mysql CLI saves all executed querys to a file name .mysql_history. Like wise whatever client it is that you are using will have a place where this queries are saved, you just need to find it.

answered Aug 22, 2015 at 9:06

e4c5

53.9k11 gold badges110 silver badges139 bronze badges

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

Collectives™ on Stack Overflow

export saved MySQL query with database?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related