How to create the well known export as SQL in latest phpMyAdmin ? There is no choice for SQL anymore!
How to create the well known export as SQL in latest phpMyAdmin ? There is no choice for SQL anymore!
There is a bug in the latest version of phpmyadmin (4.8.4), where SQL export is not available anymore.
The problem has been raised to phpmyadmin team and they are working on providing a solution for this. You can follow the progress in this github issue.
An alternative way to export is through CLI:
mysqldump -u user -p database t1 t2 ... > exported.sql
export to SQL format not available for tables in 4.8.4 version.
I have completed this task by doing the following steps.
Go to C:\wamp\apps\phpmyadmin(YOUR_PHP_VERSION)\libraries\classes\Display (Path where you have install wamp server)
open Export.php
look for line /* Scan for plugins */ (near 662)
check if the following lines are set or not.
if (isset($_POST['single_table'])) {
$GLOBALS['single_table'] = $_POST['single_table'];
}
if (isset($_GET['single_table'])) {
$GLOBALS['single_table'] = $_GET['single_table'];
}
I was fetched the same issue, after applying the above solution I see sql option in the dropdown list. and successfully export table in sql format.