phpMyAdmin: Export All Query Results
phpMyAdmin is an industry standard tool for creating and managing MySQL databases. It allows you to interact visually with the mysql databases and hide all the mysql operations behind it.
A common operation which phpMyAdmin allows, is to export the table results to the number of output formats like sql, excel, csv etc. And a common problem which most of the users face is to, export the results of the query which results in large dataset to sql or csv or excel etc.
A common solution which most of the forums suggest is to copy the query result to temporary table and then export the table. But many of you don’t know that it is also very easy to export large mysql query results without copying to temporary table.
Here are the simple steps of doing it.
1. Execute your sql query in the SQL tab of phpMyAdmin.
2. After execution, scroll down the page and look for “Query results operations” as shown in the screenshot.
3. Click “Export” link from the above and you will get the page to export all the results of the queries to desired format.