Saturday, January 15, 2022

[FIXED] phpMyAdmin gives export.php instead of database sql dump

Issue

Environment

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

Problem

When I try to export my database using Export tab, under my database page, It gives me the export.php file, the body part of which is 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 the .sql dump file!

My effort

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

Edit

Screenshot added, right before pressing Go button

enter image description here


Solution

I tried to use my browser's (Google Chrome 47.0.x.x) console to see If there is something wrong with it and I noticed this warning there:

Resource interpreted as Document but transferred with MIME type text/x-sql

Then I tried disable my browser's extensions one-by-one where I found this extension was the cause:

Free Download Manager Chrome extension (1.0.23)

I disabled it and now everything is fine.



Answered By - Pmpr
at

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.