1. Using MyISAM rather than InnoDB MySQL has a number of database engines, but you’re most likely to encounter MyISAM and InnoDB. MyISAM is used by default. However, unless you’re creating a very simple or experimental database, it’s almost certainly the wrong choice! MyISAM doesn’t support foreign key constraints or transactions, which are essential for […]
Change the default database prefix (jos_) Use a SEF component Use the correct CHMOD for each folder and file. Password protect your administrative area. Use a .htaccess file to secure your Joomla. Passwords – Use a unique strong password. Install the jSecure Authentication plugin. Always Update all third party extensions to the latest versions. Remove […]
If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick. Go to mysql command:Set pager directive: mysql> pager mail -s “subject” emailme@domain.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]
