无法通过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.

如果您有终端/外壳访问权限，那么上述答案@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屋！