How to Disable Statistic Data Collection in phpMyDirectory?


phpMyDirectory statistic data take a huge chunk of database space in MySQL. If you do not require the data, it is wise to disable the data collection as well.

To disable you have to edit the following file.

/includes/class_statistics.php

Find the following code

 if(BOT) {
 return false;
 }
 

and change it to

 if(true) {
 return false;
 }
 

Fix “#2006 – MySQL server has gone away” Error in phpMyAdmin


I’m importing 3.5MB csv file into the database. After file uploading completed, the following error came out.

#2006 - MySQL server has gone away

It is because MySQL server drop if there is too large packet. To fix the error follow the steps below.

1. SSH to your VPS / Server

2. Edit my MySQL file. Remember to backup your /etc/my.cnf prior to that.

vi /etc/my.cnf

3. Add or edit max_allowed_packet in the MySQL configuration file

max_allowed_packet=16M

4. Save MySQL configuration file

5. Restart mySQL

service mysql restart

If the error still persist you may try to increase the value & try again.


Page 30 of 53« First...1020...2829303132...4050...Last »