在 phpmyadmin 中导出数据库失败(本地主机)

Exporting a database in phpmyadmin fails (localhost)(在 phpmyadmin 中导出数据库失败(本地主机))

问题描述

当我尝试在 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:

1. 打开CMD
2. 写cd C:wampinmysqlmysql15.5.8in
3. 然后写mysqldump -u root -p univercity student>H://TheNameOfStudents.sql

这篇关于在 phpmyadmin 中导出数据库失败(本地主机)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！