Mydump error

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Mydump error

Post by cybsistemas » Wed 15 Oct 2008 20:46

In the version 5.55.0.39 MyDump1.BackupToFile
They generate several lines For one sentence insert with TMemoField and
When executing MyDump1.RestoreFromFile Give error.
Example
http://www.matheucomputacion.com.ar/Example.sql

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Thu 16 Oct 2008 06:47

Thank you for detailed description. We will consider this problem and notify you when we fix it.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 31 Oct 2008 07:56

Please, specify what error does arise?

cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Post by cybsistemas » Fri 31 Oct 2008 12:29

When executing MyDump1.BackupToFile ('xxxx');

in the field Text (TmemoField) it is inserted one or several return carriage
(#13) as I show it in the example.

When executing MyDump1.RestoreFromFile ('xxxx') show message ERROR

This error in version 5.55.0.39 and 5.70.0.41

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 31 Oct 2008 14:15

I could not reproduce the problem. Really, the BackupToFile method returns different result in 5.55.0.37 and 5.55.0.39 versions. But in any case this query should be executed with the same result.
Please, give a more detailed description of the error and send me a script to create your table.

cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Post by cybsistemas » Fri 31 Oct 2008 15:33

CODE :

Procedure TForm2.Button1Click(Sender: TObject);
Begin
MyDump1.TableNames := 'Clientes';
MyDump1.BackupToFile('Backupxxx.sql');
End;

Look the 3 examples with wordpad

http://www.matheucomputacion.com.ar/example.zip

Executing
MyDump1.RestoreFromFile('Backupxxx.sql');
with 3 archives
Only the first one works (version 5.55.0.37)

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 03 Nov 2008 12:13

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Post Reply