MySQL Forums :: Backup :: mysqldump for BLOB?, InnoDB log files?


Advanced Search

mysqldump for BLOB?, InnoDB log files?
Posted by: Amir Sidhu ()
Date: March 17, 2010 10:16AM

Hi,

I have 2 questions:

1. I know that we can take a logical backup of any database or table with the "mysqldump" utility. And I read in Mysql manual that this utility produces sql statements "Create Table" (for table creation), and "Insert Into ..." statements (for data insertion). Now my question is how it creates an insert statement for a BLOB column value?? since BLOB column has binary data, and it cannot be expressed as a text sql statement, so what does "mysqldump" do with these types of data??

2. My second question is about recovery. I know that mysql captures all the database changes in its binary logs, and that these binary logs are used in point-in-time-recovery and in replication. Then what is the purpose of InnoDB log files? what these files are used for? when we have every change in binary logs??

An early response would be greatly appreciated.

Thanks in advance.

Options: ReplyQuote


Subject Views Written By Posted
mysqldump for BLOB?, InnoDB log files? 2619 Amir Sidhu 03/17/2010 10:16AM
Re: mysqldump for BLOB?, InnoDB log files? 2051 Rick James 03/18/2010 08:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.