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

2022-01-05 00:00:00 database localhost php mysql 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

相关文章