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.
Find the following code
and change it to
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.
3. Add or edit max_allowed_packet in the MySQL configuration file
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.