Symptoms
Unable to export database via phpMyAdmin in Plesk:
Argument 5 passed to PhpMyAdminExport::getFilenameAndMimetype() must be of the type string, null given, called in /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/export.php on line 380
The following warning may be shown while accessing “Export” tab:
PLESK_WARN: Warning: a form on this page has more that 1000 fields. On submission, some of this fields might be ignored, due to PHP’s max_input_vars configuration.
Cause
phpMyAdmin issue: it does not allow processing huge amount of tables in database (more than 1000)
Resolution
For Linux:
Increase the memory_limit, max_input_vars parameters in Plesk PHP according to these instructions.
For Windows:
- Connect to the server via RDP
- Open C:Program Files (x86)Pleskadminconfphp.ini
- Find line like max_input_vars = <number> (add it if not present)
- Set <number> to a number larger than default of 1000, e.g. 1500 or 2000
If it does not help, submit this issue to phpMyAdmin bug tracker at https://github.com/phpmyadmin/phpmyadmin/issues/ as error on phpMyAdmin side is caused by the issue inside the phpMyAdmin code itself and use Plesk functionality to export Mysql databases affected by this issue as a workaround in Domains > example.com > Databases > Export Dump
