How to Migrate the Database from MS SQL to MySQL?

ms-sql-to-mysqlThere are several companies that prefer migrating their database from MS SQL to MySQL. It becomes essential for enterprises to migrate to MySQL when there are few MS SQL server database around. There might be some other reasons as below that can be considered for migrating from MS SQL to My SQL –

  • MySQL supports numerous operating systems including Solaris, Linux distros and Mac which the MS SQL doesn’t support.
  • MS SQL server requires huge license and support fees while MySQL is less expensive.
  • Implementation of highly scalable database infrastructure.
  • MySQL database comes with several advanced features that have been tested intensively over years by a huge open source community.

You can migrate data from MS SQL to MySQL, by using “MySQL Workbench” utility. Installing MySQL Workbenchbecomes easy with the installation of “Oracle MySQL installer for windows” that includes installation of several MySQL tools along with Workbench.

read more

Posted in Dedicated Website Hosting | Comments Off

Creating multiple instances with OpenVPN

In this tutorial we will see how to create multiple instances on dedicated server with OpenVPN!

Depending on where you are, it happens that some ports are blocked or filtered. Rather than having each time to redo your configuration to adapt to the new port, it is easier to create a specific configuration port.

It should be noted that since the recent version of OpenVPN, the application will default launch all configurations found in the file “/ etc / openvpn” that is to say, all the files in “.conf “.

read more

Posted in Dedicated Server Hosting | Tagged | Comments Off

A Guide to Magento and WordPress Integration

Magento-WordPress-Integration

If you are an e-store owner, you might be finding it difficult to publish an audience-attractive content. No wonder product definitions/descriptions are a must but it isn’t essential if that sort of content will attract any loyal visitor. With Google becoming more sophisticated and social media becoming a dominant source of referrals, it is essential for the retailers of e-stores to gear up with content publishing, if they want to retain existing buyers as well as drive in new customers.

Magento can be utilized as blogging platform with some available add-ons but if one integrates a platform specifically for content publication then there are several advantages of it. Turning WordPress into an ecommerce store is surely possible but with Magento the retailer gets flexibility and functionality which is quite tough to be acquired on a platform designed for content management. The right way is to integrate the WordPress blog in your Magento store instead of installing WordPress separately, as the data you want requires synchronization. But both ways will be explained here.

read more

Posted in Web Hosting | Comments Off

How to control bandwidth in Linux?

easy-guide-to-bandwidth

Trickle and WonderShaper:

When we start working on a lot machines specifically Linux servers, it is interesting to know how we can control or limit the bandwidth. This can be useful in different contexts, for an instance, as part of a dedicated server or shared server infrastructure where we can control a download or app taking all traffic over other network users. It could very well put QoS or other technologies, but the tools that we are going to see in this post allow putting a limitation on the bandwidth which normally used pretty quickly and easily in Linux.

read more

Posted in Dedicated Server Hosting, FAQs | Tagged , , , , , | Comments Off

How Does R1Soft Backup Work?

The Internet is Internet and many things can happen so it’s good to have an off-site backup solution like R1Soft for data protection. bodHOST’s R1Soft system will enable you to restore files and folders to your account at barely a few clicks. The R1Soft console panel offered by us can help you to restore files, folders or even entire disk from Disk safe panel. Even, I would say R1Soft backup solution is the bee’s knees. Why I am saying this? Check the below steps and decide whether my claim is right or wrong!

read more

Posted in FAQs | Tagged , , , | Comments Off

Linux Server Security Audit with LBSA

linux_servers First of all we will see what LBSA is: The security of Linux system often requires regular testing with various settings and configurations that are also often common to several systems. For an instance, you have large Linux server farm on which you want to change the default port for the SSH service, it may be useful to have a tool that allows to quickly check whether the configuration has been made. This is where LBSA (Linux Security Audit Basic Script) can be used.

read more

Posted in Dedicated Server Hosting | Tagged , , , , , | Comments Off

SquirrelMail Time out issue

If you are using Squirrel mail and often encounter a disconnection problem with SquirrelMail interface, then you need understand that SquirrelMail session gets disconnected after a certain period of time. This usually happens around 10-15 minutes after logged into the interface without clicking on any buttons or not performing any actions.

read more

Posted in FAQs | Tagged , , , | Comments Off

Domain pointing to external MX on Plesk

If you are using external MX record and also using Linux environment for your Plesk server, then you need tweak settings in Plesk panel. To change the settings follow the below guidelines:

1 – You need to update the DNS for your domain name.
a) Change or Add MX record to establish external email server with significant priorities.
b) Remove the “CNAME” for mail.yourdomain.com if not to be used for configuration 
c) Or Edit “CNAME” for your domain that will point to external email server (generally provided by the email service provider).
d) Or Add “A” record for mail.yourdomain.com to point to external email server.

It will take some time to propagate the changes made in the DNS.

2 – Once the DNS is formed to use for external email server, it is essential
to de-activate the Mail service for the domain form the Plesk.

read more

Posted in Control Panels, FAQs | Tagged , , | Comments Off

How to optimize image online in Linux?

linux

Online image optimization in Linux:

Image compression may have an interest in many situations. For example, while writing a web article in which we need compressed images to reduce the total weight of a web page. Image compression may also need while sending an email. For this it is worthwhile to know how to do it quickly from command line. So here we will see how to lighten images in PNG, JPEG/JPG format with various tools.

read more

Posted in FAQs, Web Hosting | Tagged , | Comments Off

Hyper-V Free Monitoring Tool

Veeam Task Manager for Hyper-V is a monitoring utility for a Hyper-V host and its virtual machines. The objective of this free tool is to provide a task manager that lets you to view the use of resource in real-time, both for the host and VMs it contains.

It approaches the task manager to Windows, and in my opinion it is more appropriate that the information provided in the Hyper-V Manager.

What you should know before downloading Veeam Task Manager?

Before you begin, you should know that it needs to be installed on a client computer, the application requires operating systems > Windows 7, Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2.

read more

Posted in vps hosting | Tagged , , , , , , , | Comments Off