[Users] DB migration

Watkins, Bradley Bradley.Watkins at compuware.com
Tue Mar 20 18:22:54 CET 2007


In MySQL at least:  rename database <old name> <new name>

Once you've confirmed that the migration was successful, you can run a
backup of the old datbase, drop it, and then rename the new one.

- Brad 

> -----Original Message-----
> From: users-bounces at openser.org 
> [mailto:users-bounces at openser.org] On Behalf Of Leonid Fainshtein
> Sent: Tuesday, March 20, 2007 12:43 PM
> To: users at openser.org
> Subject: [Users] DB migration
> 
> Hi,
> I didn't understand the proposed process of MySQL DB migration from
> ver.1.1 to 1.2
> For example, the result of "openser_mysqldb.sh migrate 
> openser openser12" will be a new database openser12.
> But how can I copy/rename openser12 to openser? Does it mean 
> that from now, all of my auxiliary software must work with openser12?
> 
> Thank you,
> Leonid Fainshtein
> 
> 
> ********************************************
> This outgoing mail message was scanned by McAfee GroupShield Engine
> 
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
> 
> 
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. 




More information about the Users mailing list