Method to Move Database – Files to New Server

My lot of clients faced this problem and recently I have been come across with multiple queries on my messenger that how to shift website’s Mysql database, as all databases have grown and if not grown they are still much to shift.

But as I always said there is a solution for every problem. So here is a simple solution to the issue.

The Solution
Whenever you are required to shift website to other server. First of all take the complete backup of the site or take the individual backups of the sections.

Like for example: If you have three sections in your site, then your home directory backup is the one that you have to take to copy all the files present in “public_html” folder (I am talking for Linux- Cpanel here).

Then you can take the individual backups of databases of the three sections that you have. The “Backup” option is available in the Cpanel.

Then, you are required to go to new server where you want to shift and again open the “Backup” option in new server’s Cpanel. There you will find upload option for uploading the home directory and databases.

Browse your “Backup” files which you have download from old server and stored in your computer.

shift-to-new-server.jpg

Its Not Over Till Now
This seems to be very easy and error free method to take backups and upload them. With this option you can upload as much big database as you want to upload.

But you will have to create the username and password for the databases, which you have uploaded to new server, as this is not done automatically.

Therefore the simple method you can apply to shift your site to other server. Without any issue of missing files and database not getting installed.

Easy Moneybookers Verification Method

I recently have opened moneybookers account but like paypal it isn’t showed unverified at any place, like in paypal you are shown unverified on the front page of your account. So, I was not sure how to deal with it. After reading some stuff available in the account of moneybookers I understood how to do it.

How to Verify
Unlike paypal if you want to verify your moneybookers account you don’t need to have credit card you can well do it with the bank account you have and for the address verification they do have the provision they send you the verification code to your mentioned postal address and you can write that code to verify the address.

It is not like that they don’t do credit card verification all the above-mentioned tasks would not be necessary if you do it with your credit card.

Easy Way to Go with Bank Verification
As in other similar payment processors you are charged for doing a verification from your credit card but in moneybookers you are paid for doing so, yes its true! You are paid for verification. The method is that you have to press the withdraw button and enter your bank “swift code” and then your bank account number and then you can withdraw some amount say $20.

Now, when the money reaches you bank account, in the transaction summary of the moneybookers slip, you get a 6-digit alphanumeric code, which you can use to verify your bank account. It’s very simple to do and it can be done with 3-4 working days.

Verification for Once
I was impressed by the way moneybookers wrote in the account that they do verification for once, and you are never ever asked for other verification methods or re-submission of verification documents.

moneybookers-verified.jpg

Don’t Know The Issue
Despite the benefits of easy verification I can’t figure out why the moneybookers is not so popular among users.

Also, I forgot to mention that their customer care has fast response time and they solve the query with pinpoint accuracy. I think if you have not opened a moneybookers account you should give a try to it. Verified

Programming Languages and SEO: Final Part – PHP

This is my final part of the 4 part series in which I was covering the topics about programming languages and how to do the seo for them. So this is the topic for the PHP developed pages and how to actually go about them.

PHP
Search engine crawlers being what they are — preprogrammed applications — there’s a limit to what they can index. PHP is another of those programming languages that fall outside the boundaries of normal web site coding. Search engine crawlers see PHP as another obstacle if it’s not properly executed.

Properly executed means that PHP needs to be used with search engines in mind. For example, PHP naturally stops or slows search engine crawlers. But with some attention and a solid understanding of PHP and SEO, it’s possible to code pages that work, even in PHP.

wiz_seoguy_01.jpg

PHP and SEO
One thing that works well with PHP is designing the code to look like HTML. It requires an experienced code jockey, but it can be done. And once the code has been disguised, the PHP site can be crawled and indexed so that it’s returned in search results.

In short if you are using PHP then try to fabricate your URL with the extension of .html and you can do this by just placing the .htaccess file in the folder. As this is the most trusted way to actually let the search engine crawlers believe that you are using .html pages and not PHP.

Hacker Protection for Your Account

Protecting your account from being hacked or useful information stolen is now being very difficult. Keeping in mind that hackers are implementing new methods to peep in your account.

Survey Results
A recent survey by FTC on identity theft, showed that 16 percent of victims who said their accounts were hacked or important information stolen by the people they knew, that is friends, relatives, coworkers, and neighbors.

Therefore is better to take precautions if we are working from home, office or café. The best idea is to disable the cookies and do not store your sensitive information on the computers that is off much importance to you.

Now, is there a way to find out who has actually been using your accounts to stole the information or just logging in to your account to see what you have stored.

protect.jpg

See Who is Seeing
The obvious answer is yes! Just follow the steps below and protect your account rather find out; who actually is peeping in your account to get the information.

Here’s how:

  • Open an account with OneStatFree.com, and use a disposable e-mail address to complete the registration process.
  • You’ll receive an email from OneStat with an attached file. Save the file, note the account number, and then delete the email.
  • Rename the file with a name that would catch a hacker’s eye like “AccountPasswords.” Save the .txt file as an .htm file so it opens up in a web browser.
  • Send an email with the .htm file to the account you want to monitor. Use a subject title that is eye catching.
  • Wait for the hacker to take the bait. If the attachment is opened by anyone else but you, the hit counter will record their IP address.

This is just another way to find out but rest depends on your and I would recommend keeping your password as difficult as you can, better precaution is better than cure.

vBulletin: Installing a Hack for vBulletin

Once you have found a hack, you have to install it. However, there’s no one single way to install a hack. In fact, there is almost as many ways of installing a hack as there are hacks!

Generally a hack consists of code and installation instructions. Instructions are generally quite clear and straight forward following the following format:

1. Open file xyz.php.
2. At line xx add the following code: …
3. Save the file and upload.
4. Open up template yyy.
5. Find the following code: …
6. Add the following code: …
7. Save the template.

These instructions are usually detailed, but it is recommended that you work through the instructions before making any actual changes to the files—this way, if there are any ambiguities in the instructions, you have a chance of spotting them first.

Be on the lookout for problems. If the instructions ask you to find some particular code or highlight a line of code that you cannot find, then first make sure that you are looking in the correct file. If you still cannot find the code, then there may be a problem somewhere. For example, you might have already made changes to that file, or perhaps a later version of vBulletin has removed the line referenced in the instructions. Either way, don’t make guesses at where the code should go, as this could be disastrous.

Check for an updated version of the hack, or get in touch with the author of the hack. (If you found the hack on a forum, this should be easy.) Installing a hack is easier if it contains an install script—you just upload the files to the appropriate location on the server (usually specified in the instructions) and then run the install script, which will make all the changes for you. When done, you normally delete the installation file to prevent it being rerun by some other, unauthorized person.

Don’t be lulled into a false sense of security by a hack that has an installation script—things can nonetheless go wrong, so make sure that you have an up-to-date backup of the forum and of the database just in case things don’t go according to plan.

After installation, test the hack thoroughly. Since each hack is different, it’s impossible to offer detailed advice on how to do this, but if you’ve installed a spellchecker, then test that it works; if you’ve installed a hack that makes moderating easier, then test this. Work methodically, and be on the lookout for problems. Don’t tolerate error messages—if you see any, find out what the problem is. Don’t ignore them—they will only get worse!