Starting on October 19, 2021, we will enable single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
To be prepared for this change and to avoid the need to register during your next ticket submission after the change, we encourage you to create an account here before October 19 using the same email address as your current Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account. You will continue to use ZenDesk authentication until we switch over to single-sign-on on October 19th.

Articles in this section

See more

Unable to export database via phpMyAdmin in Plesk: Argument 5 passed to PhpMyAdmin\Export::getFilenameAndMimetype() must be of the type string, null given

Avatar
Yulia Plokhotnikova
Updated
Follow
Plesk for Windows Plesk for Linux kb: technical

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Symptoms

Unable to export database via phpMyAdmin in Plesk:

CONFIG_TEXT: Argument 5 passed to PhpMyAdmin\Export::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:
  1. Connect to the server via RDP
  2. Open C:\Program Files (x86)\Plesk\admin\conf\php.ini
  3. Find line like max_input_vars = <number> (add it if not present)
  4. 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 

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles