Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin

PHPMyAdmin will not work for uploading large mysql databases. If you attempt to upload a large mysql dataset you will often get this error

Fatal error: Maximum execution time of 300 seconds exceeded

Here is the Fix

If you get this error you will need edit config.default.php inside phpmyadmin folder and look for this line

$cfg[’ExecTimeLimit’] = 300;

and replace with 0 or any larger value

$cfg[’ExecTimeLimit’] = 3600;

Phpmyadmin failed (Cpanel) Warning: session_start() [function.session-start]: SQLite

Phpmyadmin fails to load and gives the below error.

====
Error
====

Warning: session_start() [function.session-start]: SQLite: failed to open/create session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb’ – unable to open database: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86

Fatal error: session_start() [function.session-start]: Failed to initialize storage module: sqlite (path: /var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/session.inc.php on line 86
Read the rest of this entry »

PHPMyAdmin

cPanel comes readily available on most web hosting servers you will run across these days.  One of its many functions is allowing users to manage their databases; this includes creating, modifying and even deleting tables.  There are a few things you will not be able to do such as retrieving selective backups, having the ability to backup only certain tables in a database or execute queries….
Read the rest of this entry »