Hai Lakshmi, Backup I am yet to learn. transactional tables-limited knowledge- transaction safe tables are the ines in which you will be able to rollback the changes u made to the db since last commit or rollback.
to check is innodb is running(rather enabled), in linux u may use the command mysqladmin -h<host> -p[if passwd is reqd] variables | grep -iw innodb this should show a line "Innodb" "Enabled/Disabled" Eldo Skaria On Fri, 24 Sep 2004 20:13:56 +0530, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi, > Is there any way to handle backup in the mysql 4.0 classic with out > innoDB?. And may i know the differences between transaction - safe and transaction > -full locks ?. And what is the best way to confirm whether innodb is running or not > in mysql 4.0?. > > Thanks, > Narasimha > > -----Original Message----- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Fri 9/24/2004 2:41 PM > To: [EMAIL PROTECTED] > Cc: > Subject: Re: Which file to backup > > Luciano Barcaro <[EMAIL PROTECTED]> wrote: > > >>>I'm trying to backup the 'binary log' and don't know which file is it. > >>> > >>>these are the files I see in my datadir > >>> > >>>-rw-rw---- 1 mysql users 175K Sep 14 14:21 hrrgp01-bin.000007 > >>>-rw-rw---- 1 mysql users 345K Sep 14 15:03 hrrgp01-bin.000008 > >>>-rw-rw---- 1 mysql users 1.6M Sep 14 15:18 hrrgp01-bin.000009 > >>>-rw-rw---- 1 mysql users 3.9M Sep 15 09:06 hrrgp01-bin.000010 > >>>-rw-rw---- 1 mysql users 29K Sep 15 09:11 hrrgp01-bin.000011 > >>>-rw-rw---- 1 mysql users 676K Sep 15 15:58 hrrgp01-bin.000012 > >>>-rw-rw---- 1 mysql users 4.4M Sep 16 11:10 hrrgp01-bin.000016 > >>>-rw-rw---- 1 mysql mysql 322M Sep 16 11:10 ibdata1 > >>>-rw-rw---- 1 mysql users 40M Sep 16 11:10 ib_logfile0 > >>> > >>>The thing is I intend to stop the server at a certain time and then > >>>make a backup copy of the actual binary log. > >>> > >>>But which is the name of the file I should use into my script? > >>> > >>> > >> > >>Backup *-bin.* and ib_logfile* if you use InnoDB. > >> > >> > >> > >> > > And don?t forget ibdata1 > > The question was about logs. > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > Confidentiality Notice > > The information contained in this electronic message and any attachments to this > message are intended > for the exclusive use of the addressee(s) and may contain confidential or privileged > information. If > you are not the intended recipient, please notify the sender at Wipro or [EMAIL > PROTECTED] immediately > and destroy all copies of this message and any attachments. > -- Thanks & Regards, Eldo Skaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
