MyBB Community Forums

Full Version: Can you help me
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
So now I got a fresh forum, but I also have my sql.gz database backup that I wanna reinstall into my forum.
How do I do that?

I always get this error :
''Fatal error: Maximum execution time of 10 seconds exceeded in /home/mainhost/public_html/phpMyAdmin/libraries/sqlparser.lib.php on line 334''

What should I do? Is there any easier way? Thank you!
This is related to your PHP Settings. Basically, it takes the script too long to import the database. 
To fix that, you can increase the max execution time. 

To do that you need to edit your php.ini file. 
Ill take a standard Ubuntu server with PHP 7.0 as example: 

The path to the file is /etc/php/7.0/fpm/php.ini

So open up this file in nano from bash: 

sudo nano /etc/php/7.0/fpm/php.ini

Then search for the line max_execution_time (you can do that by pressing CTRL + W)

Once you found it, change its value to something like 600.

When that's done, save (CTRL + O, then enter) and exit (CTRL + X).

Now just restart PHP by typing

sudo service php7.0-fpm restart

Then try to import your SQL Database again.

---

Note: If you do not have SSH access to the server, ask your hoster to increase the max_execution_time of PHP.