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.
