CODEWITHSUNDEEP
mysql
Ausghostdog
Ausghostdog

Reputation: 178

export saved MySQL query with database?

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

Upvotes: 0

Views: 159

Answers (1)

e4c5
e4c5

Reputation: 53774

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.

Upvotes: 1

Related Questions