Web Hosting Blog || SEO Blog

Usually the businesses starts their website hosting requirements with shared hosting plans, whether Linux or Windows, in order to cut down the initial costs. However, but shared hosting as it is cheaper than any other hosting type, it also offers less tools and features due to the reality that a single server resources is shared between thousands of websites dividing the processing power.

But if your website receives high volume of traffic (ie. Millions of hits per day) and databases is used heavily, probably you will have to move your website to the UK Dedicated Servers. In this business model you hire the rental of one or more servers directly from the hosting provider that manages the data center.

Unlike, the resources and processing power in shared hosting were divided among thousands of websites or customers will now be reserved exclusive and only for your website.

The dedicated hosting is offered in the form of monthly rentals and its value is directly corresponding to the desired server type and amount of Internet bandwidth required to meet the visitors to your website.

The servers are distinguished by their processor and the amount of memory, which decides their capacity and processing speed, respectively, and the available disk space for storing files.

In the hosting market, now there are commercially available servers with dual core, quad core and dual quad core processors to improve the server performances. The choice of optimum configuration for your server is directly related to the requirements of your website or web application you are going to host.

Another main advantage of the lease uk dedicated servers is that you can get a simpler setup and go up the processing capacity as your business requirements starts emerging.

Segnala presso:

While working on Mysql server many security experts’ recommend for changing passwords frequently to enhance security. It is nothing difficult to change the password of SQL Server Users, you can easily change the password on a SQL Server Username via Query Analyzer. Changing the password with Query Analyzer makes easy to synchronize change the password on the database server at the same time as it is changed in the connection string. This method provides the flexibility for changing the password at the most suitable time for the application.

To change the SQL Server Username password, just you need to connect to the database with “Query Analyzer” using the SQL Server Username which is going to be updated along with the current password and then run:

“sp_password” to change the password.
sp_password [ [ @old = ] ‘old_password’ , ]
{ [ @new =] ‘new_password’ }
[ , [ @loginame = ] ‘login’ ]
The Office Microsoft Documentation for sp_password
Here is a plain example that changes the current password from
“currentPSWD” to “newPSWD”;
sp_password ‘currentPSWD’, ‘newPSWD’

Make sure to use a strong password, (”newPSWD” as demonstrated above is just an example) and do a quick test to confirm that the new password is working, close Query Analyzer and then re-connect with the new password.

It is obvious, but still difficult to remember to change the password in your connection string if this SQL Username is used in your code. Once you’ve changed the password and confirmed after testing it with Query Analyzer, make sure to update the connection string with the new password and confirm that the whole thing working properly.

Segnala presso:

Mysqldump program can be used to dump the contents of a MySQL database and allow the transfer of a MySQL database and MySQL tables between different MySQL servers. The SQL statements can be redirected to a file however you should be sure that there is no activity going on while you process for this. Firewalls will not block the access to the MySQL database, A small PHP script which has to be copied to the webserver encapsulates and encrypts the access to the MySQL database.

The mysqldump program supports the following options;

-#, –debug=[options] Output debug information to log. Generally ‘d:t:o,filename`. See Appendix C for further details.
-?, –help Display usage information and exit.
-c, –compleat-insert Generate complete insert statements. (Don’t exclude values that conform to the column default.)
-h, –host=[hostname] Connect to hostname.
-d, –no-data Export only schema information. (Exclude data.)
-t, –no-create-info Export only data, exclude table creation information. (The opposite of -d.)
-p, –password=[password] The password to use when connecting to the web server. Note there can be no space between the -p and the password.
-q, –quick Don’t buffer query results, dump directly to STDOUT.
-u, –user=[username] Username for login. mysqldump will assume you wish to use your current login name if this option is excluded from the command line.
-v, –verbose Print verbose information about the various execution stages of mysqldump.
-P, –port=[port] The port to use when connecting to
-V, –version Output mysqldump version information and exit.

It also enable you to pipe the output of mysqldump to the MySQL client program to replicate a database but you should make sure-no updates are taking place while you’re doing this.

EXAMPLE:
mysqladmin create foo
mysqldump mysql | mysql foo

Hope this help!

Segnala presso:

Rasmus lerdorf created PHP which was designed to create dynamic web pages and it was created in 1995.PHP is computer scripting language and is now capable to include a command line interface.It can also be used in a standalone graphical application.It is released under the PHP licence and it can be installed on most of the web servers including most of the operating systems and platforms.Another plus point is it can be installed free of charge as it is a free open source software.Due to all these benefits PHP is very flexible and is a very good software to help you to build a website.As it is free and can be installed on most of the operating systems it is possible for you to install it on your dedicated server quite easily by the following steps :-

First step is to find the source codes and the following link will help you for this purpose.What you need to do is get the source codes for the PHP package and then you have to compile the package from scratch here, and, while there are also binary packages available for some distributions, I find your end results are usually better when building each package for your machine. Make sure you get the source files.The current version available is 5.2.6  :-

LINK: http://www.php.net/downloads.php
Current Version available – 5.2.6

So I hope that you have got the source codes.Now the installation begins…

The first thing you have to do for the installing PHP is to extract the sourcecodes so that you will be able to work with the files included in them.for this you will be working as root to Begin,for this you will have to open a terminal window and change to the directory in which you saved your downloaded files and become root by issuing the su command.After this enter the root password and you will be able to go.

Type the following command to get the source codes….

#tar -zxf php-5.2.6.tar.gz (enter)

The commands above will extract the sourcecodes into the directory.

Change into the PHP source directory as follows;

Compiling PHP :-

Once the prompt comes type the following command ;

#make (enter)

Wait for the time till you have the prompt.After getting the prompt you will have to give the following command ;

#make install (enter)

Once the install finishes and you have the prompt type the following command;

#cp php.ini-recommended /usr/local/php/lib/php.ini (enter)

Then edit the file;

#vi /usr/local/php/lib/php.ini (enter)

And edit the following;

Find the doc_root section and enter the correct path for the directory which serves your web content, such as ;

Then find the file_uploads section and change it to reflect the following;

file_uploads=Off

(for security reasons)

Now you have done it.

Testing –

You can check whether your work is done or not with the help of the following :-

Using vi create a file called test.php;

#vi test.php

Add the following line to the file;

<?php phpinfo(); ?>

Save the file, then fire up your browser and point it to localhost/test.php

I hope this has helped and you have sucessfully installed PHP on your dedicated server.

Segnala presso: