问题描述
当我尝试在 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:wampinmysqlmysql15.5.8in
如果你的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:
- 打开CMD
- 写
cd C:wampinmysqlmysql15.5.8in - 然后写
mysqldump -u root -p univercity student>H://TheNameOfStudents.sql
这篇关于在 phpmyadmin 中导出数据库失败(本地主机)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！