Rename databases for backup

T

tjsingh

Member
Hi

How can i rename databases as i just want a backup of them if anything goes wrong when i dump and reload the data

regards

Tej
 
Why do you want to rename the database. as per your requirement simply backup the database and keep it at some different location.change the backup name anything else than your dbname(it doesnt make any diif) you can always restore it with the orignal dbname.

Arshad Taqvi
 
hi

what command do i use to do this?

its only 1 database so thought if something happens got it there rather than retrieving from tape backup.

cheers

tj
 
Really, a backup to disk is awfully easy and a very safe way to protect yourself in this kind of situation.
 
You must log in or register to reply here.
Back
Top