Why has the latest phpmyadmin dropped sql as export format?

Question

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 export as CSV and then if I want to import, I need to drop the table first. Then, after I import the CSV, I need to rename the table and make sure it is uses the same collation as the original. This is whole lot more work then when I could use sql as it imported everything and without needing all the extra work.

Please can someone put sql back!!!

Thanks,

Mark King MCP

Answer 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.

Answer 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.