在phpmyadmin中导出数据库失败(localhost) [英] Exporting a database in phpmyadmin fails (localhost)

问题描述

当我尝试在phpmyadmin中导出数据库sql文件时，它失败.我收到以下错误消息:由于PHP级别的执行时间很短，您的输出是不完整的."

When I try to export a database sql file in phpmyadmin it fails. I get the following error: "Your output is incomplete, due to a low execution time limit on PHP level" .

我不知道该怎么办.

推荐答案

我已经遇到了确切的问题.根据(windows，wamp，mysql)的评论，这是一种导出数据库/表的解决方案:

I experienced the exact problem already. According to comments (windows, wamp, mysql), here is a solution to get an export of your database/table(s):

打开CMD并将其粘贴:

Open CMD and paste this:

cd C:\wamp\bin\mysql\mysql15.5.8\bin

如果您的Windows已安装到C驱动器中，则在此行中应用您自己的信息并将其粘贴:

If your windows is installed into C drive, Then apply your own information in this line and paste it too:

mysqldump -u username -p databasename > filename.sql

注意:默认情况下，username是root.

您还可以确定一个特定的表，如下所示:

Also you can determine a particular table like following:

mysqldump -u username -p databasename tablename1 tablename2 > filename.sql

---

这里是一个例子:

---

Here is an example:

1. 打开CMD
2. 写cd C:\wamp\bin\mysql\mysql15.5.8\bin
3. 然后写mysqldump -u root -p univercity students > H://TheNameOfStudents.sql

1. Open CMD
2. write cd C:\wamp\bin\mysql\mysql15.5.8\bin
3. Then write mysqldump -u root -p univercity students > H://TheNameOfStudents.sql

这篇关于在phpmyadmin中导出数据库失败(localhost)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！