I'm moving a local site to a subdomain -- actually I'm overwriting the site on the subdomain with the local site, the latter being a more developed iteration of the former.
When importing the database, I run in an sql 'table already exists error'. Obviously I have the wrong idea about this process -- I thought I simply could overwrite the existing database. I swear that's what I've done in the past.
What is the correct process? Obviously I don't want to create a new database each time I upload a new site version?