CODEWITHSUNDEEP
phpmyadmin
shanep
shanep

Reputation: 55

How to export data from multiple tables in phpmyadmin

I am trying to query two tables and export data in csv format. When I click on export it only exports data from one table.

Eg: 

select table1.xyz,table2.abc from table1 join table2 on table1.pqr=table2.pqr

But only 1 table data is getting exported.

Upvotes: 3

Views: 6191

Answers (2)

Avatar
Avatar

Reputation: 15186

If you, for instance, want only tables with a certain prefix, you can filter the tables view in phpmyadmin:

phpmyadmin filter

Then you scroll down and hit "Check All" and then "With Selected" > "Export".

phpmyadmin export

Click "OK" and get your SQL file.

Upvotes: 3

PhoneixS
PhoneixS

Reputation: 11016

Are you clicking the right "export" link? I think you are clicking the "Export" tab that show you the export for the actual selected table.

The one you must click is the one below the result.

Upvotes: 1

Related Questions