phpMyAdmin 上传超过2,048 KB的文件会出现如下提示:
“没有接收到要导入的数据。可能是文件名没有提交,也可能是文件大小超出 PHP 限制。”
此时可以通过修改在 phpmyadmin文件实现大文件上传
先在在 phpmyadmin目录里新建一个文件夹米命名为 upload
上传Sql数据库文件到此upload目录下
再修改phpmyadmin/libraries/目录下的config.default.php文件
打开这个文件找到以下内容
PHP
/*******************************************************************************
* Web server upload/save/import directories
*/
/**
* Directory for uploaded files that can be executed by phpMyAdmin.
* For example './upload'. Leave empty for no upload directory support.
* Use %u for username inclusion.
*
* @global string $cfg['UploadDir']
*/
$cfg['UploadDir'] = '';
1
2
3
4
5
6
7
8
9
10
11/*******************************************************************************
* Web server upload/save/import directories
*/
/**
* Directory for uploaded files that can be executed by phpMyAdmin.
* For example './upload'. Leave empty for no upload directory support.
* Use %u for username inclusion.
*
* @global string $cfg['UploadDir']
*/
$cfg['UploadDir']='';
修改$cfg['UploadDir'] = '';为$cfg['UploadDir'] = 'Upload';
进入phpMyAdmin导入页面中就会多出一项,“从网站服务器上传文件夹 Upload/ 中选择:”
在下拉框中选中你要导入的数据库文件,点击执行。