CODEWITHSUNDEEP
mysqlphpmyadmin
Keith Ivison
Keith Ivison

Reputation: 407

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

Upvotes: 8

Views: 5394

Answers (3)

vsw
vsw

Reputation: 452

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%admin\htdocs\domains\databases\phpMyAdmin\libraries\classes\Display\Export.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'];
}

Upvotes: 10

GMB
GMB

Reputation: 222462

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.

Upvotes: 6

Shan Chathusanda Jayathilaka
Shan Chathusanda Jayathilaka

Reputation: 426

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.

Upvotes: 2

Related Questions