I send a nightly dump of my production database to a development server. A script drops the existing development database and replaces it with the current production copy.
Each dev uses her own copy of the database. Is there a way to copy the current development database to a differently named db on the same machine, including the data, without using the sql dump?