在 C:wampappsphpmyadmin4.1.14 中超过了最大执行时间 360 秒

2022-01-05 00:00:00 php mysql wordpress phpmyadmin wampserver

我正在尝试从主机备份 wordpress 网站并将其移回我的本地主机上并将其保留为重建样本.如果有任何解决方法或其他方法,我全神贯注

Im trying to backup a wordpress website from host and move it back on my local host and keep it as a sample for rebuilding. If have any workaround or maybe other methods I`m all ears

我也备份了我的网站和数据库,但是当我尝试导入"我的 sql 数据库时,我总是收到错误致命错误:

I backedup my website and database also, but when I`m trying to "Import" my sql database I always get the fallowing error Fatal error: Maximum execution time of 360 seconds exceeded in

C:wampappsphpmyadmin4.1.14librariesimport.lib.php on line 345

数据库有点大 203MB,我将它存档 aiesecbu_achieve.sql.zip 55.8 MB

The database is kind of big 203MB and I archived it aiesecbu_achieve.sql.zip 55.8 MB

我可以说我已经试过了:致命错误:超出最大执行次数并修改我的 php.ini

I can say that I`ve already tried this: Fatal error: Maximum execution exceeded and modifying my php.ini

post_max_size = 400M
upload_max_filesize = 250M
memory_limit = 128M

如果你想的话,我已经上传了我的数据库供你测试(也许它有问题)和截图

I have uploaded my database for you to test it if you want(maybe it`s something wrong with it) and a screenshot

https://www.dropbox.com/s/cx9wava7sptf4km/mysql.jpg?dl=0

推荐答案

可以尝试使用mysql控制台.

You can try to use mysql console.

  1. 运行cmd命令
  2. 在命令提示符下键入 c:d:.这将基于您的 WAMP 服务器安装.
  3. 假设您已经在 D: 驱动器上安装了 wamp.
  4. D:>cd wamp
  5. D:wamp>cd bin
  6. D:wampin>cd mysql
  7. D:wampinmysql>cd mysql15.1.36
  8. D:wampinmysqlmysql15.1.36>cd bin
  9. D:wampinmysqlmysql15.1.36in>mysql.exe -u root
  10. 使用数据库
  11. source source.sql
  1. Run cmd command
  2. Type c: or d: on command prompt. This will be based on your WAMP server installations.
  3. Assuming you have installed wamp on D: drive.
  4. D:>cd wamp
  5. D:wamp>cd bin
  6. D:wampin>cd mysql
  7. D:wampinmysql>cd mysql15.1.36
  8. D:wampinmysqlmysql15.1.36>cd bin
  9. D:wampinmysqlmysql15.1.36in>mysql.exe -u root
  10. use database
  11. source source.sql

基本上你登录mysql,use database决定你想使用哪个数据库,source/source/to/source.sql决定你想运行哪个sql.非常简单高效.

Bassicaly you login into mysql, use database determines which database you want to use, source /source/to/source.sql determines which sql you want to run. Pretty easy and efficient.

相关文章