方法一:通过PHPMyAdmin导入
修改两个文件: 1. 修改PHP.ini 下列项目的值: max_execution_time = 300 ; Maximum execution time of each script, in seconds (note: default was 30) memory_limit = 20M ; Maximum amount of memory a script may consume (note: default was 8M) upload_max_filesize = 20M (note: default was 2M)
2. 修改PHPMyAdmin的设置文件config.inc.php中的下面项目的值: $cfg['ExecTimeLimit'] = 0; // maximum execution time in seconds (0 for no limit) (note: 300 was default)
(注意:修改完上面的文件后要重起Apache使设置生效。本站测试时使用的软件版本: MySQL: 4.1.9 PHPMyAdmin: 2.6.0-pl3)
方法二: 把数据库文件上传到一个临时地方,然后用下面的SSH命令导入:
mysql -u dbusername -p databasename < /path/to/backupname.sql
也可以用这个命令:mysql db_name < backup-file.sql 或者这个: mysql -e "source /path-to-backup/backup-file.sql" db_name (注意文件格式是filename.sql, sql.gz在中文下会出错)
|