Nginx is a web server that focuses on performance and low memory usage. It is as of now one of the fastest growing web server. If you wish to learn how to install Nginx on your Ubuntu server, you can go through this tutorial . WPOven offers FREE Premium themes & plugins, Business emails, SSD, …
How to save MYSQL query result to a file ?
If you require to save the results of your MYSQL query to a CSV or Excel sheet, you can do so with the help of ‘INTO OUTFILE‘. This saves the query result as a ‘CSV’. You can open this CSV file in Excel and save it as a .XLS file as well. The syntax of …
Continue reading “How to save MYSQL query result to a file ?”
How to search or find a File / Folder on your Linux Server ?
To locate files or folders on your Linux server through command line or bash, you can use the ‘find‘ command. The syntax for the find command is as follows : find {dirctory_to_search} {search_by} {pattern_to_search} [action] For Example, if you wish to search a file called ‘filename.php’ by name on the entire server. fine / -name …
Continue reading “How to search or find a File / Folder on your Linux Server ?”
How to update to Ubuntu 14.04 LTS on Linux Server
Before upgrading it is always recommended that you create a backup first. Step 1 : Check the current version of Ubuntu uname -mrs lsb_release -a This should return an output in the following format : Linux 3.2.0-51-generic x86_64 No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 12.04.4 LTS Release: 12.04 Codename: precise Step …
Continue reading “How to update to Ubuntu 14.04 LTS on Linux Server”
How to setup GeoIP to track location of IP addresses
GeoIP is a PHP extension, which is used to get all the information like, city, state, country, longitude / latitude etc for any IP address. You can use this extension to track the visitors to your site. It can help you prepare better analytic for your user-base with the information collected. To install GeoIP, we …
Continue reading “How to setup GeoIP to track location of IP addresses”
How to disable or redirect the default WordPress login page (wp-login.php)
If you have a custom WordPress login form or you do not want anyone to access the default login form, due to security reasons or any other reason, you can set a redirect for the wp-login.php page. You could set a redirect simply in the .htaccess or the site’s Nginx config file, but this will …
Continue reading “How to disable or redirect the default WordPress login page (wp-login.php)”
How to force Nginx to redirect site name without-www to ‘www’
If you have a domain, ‘example.com’ and you want it to be available both when a user enters, ‘http://example.com’ and ‘http://www.example.com’, and you are running Nginx on your server, you can do so by updating the Nginx conf file for that Site. This file can usually be found in /etc/nginx/sites-available/ folder. Open the file and …
Continue reading “How to force Nginx to redirect site name without-www to ‘www’”
How to stop or kill a process running on your Linux Server
To find out the processes running on your server : ps aux This will show you the ‘PID’ of the process along with it’s other information. You can delete a process by using the ‘kill’ command with the process PID kill 16516 Sometimes you run into errors that require emergent steps like killing of certain …
Continue reading “How to stop or kill a process running on your Linux Server”
How to pass $_POST variables via PHP CURL
If you wish to pass PHP POST array variables without submitting a form, using the PHP Curl library to another URL, you first need to have a an Array which holds all the values for the POST array $post[‘lname’] = ‘Last name’; $post[‘fname’] = ‘First Name’ $post[‘mail’] = ‘example@mail.com’; Once we have the array set, …
Continue reading “How to pass $_POST variables via PHP CURL”
Redirect all HTTP requests to HTTPS for Nginx
To add redirect for all HTTP requests to HTTPS, we need to add Nginx Redirect rules to the nginx config file. The server block for http requests should look like : ## our http server at port 80 server { listen 1.2.3.4:80 default; server_name example.com www.example.com; ## redirect http to https ## rewrite ^ https://$server_name$request_uri? …
Continue reading “Redirect all HTTP requests to HTTPS for Nginx”