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.

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 »

Odds are, if you design Web sites with a database backend, you've worked with MySQL. You can manage this database from the command line, but it's not very user-friendly. Using the graphical tool phpMyAdmin helps, but not all Web hosting providers offer it or allow you to install it on the server. Fortunately, you can install it on your own box and manage several MySQL databases remotely at the same time, without having to install anything anywhere else.

Linux.com