Maximum execution time of 360 seconds exceeded in C:\wamp\apps\phpmyadmin4.1.14

Question

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

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

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

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

Answer 1

You can try to use mysql console.

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

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.