Hi. I'm trying to automate the updating of a database. This entails
creating the new database from scratch (which takes a long time), under a
different name, say mydb_tmp, and once this new database is ready, doing a
"hot swap", i.e. renaming the existing database to something like
mydb_20080613 and renaming the newly created database mydb.
I have automated everything up to the creation of mydb_tmp. (This is done
with an unholy mix of Perl and shell scripts.) I'm trying to figure out the
best way to perform the hot swap.
Any thoughts?
TIA!
Kynn