Welcome to our technical tips blog – solutions and answers for numerous Joomla, Wordpress, Magento, Linux, MySQL and other problems.
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,
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
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’;
On machine1 (leopard) find folder1/media -print > leopard_media.txt On machine2 (panther) find folder1/media -print > panther_media.txt upload leopard_media.txt to panther, sort the files together, ready for uniq and tarring together. cat leopard_media.txt panther.txt | sort | sed ‘s/^M//g’ > both_media.txt
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
By default, in Magento, when an order is updated, an email is sent to the customer notifying them of the change. This even happens when the order is updated programmatically in PHP eg. if you create a shipment, such as
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/
You need to update mysql.user and set the Super_Priv flag. update mysql.user set Super_Priv=’Y’ WHERE user=’USERNAME’ AND host=’%’; update mysql.user set Super_Priv=’Y’ WHERE user=’USERNAME’ AND host=’localhost’;
Say you have a copy of a git repo, for example : cp -R /path/to-git-repo-folder /somefolder cd /somefolder If the files are different in your case, this will still work, just read the checkout step. Set up git for the
How to update a forked git repo on github – so it’s up-to-date with the original from where it was forked. In other words, how to re-sync your fork with the original – as is needed when updating the Magento