We don't use this to actually back up all of the tables, we have NetVault take care of that, but we do use this daily to dump a few tables we need for other applications. All the tables are MyISAM as far as I can tell and that makes it easier. In this case it is the model table from the reporting database in the mysql instance that srm uses.
mysqldump -u<un> -p<pw> reporting model It doesn't seem to cause any issue with anything or at least hasn't in at least 6 months. Regards, Sean Sean Carnes C&C Network Operations Center Cablevision Systems Corp. 172*85*77/5163905910 >>> <[email protected]> 10/28/09 2:51 PM >>> I think Sachin is asking for SRM-DB not SSDB or DDMDB. I am not aware of Scheduling in SRM-DB but users can Backup from Admin Tools --> Database Maintenance --> Backup Landscape. Other options available are Restore and Manage. It would be nice to know if scheduling can be done for SRM-DB, or perhaps a hack :-) Thank you - Ali From: Gaurav Partap [mailto:[email protected]] Sent: Wednesday, October 28, 2009 1:29 PM To: spectrum Subject: Re: [spectrum] Schedule Backup Of Report Manager Hi Sachin There are many options for database scheduling. First decide what kind of backup you want. There are two options: 1. Online Backup 2. Offline Backup There can be only SSdb backup. DDMdb backup or you can associate DDMdb backup with SSdb backup. It can be scheduled using the Spectrum Control panel. There are two command line utilities like SSDbsave/SSdbload and DDMdb_save/DDMdb_load/backup. If you want to associate DDMdb backup with SSdb backup, there is one script where you just need to uncomment one line. If you want backup using command line utilities, you have options of backing up full database, models only or catalogues only. In suzlon setup better use command line utility with DDMdb backup associated with SSdb backup. Use windows scheduler and take a models only backup daily and full backup weekly. Let me know if you have any queries. Regards: Gaurav Partap Behind an able man, there are always other able men******.(GAURAV PARTAP) On Fri, Oct 23, 2009 at 3:30 PM, CATools Helpdesk <[email protected]> wrote: Hi, How to schedule the backup of report manager in Spectrum. Thanks in advance. Thanks & Regards, Sachin Bhor --Disclaimer-- This email and any files transmitted with it are confidential and intended solely for the use of the entity to which they are addressed. If you have received this email in error please notify the sender immediately. Please note that any views presented in the email are solely those of the author and do not necessarily represent those of the organization. While all care has been taken to avoid viruses the recipient is advised to check this email and attachments for presence of viruses. The organization accepts no liability on this account. Mails may be stored for monitoring and review. --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] --To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] -------------------------------------------------------- The information transmitted in this email and any of its attachments is intended only for the person or entity to which it is addressed and may contain Cablevision proprietary information, which is privileged, confidential, or subject to copyright belonging to Cablevision. 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 and may be unlawful. If you received this in error, please contact the sender immediately and delete and destroy the communication and all of the attachments you have received and all copies thereof. -------------------------------------------------------- --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
