Well, the subject heading essentially says it all: what's the difference between a SQL Server database file (.mdf) and an actual SQL Server database? Also, a couple of follow-up questions:
Do database files exist for both SQL Server 2008 Express and SQL Server 2008 R2? Is there a difference between those if they do?
When uploading a site that has a db file, will it automatically hook up with the db running on the server? Would it need the db's connection string info?
MDF and LDFs are used by Express and full versions of SQL. Have a look here
Upload a MDF - no, in general a Database will need to be Specifically attached to the server or restored from backup, but the one exception is which can be attached in SQL Express via AttachDbFilename.
Express MDF's and LDF's can be attached in the full versions of SQL, although the reverse is not necessarily true - Express has limitations such a size limitation and features like Indexed Views aren't available in Express.