dapurhosting.com Blog for Tech

October 14, 2011

Fatal error: Maximum execution time of 300 seconds exceeded

Filed under: cPanel/WHM,MySql — dh @ 5:06 am

http://www.helpdesksys.com/joomla-articles/27-maximum-execution-time-of-300-seconds.html

Fatal error: Maximum execution time of 300 seconds exceeded

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

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;

Normally it is located at “/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/config.default.php”,

Ref: http://24x7servermanagement.com/blog/?p=517

September 25, 2011

Install MYTOP

Filed under: MySql,Server,Stat — dh @ 2:38 pm

Donwload:
http://jeremy.zawodny.com/mysql/mytop/

Install:

tar -zxvf mytop-*
cd mytop-*
perl Makefile.PL
make
make test
make install
cd ..
rm -rf mytop-*

Fix MyTop Error

#mytop
Error in option spec: "long|!"

pico /usr/bin/mytop
Run a search for long|! and comment out the following line:
“long|!” => \$config{long_nums},

Here's the exact error from DBI. It might help you debug:

Unknown database 'test'

mysql
create database test;

April 9, 2011

A mysql user with the name already exists.

Filed under: cPanel/WHM,MySql — dh @ 5:18 am

Find and delete username from

/var/cpanel/databases/users.db

/var/cpanel/databases/

January 14, 2011

Fantastico: Acces denied for user

Filed under: Fantastico,MySql — dh @ 4:37 pm

Error pada saat instalasi Fantastico dengan pesan error

Warning: mysql_connect() [function.mysql-connect]: Acces denied for user 'user@localhost' (using password: YES) /tmp/cpanel_phpengine.xxxxxxx on line xxxxxxx
Access denied for user 'user@localhost' (using password: YES)

Masalah ini terjadi karena username kehilangan password MySql, jadi password database user tersebut harus diset. Caranya:

  1. Akses ke WHM > Change MySQL DB Owner Password
  2. Cari username yang bermasalah, ganti password MySQL dengan password cPanel.
« Newer Posts

Powered by WordPress