Akshay Jain

This is for those who want to change the priority or processor affinity of some process through Task Manager but they get an error message saying

The operation could not be completed.
Access is denied

This problem generally arises because some processes are run by the system and therefore Windows does not allow a “User” to change their priority.

A simple workaround is to run the Task manager by giving it System level access. (Thanks : Life in 0 and 1)

1. Open a ‘Command Prompt’ window by going to Start -> Run then type ‘cmd’ then press enter
2. Type “ntsd -c qd taskmgr” in the command prompt

So, I was importing a large database via PHPmyadmin to my server and as expected I got the irritating message

‘Maximum execution time of 300 seconds exceeded’

At first this seems like a Apache or a PHP timeout error, so I opened my httpd.config and php.ini files and increased the values for script timeouts, but unfortunately the error still continued.

The problem arises because PHPMYADMIN overrides the settings of the server and to resolve this error the configuration file to PhpMyAdmin needs to be edited.

So, look into

/var/www/html/phpMyAdmin-2.6.1/config.inc.php (for linux servers )
or
C:\wamp\apps\phpmyadmin2.11.6\config.inc.php (for windows servers)

NOTE: The paths can vary slightly depending on your configuration.

When you have opened that config file, there is a variable called

$cfg['ExecTimeLimit']

Just change this variable to 0 (for unlimited) or to a sufficiently large number.

Enjoy!

Hi guys

I am back from a vacation and currently not feeling like making any blog post. So, decided to just say “Hi”