This is a quick tip for anyone moving their Drupal site. I recently moved a development site to a live site and have done this on several occasions only to be left sitting their scratching my head wondering why only the home page of my Drupal site works. Each time after a few minutes it hits me that the .htaccess file is the culprit and that I did not move it. Often if you upload your files via some ftp programs you may not actually be able to see the .htaccess file to upload it. To see it on a Linux/UNIX box type ls -la and it will show up. FileZilla is an open source FTP program that will also do the trick.
So remember after you upload the files to your new server, import your database data and change your database credentials to also bring along your .htaccess file or just grab it from a Drupal package. Hope this saves some of you some head scratching.