|
|||||||||||
|
|||||||||||
Transferring MySQL database to new server.
While transferring from one host to another you need to take many precautions, one of them is of your database (MySQL).
You should backup all your database files before it is transferred. You can do it so using two methods :
1) Using third party tool such as PhpMyAdmin.
2) Using ” dump” tool which comes bundled with MySQL.
Using PhpMyAdmin :
It is a PHP script which gives ability to interact you database.
To manage and manipulate MySQL databases use options under “export†section of PhpMyAdmin. Select the appropriate database and zip up the files it can save you bandwidth and time to download the backup file.
Now to transferring onto new server, first create a new database, unzip files and extract the backup then restore your database.
It also lets you mess up the database directly. There is no “undo” or “undelete” in your database. Always exercise caution when working with the database.
Most host have their control panel PhpMyAdmin pre-installed.
Using dump tool :
You have to use different commands at command line environment or UNIX shell environment.
Type command :
mysqldump -u [username] -p [password] –opt [databasename] > backup.sql
this command will take backup of your database.
Now on the new server, you can restore the database by inputting the following command:
mysql -u [username] -p [password]
The options in brackets need to be filled out with the appropriate information, such as, the username and password. It is also a good idea to take a “dump” of your database regularly for backup purposes in case the server fails or you have a corrupt database.
Database for any business plays a vital role so to preserve it you should take maximum precaution.
This can be done with .htaccess, visitors must input username and password before they can access the protected directory.
Step 1.
Create the file “.htaccess” with the following content under the directory you want to protect, you can specify the password in any place as long as Apache can access it.
AuthUserFile /home/account/passwd/.htpasswd
AuthGroupFile /dev/null
AuthName “Title”
AuthType Basic
require valid-user
Step 2.
Generate the password file “.htpasswd” under the directory /home/account/passwd/ with the following command:
# htpasswd -c .htpasswd user_name
You will be reminded to input password for the user “user_name”, this command can be called multi times to generate multi users.
Step 3.
This step may not be necessary. If there is an entry about the directory you want to protect in Apache configuration file, make sure AllowOverride has the option authconfig.
For example, when protecting Awstats pages, the Apache configuration file should be modified as following:
Options None
AllowOverride authconfig
Order allow,deny
Allow from all
Restart Apache
# /usr/local/sbin/apachectl restart
Some search engines do not record extremely common words in order to save valuable storage space or to help speed up site searches. These words are known as “stop words”
These are the words that are ignored if you search for them in combination with another word.
Few of them are : about, an, are, as, at, be, by, for, from, how, on, or, that, the, this, to, was, what, when, where, who, will, www etc.
Eg :- while searching for some photograph from iraq we would normally type photograph from iraq war in search query. The results obtained would be only based on the major two words photograph and iraq here the word from is not at all taken into consideration while searching.
Also search engines may include common terms such as ‘web’, ‘internet’, etc as their “ stop words .So while submitting your site to a particular search engine make sure your keywords are not falling under the list of “ stop words.
The easiest way to find out if a word you want to use will be ignored or not is to simply search for that single word in the engine you are submitting to.
What is -30 penelty Filter ?
There is a talk about a new filter from google which is popularly known as ” -30 filter ” basically it is an penalty filter which is responsible for lowering down of pagerank and even de-indexing of pages.
What happens when a site is filtered out for -30 penalty ?
The interesting thing is that the penalty is not a ban, but a bump down of 30 spots in serp So it’s nearly impossible to tell if you dropped because of a penalty, or due to some other reason.
Lot of people that ranked #1 now rank #31 and not only for their target keyword phrase, but also for their branded domainname.
Why Does Google apply this -30 Filter ?
When a site is found to be using some spamming techniques for improving ranking then Google may apply this filter for preventing spam.
If a site is connected in any of the following case then it is likely to be get penalized
*) If you try to get inbound links by spamming guestbooks and blogs then Google might apply the filter to your web site.
*) Using JavaScript redirects : JavaScript redirections might be misinterpreted as a spamming attempt and hence your site may get -30 penalty.
What after Google penalized you by -30 filter ?
The -30 filter seems to be an automated filter. If you remove the spam factors from your site then you’ll probably get your rankings back after some time. You can also send a reinclusion request to Google.
Websites having a lot of relevant inbound links are loved by the search engines. With the increase of local search, inbound links are a great way to help you get decent rankings in the search engines. The best thing about local links is that they are often free and we will see that.
a) A good place to start your link building is always the local directories. As compared to before there are now more community and regional directories from where you can choose. Look for your local directories and begin submitting as many provide free listings for related local businesses.
b) Everyone knows that .gov and .org based links have more value than the normal links so find out your local authority sites and try getting listed on their websites or link directories.
c) As you won’t be the only one having a website of your business in the area you can forge link relationship with other local businesses. Businesses with a good website and sound local focus will provide link value but relevant businesses are always the preferred link source.
d) By posting relevant comments on blogs is a fabulous way of getting links to your website but no spamming please. As well as you can start your own blog and others will link to you if they find the content attention-grabbing.
e) Getting some good PR from conventional mediums like newspaper, radio, etc much of the press generated will be replicated on their websites. If this occurs you will time and again get a back link to your site. Make sure any recipients of sponsorship or donations make available a link to you from their websites.
f) Community bulletin boards are generally regionally targeted and they can get a good relevant inbound link for your site. Always post comments or information which should be interesting and appealing to the visitors or your links will not be there for a long time.
g) Regional targeting is being provided by a host of review websites to their listings (i.e. tours guide) so submit your business for review and you will be happy to get the regionally relevant link which is provided.
Sometime a visitor may mistype the url, or click on a link which may be broken or not working due to certain reason, or try to access directories which they do not have permission to view then they are presented with a standard error page, this can make your visitor to feel that your site either does not exist or is somehow ‘broken’ which can lead to loose a precious visitor, though the error is totally different from what is presented.
To over this, you can now customize these standard error pages by using .htaccess file. You can build your error pages with logos and proper messages this will make your site seem much more professional in the unlikely event of an error.
You can creat your custom error pages for any error as long as you know its number. Custom error pages are just standard HTML pages
The general syntax for this is :
ErrorDocument errornumber /file.html
Following are the most common errors found :
401 – Authorization Required
400 – Bad request
403 – Forbidden
500 – Internal Server Error
404 – Wrong page
Now all you need to do is to create a customized file to display when the error occurs and upload it in the .htaccess file with proper message. This would be the perfect professional way for presenting error pages if occurred.
The main objective of presenting custom error pages is to keep users on your site and take them as rapidly as possible to the page they were trying to find.
No matter why you want to prevent spiders from crawling your site, there are two differents ways for doing so :
*) using robots.txt file
*) using META tags.
robots.txt file : While using robots.txt file you have more freedom for specifying from which spider and what content are not to be get crawled.
Create a text file using any text editor type in code and save it as robots.txt, so simple… Once the file is written upload it onto your server:
Use the following code for disallowing all spiders from indexing;
User-agent: *
Disallow: /
META tags :Sometimes you cannot make a /robots.txt file, because you don’t administer the entire server. All is not lost: there is a new standard for using HTML META tags to keep robots out of your documents.
The basic idea is that if you include a tag like:
in your HTML document, that document won’t be indexed.
And if you do:
the links in that document will not be parsed by the robot.
Ruby (Ruby on Rails) is a language of careful balance. Its creator,
Yukihiro at Matsumoto, blended parts of his favorite languages
(Perl,Smalltalk, Eiffel, Ada, and Lisp) to form a new language that
balanced functional programming with imperative programming.
It is a dynamic, open source programming language with a focus
on simplicity and productivity. It has an elegant syntax that is
natural to read and easy to write as well it has fantastic features.
The installation for Ruby goes as below.You need to perform this
installation on shell ::
1] cd /usr/local/src/
2] wget ftp.ruby-lang.org/pub/ruby/ruby-1.8.2.tar.gz
wget rubyforge.org/frs/download.php/3700/rubygems-0.8.11.tgz
wget fastcgi.com/dist/fcgi-2.4.0.tar.gz
wget fastcgi.com/dist/mod_fastcgi-2.4.2.tar.gz
Here the ruby version will change according to the latest release
at http://www.ruby-lang.org/en/ .Accordingly you will have to
download the compatible version of rubygems.You also need
fastcgi on the server for Ruby.So you must check the fastcgi
dependency of Ruby according to the Ruby version to be installed.
3] Untar the tar downloads one-by-one.
tar zxf ruby-1.8.2.tar.gz
tar zxf rubygems-0.8.11.tgz
tar zxf fcgi-2.4.0.tar.gz
tar zxf mod_fastcgi-2.4.2.tar.gz
4] cd ruby-1.8.2
./configure && make && make install
cd ..
5] cd rubygems-0.8.10
ruby setup.rb
cd ..
6] gem install rails
7] cd fcgi-2.4.0
./configure && make && make install
cd ..
8] cd mod_fastcgi-2.4.2
/usr/local/apache/bin/apxs -o mod_fastcgi.so -c *.c
/usr/local/apache/bin/apxs -i -a -n fastcgi mod_fastcgi.so
cd ..
9] mkdir /tmp/fcgi_ipc/
mkdir /tmp/fcgi_ipc/dynamic/
chmod -R 777 /tmp/fcgi_ipc/
cat > ~/httpd.conf
FastCgiIpcDir /tmp/fcgi_ipc/
AddHandler fastcgi-script .fcgi
FastCgiWrapper On
EOT
10] gem install fcgi
11] httpd restart
Here completes the installation.The further dependencies or
requirements for Ruby can be fulfilled accordingly after it’s trial/use.
