Hello Glen, You are not missing any step. Maybe the following remarks are a help for you.
You could drop the database without deleting its files (e.g. to keep your backup media) by unchecking "Delete database files." check box. Though you would need to delete the data volumes that are not longer needed manually. In step 3. you should use the "Restore Parameters from a backup" functionality of DBMGUI, if you want the parameters of the new database matching the parameters of your old database. In step 4. use the "Create instance for recovery" option of DBMGUI to avoid the common "Data and Log must be compatible" pitfall. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Case, Glen Sent: Donnerstag, 2. November 2006 21:08 To: maxdb@lists.mysql.com Subject: Rebuild database question. Our database size 105GB. We have various sizes of data volumes ranging from 256K to 8GB. I would like to rebuild the database with uniform data volumes like 8GB. Here are the following steps: 1. Cold complete backup. 2. Drop database. 3. Delete data and log volumes. 3. Create database with correct data and log volumes using DBM GUI Manager. 4. Import the complete backup into the new database. I'm planning on keeping the database id the same. Am I missing a step here ? Thanks, Glen _______________________________________________________________________ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________________________________ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
