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?