Category: Debian

Change WordPress URL through functions.php file

Changing the WordPress URL can be done by editing the functions.php located in the theme folder, in most of the webservers the location will be as below /home/site/public_html/wp-content/themes/mytheme/functions.php Once you open the functions.php files add the below lines (replace the URL with the new one) immediately after <?php   update_option( ‘siteurl’, ‘https://www.newurl.net’ ); update_option( ‘home’, […]

Convert Existing MySQL Database to Innodb

  Converting existing MySQL Database Tables from MyISAM to InnoDB can be done from PHPMyAdmin but if there are too many tables the following script will help you to convert all the tables of a particular database to InnoDB Pre-requisites: 1. This tutorial assumes that you have .my.cnf configured with MySQL credentials for auto-login 2. […]

Setting Up MySQL Replication (Master-Slave) – PART 2

  Setting Up MySQL Replication (Master-Slave) – PART 2 My Environment : MySQL Server 01 – Master : 192.168.10.10 MySQL Server 02 – Slave : 192.168.10.11 DB To Replicate – hdada Things to Remember : 1. MySQL version should be the same on Master and Slave 2. During configuration of Replication once the DBDump is […]

Setting Up MySQL Replication (Master-Slave) – PART 1

  Setting Up MySQL Replication (Master-Slave) – PART 1 My Environment : MySQL Server 01 – Master : 192.168.10.10 MySQL Server 02 – Slave : 192.168.10.11 DB To Replicate – hdada Things to Remember : 1. MySQL version should be the same on Master and Slave 2. During configuration of Replication once the DBDump is […]

SSL Installation on Tomcat Server

  Generate CSR for Tomcat Server: 1. Generate the private key with the below command keytool -genkey -alias website -keyalg RSA -keysize 2048 -keystore example_com.jks -dname “CN=example.com,OU=IT, O=Example Pvt Ltd, L=Hyderabad, ST=Telangana, C=IN” 2. Generate the CSR using the below command keytool -certreq -alias website -file example_com.csr -keystore example_com.jks 3. Once the certificate is signed, […]

Using find command in Linux

Find is a very useful utility available in all the Linux server across all the variants, in this post let’s discuss some of the use cases of the command “find“. You are in a directory with thousands of files and you want to specifically search for “.png” and “.php” files. You can achieve this by […]

Generating a CSR for a domain

Let’s generate a CSR for the domain hostingdada.net using OpenSSL Login to your linux server as “root” via SSH through Putty On the prompt type the following command to generate a CSR  openssl req -new -newkey rsa:2048 -nodes -keyout hostingdada.net.key -out hostingdada.net.csr  Enter the required information to complete generating the CSR as below openssl req -new -newkey rsa:2048 -nodes -keyout hostingdada.net.key -out hostingdada.net.csr Generating […]

www.hostingdada.net © 2016