How to Install Microsoft SQL Server Express 2014?

As a default service process many hosting providers install Microsoft SQL Server for you. But in some cases this may not happen or you may need to reinstall it for resolving some issues.  Example, if you see an error saying “SQL Server was not installed” then you may need to reinstall the MS SQL again. […]

Read More

How to import .csv files in the database from phpmyadmin

You have to remember a few things to successfully import .csv files in the database from phpmyadmin. Save your Excel file as a csv file. Please Do not save it as a workbook or any other format, check it with a text reader such as notepad or similar. You can see that each column is […]

Read More

How to edit your hosts file

Editing your hosts file overrides the DNS entries for any domain by resolving that domain to the IP address of your choice, this change only affects the computer you are making the change on which makes it very useful for testing websites, for example when performing a migration. Editing your hosts file on Window 8, 8.1 and 10 From […]

Read More

Exclude WordPress Directory/Folder from .htaccess RewriteRule

Sometimes the default WordPress rewrite rules might not work for permalinks. E.g. If you have other configurations declared in .htaccess files placed in sub-folders. You must edit the .htaccess and need to change the bold line below to omit the sub-folders from the WordPress rewrite rules. # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / […]

Read More

IIS: HTTP Error 404.3 – Not Found (Add a MIME Map)

You may get following HTTP error if you don’t have ASP feature installed in IIS 7/7.5/8/8.5 server. HTTP Error 404.3-Not Found The page you are requesting cannot be served because of the extension configuration. If the page is script, add a handler. If the file should be downloaded, add a MIME map. Causes It’s possible […]

Read More

How to Restore MS SQL Server Database Backup File

Follow the steps mentioned below to restore a database from a backup file. STEP 1: Open your MS SQL Server Management Studio and connect to your database. STEP 2: Select the database and Right-click >> Tasks >> Restore >> Database: STEP 3:  The “Restore Database” window will display. Select “From device” mentioned below the “Source […]

Read More

How to Backup an SQL Server Database using Management Studio

Follow the steps mentioned below to take a backup of SQL Server Database using Management Studio. STEP 1: Open your Microsoft SQL Server Management Studio, whichever you select, standard or express edition. STEP 2: Using your Database Username and Password, just login to your MS SQL server database. STEP 3: Select the database >> Right-click […]

Read More

Creating Custom Error Page in cPanel

Error page is a web page displayed when your website is non-functional. General errors are 400 (Bad request), 403 (Forbidden), 404 (Not Found), etc which has a pre-defined error message. Custom error message is where you change those pre-defined error messages and add a custom message or redirect it to a different website. Custom error […]

Read More

How to Create a New Admin Account in WordPress via MySQL

The following guidelines undertake that your WordPress database table prefix is set to “wp_“. If you work with something different table prefix, then change your code accordingly. For example, if you are using “wpsqltable_” in spite of “wp_“, after this the code “INSERT INTO ‘wp_users’” would change to “INSERT INTO ‘wpsqltable_users’“. Step 1: Log in […]

Read More