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. […]
Category: Tutorials
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 […]
How to Add an Email Account in cPanel
To add an email account using cPanel follow these simple instructions. Log in to your cPanel account. Scroll down to the Email section. 3. Click the Email Accounts icon. 4. When the Email Accounts page opens, click on the + Create button on the right-hand side. This will open a new page where you can […]
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 […]
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 / […]
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 […]
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 […]
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 […]
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 […]
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 […]