无法通过phpmyadmin文件体积过于庞大数据库中导入 [英] Can't import database through phpmyadmin file size too large

问题描述

我一直在试图通过phpmyadmin导入数据库。我的数据库文件是 a.sql ，它的尺寸为1.2 GB
我试图导入这个地方和phpMyAdmin是说：

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB I am trying to import this on local and phpMyAdmin is saying:

您可能尝试上传过大的文件。请参考文档的方式来解决此限制。

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

请帮助，我真的需要这个工作。

Please help I really need this to work.

推荐答案

它由于PHP是对上传的文件大小限制。

Its due to PHP that has a file size restriction for uploads.

如果您有终端/ shell访问则上述答案@Kyotoweb会工作。

If you have terminal/shell access then the above answers @Kyotoweb will work.

要完成它的一种方式是创建一个.htaccess / ini文件文件以更改PHP设置，以获得通过phpmyadmin上传的SQL文件。

one way to get it done is that you create an .htaccess/ini file file to change PHP settings to get the sql file uploaded through PHPmyAdmin.

php_value upload_max_filesize 120M //file size
php_value post_max_size 120M
php_value max_execution_time 200
php_value max_input_time 200

请注意，你应该上载后删除此文件。

Note you should remove this file after upload.

这篇关于无法通过phpmyadmin文件体积过于庞大数据库中导入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！