MyBackup with Innodb

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
amosqueda

MyBackup with Innodb

Post by amosqueda » Fri 15 Apr 2005 04:04

Use MyBackup to backup 3.5G how you say me, but, I have two problem with this aproximation:
1. With mode bmText: "File C:\ already exist" and fisically not exist this file.

2. Wit bmBinary: The handle for the table not sopport backup


Are two tables, one with 1 field blob with size of 200 kb each, Table are InnoDB.

Any Idea????

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 15 Apr 2005 11:08

In difference from TMyDump, TMyBackup presents a wrapper for SELECT ... INTO OUTFILE in the text mode and BACKUP TABLE ... in binary. Please see descriptions of these statements in MySQL Reference Manual.

Post Reply