Starting with version 2.7.0, the import engine has been re–written and these problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features.
The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.
There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:
- Look at the $cfg['UploadDir'] feature. This allows one to upload a file to the server via scp, ftp, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory. More information is available in the Configuration section of this document.
- Using a utility (such as BigDump) to split the files before uploading. We cannot support this or any third party applications, but are aware of users having success with it.
- If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the "source" command from within MySQL: source filename.sql.
数据备份和恢复
默认的数据导出、和导入最大文件有2M的最大限制。如果要操作大于2M的数据库备份文件就需要预先将文件上传到phpmyadmin的某个目录。
1.首先在phpmyadmin个跟目录建立一个目录,比如叫ports
2.在config.default.php中搜$cfg['UploadDir'],这个变量定义保存导入文件存放的目录,它下面的$cfg['SaveDir']定义的是数据导出文件的存放目录,我们都定义为ports
$cfg['UploadDir'] = 'ports'; $cfg['SaveDir'] = 'ports';
|
要注意的是ports目录的权限,saveDir只要能让php脚本往里边写东西。最后的就是操作完了,务必清空改目录,防止数据被别有用心的人下载。
2.导入Excel数据到Mysql中