在C:\ wamp \ apps \ phpmyadmin4.1.14中，最大执行时间超过了360秒 [英] Maximum execution time of 360 seconds exceeded in C:\wamp\apps\phpmyadmin4.1.14

问题描述

我正在尝试从主机上备份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:\wamp\apps\phpmyadmin4.1.14\libraries\import.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:\wamp\bin>cd mysql
7. D:\wamp\bin\mysql>cd mysql15.1.36
8. D:\wamp\bin\mysql\mysql15.1.36>cd bin
9. D:\wamp\bin\mysql\mysql15.1.36\bin>mysql.exe -u root
10. use database
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:\wamp\bin>cd mysql
7. D:\wamp\bin\mysql>cd mysql15.1.36
8. D:\wamp\bin\mysql\mysql15.1.36>cd bin
9. D:\wamp\bin\mysql\mysql15.1.36\bin>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.

这篇关于在C:\ wamp \ apps \ phpmyadmin4.1.14中，最大执行时间超过了360秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！