How to export part of a table as SQL in Adminer?

php mysql database export adminer
Mateng picture Mateng · Feb 5, 2013 · Viewed 13.3k times · Source

In Adminer, I can export whole tables with the "Export" menu option. When I enter a query, I can export the results as .CSV or .TSV, but not as SQL.

Is there any option to do so? A plugin or a config switch?

enter image description here

Answer

Jakub Vrána picture Jakub Vrána · Feb 6, 2013

Adminer doesn't offer SQL export of a general SQL query because the query may join more tables which would be impossible to export to SQL.

To export a subset of rows in a single table, go to the Select view of this table, filter the results as you wish and check the rows you want to export (or check 'whole result' to export all rows in the result). Then use the Export button under the table.

Related questions

How to export database with Adminer?

It's the first time i use ADMINER. I want to export the database and i'm not sure to set correctly the parameters. The database is in production and i don't want to make any mistakes. See screenshot : What are the …

Read More
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More
mysql server port number

I've just made a database on mysql on my server. I want to connect to this via my website using php. This is the contents of my connections file: $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $…

Read More