CODEWITHSUNDEEP
mysqlsqlddldml
user2728203
user2728203

Reputation:

How to get all the queries which we have used in a mysqldb

I have a mysql database with lots of tables and records in it. I want to get the list of queries which were used to create tables , insert records etc in that mysqldb. Is it possible. I have seen it in Oracle sql developer. If we click on the table we can view the queries which we have used, for DDL. How to do that in msyql. I am using mysql command line client.

Upvotes: 1

Views: 39

Answers (1)

Mikpa
Mikpa

Reputation: 1922

You could use the mysqldump-utility for that

In Linux:

mysqldump my_database_name >dumpfile.sql

Upvotes: 1

Related Questions