Geek Answers Handbook

PhpMyAdmin provides export.php instead of sql dump database

Wednesday

  • Wamp server 2.5 x64 (MySQL 5.6.17, phpmyadmin4.1.14) on Windows 10 Enterprise x64 (new installation, no significant changes since yesterday the full installation)
  • Full access to the C:\wamp\tmp\ folder for everyone of the Windows group, and the folder is not only read-only

problem

When I try to export my database using the " Export " tab, under my database page, it gives me the export.php file, whose body part looks like this:

 <body> <h1>phpMyAdmin - Error</h1> <p>export.php: Missing parameter: export_type&lt;a href="./doc/html/faq.html#faqmissingparameters" target="documentation"&gt;&lt;img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /&gt;&lt;/a&gt;<br /></p> </body>

But I expect a .sql dump .sql !

My efforts

  • I export.php: Missing parameter: export_type for export.php: Missing parameter: export_type unsuccessfully.
  • I also visited http://localhost/phpmyadmin/doc/html/faq.html#faqmissingparameters for any useful notes, but to no avail.
  • In config.inc.php directive $cfg['PmaAbsoluteUri'] empty.
  • In php.ini arg_separator.input has the arg_separator.input ;& directive.

edit

Added screenshot, right before clicking Go

enter image description here

+9
source share
8 answers

I tried using the browser console (Google Chrome 47.0.xx) to see that something was wrong with her, and I noticed this warning:

A resource interpreted as a Document, but passed with the MIME type text / x-sql

Then I tried disabling my browser extensions one by one, where I discovered that this extension was the reason:

 Free Download Manager Chrome extension (1.0.23)

I turned it off, and now everything is in order.

+18
source

I had a similar problem on a CentOS Cloud Server with Magento CE installed. My choice: Export all tables, SQL format, Save to output file, Add "Drop Table ..", Add "IF NOT EXISTING". Instead of dropping the .sql file, it always deleted the "sql" file without any extension and regardless of the name of the file I selected. Inside this "sql" file was the html source of the current phpmyadmin page! I solved the problem by uncommenting and increasing the variable "max_input_vars" inside php.ini to 3000, not 1000. Hope this helps!

+2
source

Suppose you use http: //localhost/phpmyadmin/export.php in Google Chrome. Switch to another browser (for example: Microsoft Edge), and then run http: //localhost/phpmyadmin/export.php . Now export the database as usual.

+2
source
  • Check "Settings" (from the main menu), then the "Export" tab. It is necessary to check the box "Save as file".
  • When configuring export options, select:
    • "Custom - display all possible parameters" instead of "Quick").
    • Select the "Save output to file" checkbox in the "Output" section.
    • Set the Format drop-down list to SQL.

Then click the Go button.

+1
source

I tried to export my Magento database. And phpmyadmin, instead of deleting the .sql file, restored the file named sql without extension. Finally, I solved the problem by going to the php.ini file and uncommenting the variable max_input_vars and increasing its value. Remember to restart your xampp / wamp server after making changes to php.ini.

+1
source

I have the same problem, but I solved it after increasing the Disk Space Usage website.

I don’t know if your problem will be solved or not, but I solve by increasing Disk Space Usage

0
source

Hi, select a custom display option when exporting the database and uncheck

 Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)

This will solve the problem.

0
source

Free Download Manager Chrome extension causes a problem

just disconnect it only from this site (do not catch downloads from this site), and life goes on ...

Fdm

0
source

More articles:


All Articles