Peyman Mohamadpour
Peyman Mohamadpour

Reputation: 17964

phpMyAdmin gives export.php instead of database sql dump

Environment

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

Edit

Screenshot added, right before pressing Go button

enter image description here

Upvotes: 11

Views: 17085

Answers (7)

Usman Yousaf
Usman Yousaf

Reputation: 203

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.

Upvotes: 2

Parag Jain
Parag Jain

Reputation: 355

I suppose you are running http://localhost/phpmyadmin/export.php on Google Chrome. Switch to some other browser (Ex: Microsoft Edge) and then run http://localhost/phpmyadmin/export.php. Now export the database as usual.

Upvotes: 1

Peyman Mohamadpour
Peyman Mohamadpour

Reputation: 17964

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.

Upvotes: 22

Asif
Asif

Reputation: 1

Hi select custom display option when exporting database and uncheck option

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

This will resolve the issue.

Upvotes: 0

Luca
Luca

Reputation: 31

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!

Upvotes: 3

nirdosh
nirdosh

Reputation: 3

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

I don't know your probblem will be solved or not but i solve by increasing Disk Space Usage

Upvotes: 0

jvb
jvb

Reputation: 61

  1. Check up "Settings"(from main menu),then "Export" tab. "Save as file" checkbox should be checked.
  2. When you setting up the export options, choose:
    • "Custom - display all possible options" radio button instead "Quick".
    • Set "Save output to file" radiobutton in "Output" section.
    • Set "Format" dropdown box to "SQL".

Then press "Go" button.

Upvotes: 1

Related Questions