mysql

Phpmyadmin is a great DB tool but can really suck on trying to import large DB files. Another much better option is to use bigdump.

Over at DrupalLab, they have written some easy step by step guide on using bigdump. Read more about Importing large DB file into mySQL

Anyone who has used a FTP program will know how cumbersome it can be to download or upload individual files. To save some time, here's an excellent tip on copying/archiving a whole site with FTP access, thanks to Khalid.

All that is required is to place a PHP script on your server and run the script via web browser. Read more about How to copy/archive a site with only FTP access