New subject: [Users] DB migration

21 Mar 2007

Thank you, Brad.
I missed MySQL RENAME DATABASE command. It is because the option appears
in MySQL starting from version 5.1 only and I have version 5.0.
It seems that for older MySQL  the following sequence will work:

openser_mysqldb.sh migrate openser openser12
mysqldump -u root -pxxxxx -c -t --ignore-table=openser12.version
openser12 > /tmp/openser12.bak
openser_mysqldb.sh reinit
echo "delete from subscriber;" | mysql -u openser -pxxxxx openser
echo "delete from admin_priveleges;" | mysql -u openser -pxxxxx openser
mysql -u openser -pxxxxx openser < /tmp/openser12.bak

Leonid

-----Original Message-----
From: Watkins, Bradley [mailto:Bradley.Watkins@compuware.com] 
Sent: Tuesday, March 20, 2007 7:23 PM
To: Leonid Fainshtein; users(a)openser.org
Subject: RE: [Users] DB migration

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(a)openser.org 
 [mailto:users-bounces@openser.org] On Behalf Of Leonid Fainshtein
 Sent: Tuesday, March 20, 2007 12:43 PM
 To: users(a)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(a)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. 

********************************************
This outgoing mail message was scanned by McAfee GroupShield Engine