phpmyadmin

I'm currently working with a tech firm in Dallas on a Drupal setup. Their first so they don't completely know what they're doing. We finally got the install working so I went in to set me up as a user on the site. Clicked the Create New Account button, submitted my username and email address and never received an email confirmation with my password. Not good. I checked PHPmyAdmin and sure enough, my username is setup with an encrypted password but that doesn't help me since it's encrypted. How can I get my email confirmation.

I have been attempting to make a local version of a client's site for development. I was able to export a .gzip using phpmyadmin, but when I import it locally and compare to the live version, a lot of the tables are missing or are quite a bit smaller than the live version. A .zip export was only 4k so I assumed it was no good. The uncompressed database is around 117mb. I exported and downloaded it, and set the file size parameters in php.ini so that I don't get a "this database is too big" error.