Why Has The Latest Phpmyadmin Dropped Sql As Export Format?

I am using phpmyadmin 4.8.4 and have tried to export one of my tables as backup. I noticed that sql has been dropped as an export file type. Why has this happened? I now have to

Solution 1:

They do have a fix out now...

Fix for 14775

Essentially:

1. Connect to the server via SSH.
2. Open file /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/classes/Display/Export.php with a text editor. Note: for Windows, it will be %plesk_dir%admin\htdocs\domains\databases\phpMyAdmin\libraries\classes\Display\Export.php.
3. Find line "/* Scan for plugins */"

4. Add the following above the line:

   // Export a single table

   if (isset($_GET['single_table'])) {
   
           $GLOBALS['single_table'] = $_GET['single_table'];
   
       }
   

5. Save the file.

More Reference.

Solution 2:

If you don't have access to the phpmyadmin install you can do a select on the table then at base of page in "Query results operations" click the little export icon.

Solution 3:

This is indeed a bug in the phpmyadmin 4.8.4. A github issue has been opened 5 days ago, and development team informed yesterday that a fix should be provided within a few days in version 4.8.4.1