mysql command line execution
Hi, Is there a secure way of running mysql commands against the db from the command line, or in some kind of secure batch mode, without making the password totally visible? We need to procedurize things like flush tables with read lock, unlock tables etc. Is making the password visible on the command line the only way? Thanks, Jeff -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB Netapp Snapshot
Hi, I need a procedure that will allow me to take an online (i.e. database up) Netapp Snapshot of a large InnoDB-based database. Could someone please confirm that this is a valid way of making a Snapshot: * Issue a flush tables with read lock; * Issue a flush logs; * Create the Snapshot * Issue an unlock tables; The reason I ask is that this list is the only place I can find reference to this procedure. Everywhere else talks about either mysqldump or the InnoDB Hot Backup utility for making online backups. Thanks in advance! Jeff -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Netapp Snapshot
Hi Dobromir, Thanks for the feedback. So you have successfully restored from a Snapshot created in this way? Jeff On Wed, 2005-07-27 at 12:30 +0300, Dobromir Velev wrote: Hi, -- Jeff Richards Consulting Architect Openwave Systems Asia Pacific +61 415 638757 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]