Menu
I want import huge (at least 300 mb) sql scripts via phpMyAdmin.
I've tried:
post_max_size = 750M upload_max_filesize = 750M max_execution_time = 300 max_input_time = 540 memory_limit = 1000M in my php.ini file, but I'm still getting timeout errors during importing.
696
If the import is to be done via cPanel provided PHPMyAdmin itself, then we need to increase the timeout. To do so, go to, WHM >> Tweak Settings >> cPanel PHP max execution time.
Your answer Look for : $cfg['ExecTimeLimit'] = 600; You can change '600' to any higher value, like '6000'. Maximum execution time in seconds is (0 for no limit). This will fix your error.
Ok you use PHPMyAdmin but sometimes the best way is through terminal: Connect to database: mysql -h localhost -u root -p (switch root and localhost for user and database location) Start import from dump: \. /path/to/your/file. sql.
If even after repeated upload you still get timeout error, pleasechange your settings in
\phpmyadmin\libraries\config.default.php
from $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0; and restart. Now there is no execution time limit (trust we are talking about local server).
Source : Change Script time out in phpmyadmin
120
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
