MySQL Forums
Forum List  »  Data Recovery

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


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

Written By
mysqldump for BLOB?, InnoDB log files?
March 17, 2010 10:28AM

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.