Extracting and creating archive files
Sometimes you would need to extract or create an archive file (i.e to install a script, you would usually download an archive and extract it to continue the installation). The…
SSH Commands
Login to SSH using terminal Extract a tar.bz2 file Backing up Database: The command for backing up your database is the following: Type the above command in your command line…
Cron Job: Delete Files & Directories Older Than x Days or Minutes on Linux
The find utility on linux allows you to pass in a bunch of interesting arguments, including one to execute another command on each file. We’ll use this in order to…
Cron Job: to backup database
Where USERNAME -> Database username PASSWORD -> Database password DATABASENAME -> Database name Note: Don't remove "-p" let say that your database name is "mydatabase" and password is "1234abcd" and…
Allow your IP only to access a site
add this code on your .htaccess file where xxx.xxx.xxx.xxx is your ip address
Change default directory page
Most probably you have been wondering how the Webserver decides which page from your site to use as a main/default page of your site. There is a directive named DirectoryIndex…
Prevent Script Execution
You can disable scripts being run in the directory of your choice by adding the following code to your .htaccess file in that directory: You can replace the file types…
Convert mysql Database to utf8
If you want to convert a database to UTF8 you can use this script Phoca Changing Collation Tool Download link http://www.phoca.cz/download/category/17-phoca-changing-collation-tool VIN: any arabic data will be lose.
Joomla: Moving sensitive files outside the web root for Joomla
This example for Joomla.
One challenge in Joomla! is ensuring that certain PHP files in public_html (or otherwise known as httpdocs or www depending on your server setup) containing executable code or confidential data are protected from direct Internet access.
(more…)