Tips Blog

Welcome to our technical tips blog – solutions and answers for numerous Joomla, Wordpress, Magento, Linux, MySQL and other problems.
 

How to dump all MySQL databases to reduce size of ibdata1 file

The /var/lib/mysql/ibdata1 file can grow gigantic, here is the procedure to reduce the size of it : 1) Dump all databases as one file mysqldump -u root -p –all-databases –routines –verbose –skip-lock-tables –result-file=alldb.sql 2) drop all databases 3) Stop MySQL,

read more

  • 20th Jul, 2018

Clearing Magento logs

To clean the Magento logs. The settings are under System > Configuration > Advanced > System > Log Cleaning. If it hasn’t been working, then you manually clean the logs. cd /var/www/website.com/httpdocs/shell display the size of the log files php

read more

  • 15th Jun, 2018

Magento 1.9 – Enable / Disable Symlinks

They’ve taken out enable/disable symlinks in Magento 1.9 for security reasons, but AOE Scheduler likes them, so if you really need to do it use : UPDATE core_config_data SET value = ‘0’ WHERE path = ‘dev/template/allow_symlink’;

  • 4th Apr, 2018

Make Postfix deliver all emails locally – no-external emails allowed

Install postfix, mailutils and mutt. apt-get install postfix apt-get install mailutils apt-get install mutt Stop Postfix /etc/init.d/postfix stop Create a Postfix “transport” file to redirect all emails : /etc/postfix/transport localhost:root www.YOURDOMAIN.com:root * local:root This routes all emails from all domains

read more

  • 23rd Jan, 2018

Renew Let’s Encrypt SSL Certificate

If using certbot – you have to manually renew the certificate using the command line. certbot-auto certonly –force-renew -d domain.com -d www.domain.com –webroot –webroot-path /var/www/vhosts/domain.com More info from here https://letsencrypt.org/  

  • 7th Nov, 2017