Cloud Guru Online

We simplify everything!

MySQL temp directory full

In such situations, you will have to change the MySQL’s tmpdir.

  1. Create the new temp directory

mkdir /var/lib/mysql/tmp
chmod 1777 /var/lib/mysql/tmp

  1. Make the new folder as the tmpdir by adding the below to server’s /etc/my.cnf

tmpdir = /var/lib/mysql/tmp

  1. Restart mysql

service mysqld restart

Prestashop-Restoration issues

Whenever you had to restore a Prestashop website from backup, there are chances that you face the below error in the front end.

Fatal error: Uncaught Error: Class ‘Doctrine\Common\Cache\ArrayCache’ not found in /home/******/public_html/******/src/Adapter/ContainerBuilder.php:199

In such situations,

  • Install a fresh PS on a subfolder (make sure the version is almost close to the one you have now)
  • Rsync the following folders (or get those from
    • cache
    • classes/cache
    • vendor/doctrine/cache
    • vendor/psr/cache
  • Remove the cache files from var/cache/prod and var/cache/dev

WP CLI tips

Install WordPress CLI

As a root user, run below commands:

curl -O
chmod +x wp-cli.phar
mv wp-cli.phar /usr/local/bin/wp

Then log in as cPanel user and you can do the below tasks:

Create WordPress admin user

wp user create username email --role=administrator