phpmyadmin Question posted in
The official documentation can be found here.

No SQL option on Export of a table in PHPMyAdmin

PHPMyAdmin is showing some strange results when I go to export a table as SQL. If I go to the main database and select Export (i.e. the whole database) at the top it works as expected but when I go to a table and try end export just that table, there is no SQL option in the select list on the “Format:” section.

enter image description here

I am using Server version: 5.5.62(MySQL) and phpmyadmin 4.8.4. This is server wide (happening on all db’s on this server)

There is a workaround, I can go to the main database level and export all and only tick the options of the tables I want but want to get this to work.

I have read about a max_input_vars setting but if this was the case, it would not export the whole DB, this just happens at a table level.

Thanks in advance

Tags:

3

Answers


  1. 0

    This is caused by a bug in version 4.8.4 of phpmyadmin. ppmyadmin team are working on it in this github issue.

    There seems to a workaround available (I did not test it myself) : if I select the db, then checkbox the table(s), exporting under “with selected” I get the SQL option.

    Login or Signup to reply.
  2. 0

    The fix does work, have applied it to many servers at this point.

    Fix # 14775 : edit 'Export.php'

    Resolution:

    Connect to the server via SSH.

    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%adminhtdocsdomainsdatabasesphpMyAdminlibrariesclassesDisplayExport.php.

    Find line /* Scan for plugins */

    Add the following above the line:

    // Export a single table
if (isset($_GET['single_table'])) {
    $GLOBALS['single_table'] = $_GET['single_table'];
}
    Login or Signup to reply.
  3. 0

    I am using xampp in ubuntu locally and I don’t have /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/classes/Display/Export.php file. SO I searched about this file and I found it here: /opt/lampp/phpmyadmin/libraries/classes/Display/Export.php
    After editing this file from the 

    // Export a single table
if (isset($_GET['single_table'])) {
$GLOBALS['single_table'] = $_GET['single_table'];
}

    (as the first answer) resolved my problem.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search