Menu
Environment
C:\wamp\tmp\ folder for windows everyone group, and the folder is not read-onlyProblem
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<a href="./doc/html/faq.html#faqmissingparameters" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a><br /></p>
</body>
But, I expect the .sql dump file!
My effort
export.php: Missing parameter: export_type with no success.http://localhost/phpmyadmin/doc/html/faq.html#faqmissingparameters for any useful notes, with no success.config.inc.php, the $cfg['PmaAbsoluteUri'] directive is empty.php.ini the arg_separator.input directive has value ;&.Edit
Screenshot added, right before pressing Go button
420
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.
171
I had a similar issue on a CentOS Cloud Server with Magento CE installed. My selection was to Export all tables, SQL format, Save to Output File, Add "Drop Table..", Add "IF NOT EXISTS". Instead of dropping a .sql file, it always dropped a "sql" file without any extension and regardless any filename I was choosing. Inside that "sql" file there was the html source of the current phpmyadmin page! I solved the issue by uncommenting and increasing the variable "max_input_vars" inside php.ini to 3000 rather than 1000. Hope this helps!
25
I was trying to export my Magento database. And phpmyadmin instead of dropping a .sql file, retured a sql named file with no extension. Finally, I solved the problem by navigating to the php.ini file and uncommenting the "max_input_vars" variable and increasing its value. Don't forget to restart your xampp/wamp server after making the changes in php.ini.
2
Then press "Go" button.
1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
