Search code examples
mysqlphpmyadminxampp

Can't export database from phpMyadmin on Xampp


I tried to export a WordPress database from Xampp's phpMyAdmin, but suddenly this error shows up:

Fatal error: Uncaught TypeError: Argument 5 passed to PhpMyAdmin\Export::getFilenameAndMimetype() must be of the type string, null given, called in C:\xampp\phpMyAdmin\export.php on line 380 and defined in C:\xampp\phpMyAdmin\libraries\classes\Export.php:270 Stack trace: #0 C:\xampp\phpMyAdmin\export.php(380): PhpMyAdmin\Export->getFilenameAndMimetype('database', '', Object(PhpMyAdmin\Plugins\Export\ExportSql), '', NULL) #1 {main} thrown in C:\xampp\phpMyAdmin\libraries\classes\Export.php on line 270

I tried cleaning the cache from the dev tools of the browser, but the issue hasn't been solved. Besides, as soon as I click on "Export", I see a message about one form having more than 1000 lines.

I successfully exported the database with the command line, following another solution found here at StackOverflow, but I need to deselect a couple of tables, which is why I'd rather use the "usual" way.

Thank you very much in advance!


Solution

  • This is what, in my case, solved the issue. Open the Xampp's php.ini file and paste the following at the bottom:

    max_input_vars = 5000
    suhosin.request.max_vars = 5000
    suhosin.post.max_vars = 5000
    

    Save the file and restart Apache from Xampp.