Re: mysqldump backup

2010-05-28 Thread Angelina Paul
lush-logs --master-data=2 > > /bk01/all_databases_`date +%a`.sql 2> /tmp/test.log > > i follow the above syntax for logging the errors in my script. > > Thanks > Anand > > On Fri, May 28, 2010 at 5:44 PM, Angelina Paul wrote: > >> Could you please inform me how

mysqldump backup

2010-05-28 Thread Angelina Paul
Could you please inform me how to test the mysql databases backup failure by using the mysqldump utility. I written a unix script for sending status notification against ten mysql databases. I need to test the nine databases backups have completed successfully and one failed due some reason. Than

mysql transaction log

2010-05-03 Thread Angelina Paul
Please help me to understand more about the mysql transaction log ( mysqlbinlog) file and its contents. Will it support only the innodb or all the storage engine types like MyISAM, InnoDB? Thanks, Arsh Paul

mysql-bin log file

2010-04-18 Thread Angelina Paul
How can I remove old mysql-bin log file in log directory? A mysql full backup will clear the old mysql bin log file or not? Thanks, Arshu Paul

InnoDB Default Storage Engine

2010-04-18 Thread Angelina Paul
I want to change the mysql default storage engine from MyISAM to InnoDB. What are the steps involved .Is it edit my.cnf file and add a line default-storage-engine=innodb and restart the mysql server? How I can bring my databases with mixed storage engine down without any data loss. What steps I ha