Re: How rename DATABASE .

Posted in 1999

Obnoxio The Clown — Mon, 15 Feb 1999 14:38:14 GMT — source: Informix-list mailing list archive (1991-1998)

>Hi, > >Does any one knows how I can rename DATABASE ? > informix 5.10 > >Thanks! Isn't there a RENAME DATABASE command? Or is that only in version 7? If it's an SE database, you should be able to just mv old.dbs new.dbs HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

KuKi — Mon, 15 Feb 1999 16:29:00 +0100 — source: Informix-list mailing list archive (1991-1998)

>> >>Does any one knows how I can rename DATABASE ? >> informix 5.10 >If it's an SE database, you should be able to just >mv old.dbs new.dbs ... and if you have an online one you can do this : 1) export your db (dbexport dbname) 2) rename the created .exp dir (mv dbname.exp newname.exp) 3) open the dir and rename the sql file (mv dbname.sql newname.sql) 4) open the sql (ASCII) file and change the name of the db to be created in the first line ("{ database dbname ....}" must become "{database newdbname....}") Bye. Andrea