CODEWITHSUNDEEP
sqlphpmyadminexport
Mark King MCP
Mark King MCP

Reputation: 39

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

Upvotes: 3

Views: 795

Answers (3)

anoldermark
anoldermark

Reputation: 381

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.

Upvotes: 1

vsw
vsw

Reputation: 452

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.

Upvotes: 1

GMB
GMB

Reputation: 222462

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

Upvotes: 0

Related Questions