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@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@openser.org [mailto:users-bounces@openser.org] On Behalf Of Leonid Fainshtein Sent: Tuesday, March 20, 2007 12:43 PM To: users@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@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
Ah, yes, I hadn't thought about that. We're using (and have been using) MySQL Cluster 5.1 for awhile now, so I forgot to check if that was a new feature or not before I opened my big mouth. :)
- Brad
-----Original Message----- From: Leonid Fainshtein [mailto:LFAIN@ipgear.net] Sent: Wednesday, March 21, 2007 9:34 AM To: Watkins, Bradley; users@openser.org Subject: RE: [Users] DB migration
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@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@openser.org [mailto:users-bounces@openser.org] On Behalf Of Leonid Fainshtein Sent: Tuesday, March 20, 2007 12:43 PM To: users@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@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
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.
-
Leonid Fainshtein -
Watkins, Bradley