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

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 PhpMyAdminExport::getFilenameAndMimetype() must be of the type string, null given, called in C:xamppphpMyAdminexport.php on line 380 and defined in C:xamppphpMyAdminlibrariesclassesExport.php:270 Stack trace: #0 C:xamppphpMyAdminexport.php(380): PhpMyAdminExport->getFilenameAndMimetype(‘database’, ”, Object(PhpMyAdminPluginsExportExportSql), ”, NULL) #1 {main} thrown in C:xamppphpMyAdminlibrariesclassesExport.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!

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    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.


  2. 0

    This is what worked for me when I was exporting a table,

    1. While you export you will find Quick is selected,
    2. you need to select custom, then
    3. go to Output section and do the following
    4. select, save output to file
    5. on compression category, select zipped

    Then go on download your table as a zipped file.

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

Back To Top
Search