Backup the whole database

[Zsolt Csillag]

Hello,

I use MyDAC version: 4.40.0.24 and MySQL server version: 5.0.45

I would like to backup every day the whole database but I don't want the customer to be able to open the file with a text editor.

I first tried the TMyBackup. I use InnoDB tables and I got the following error message:
"The storage engine for the table does not support backup".

????

Then I tried TMyDump.
First I got an error message "Function MyStr does not exists".
It is funny because the MyStr exists but it is not a function as the TMyDump states, but a procedure!

Second: the other objects are stored in a text file. Should I compress with password on my own so as the customer wouldn't peep in?

Thank you in advance

[Antaeus]

"The storage engine for the table does not support backup".

TMyBackup uses the BACKUP TABLE command of MySQL in binary mode (TMyBackup.Mode = bmBinary). This command supports only the MyISAM storage engine.

First I got an error message "Function MyStr does not exists".
It is funny because the MyStr exists but it is not a function as the TMyDump states, but a procedure!

I could not reproduced the problem. Please send me a complete small sample at mydac*crlab*com to demonstrate it, including script to create server objects.

Second: the other objects are stored in a text file. Should I compress with password on my own so as the customer wouldn't peep

TMyDump does not support data encryption. You should implement it by yourself.