phpmyadmin导出数据库给出名称为sql的html文档错误 [英] phpmyadmin export database gives html document error with name sql
问题描述
当我从phpmyadmin导出数据库时，它给了我.sql html文档.我尝试了自定义导出和快速导出，也使用了chrome和mozilla浏览器.我正在使用Ubuntu 14.04.请帮忙.我整夜都在浪费时间.可能是它的系统问题或浏览器问题，因为我试图从本地计算机中的phpmyadmin以及服务器中导出数据库，但都出现了同样的问题.像这样的文件:
When I am exporting database from phpmyadmin it gives me .sql html document. I have tried from both custom and quick export and I have also used from chrome and mozilla browser. I am using Ubuntu 14.04. Please help. I have waste whole night on this. May be its a system problem or browser promblem because I have tried to export database from phpmyadmin which is in my local machine and also from server both is giving same problem. the document like :
<!DOCTYPE HTML>
<html lang='en' dir='ltr' class='firefox firefox39'>
<head>
<meta charset="utf-8" />
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="X-UA-Compatible" content="IE=Edge">
<style id="cfs-style">html{display: none;}</style>
<link rel="icon" href="favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.11.2.css" />
<link rel="stylesheet" type="text/css" href="js/codemirror/lib/codemirror.css?v=4.5.2" />
<link .........
推荐答案
除上述内容外，t 当mysql端口不正确时会发生他的错误.使用此命令:
In addition to above, this error occurs when the mysql port is not correct. Use this command:
mysqldump -u root -p --port=3307 DBNAME_inPHPMYADmin > database.sql from C:\xampp\mysql\bin folder
确保使用正确的端口.为我工作！ :)
Make sure correct port is used. Worked for me! :)
这篇关于phpmyadmin导出数据库给出名称为sql的html文档错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
