Devart Forums

Hello,

Using TmyDump, I save my whole DB. It works fine & the saved text file is perfect.

BUT ... on restoring then same DB, using the formerly generated text file loaded into the SQL stringlist of a TmyDump, the restore operation is blocked whenever it encounters a semicolon (";") within a string to be inserted to a varchar field.

MySQL specifies a limited number of escape sequences for given special characters, as "\" for the single quote.

I tried replacing the semicolons with "\;", but the backslash is simply ignored.

Does anyone have an idea of any work around ? as, for instance, a means to enable a character by replacing it with its ASCII code (syntax within a string ???)

Any clue ?
Is this a real bug ?
Does upgrading from 4.40 to 5.xx solve the issue ?

Thanks in advance for any help.

We could not reproduce the problem.
Please send a complete small sample to dmitryg*crlab*com to demonstrate it, including a script to create and fill table.

I have encounter same problem and some more with TMyDump.

I am using
Delphi 7
MySQL 5.0 latest version
MySQL DAC Professional 5.30.0.36

The table and data when I encounter this error is :

CREATE TABLE `config` (
`KeyData` varchar(255) default NULL,
`ValueData` varchar(100) default NULL,
`Category` varchar(100) default NULL,
`ID` int(11) NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO `config` VALUES ('KioskManager.shutdownTime', '22;00', NULL, 0);

There is another error saying invalid default value in the following table

CREATE TABLE `appparam` (
`tag` varchar(100) NOT NULL default '',
`val` varchar(100) NOT NULL default '',
`modified_by` varchar(50) NOT NULL default '',
`lud` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

They work well when I run the dump file in MySQL browser but it didnt work when I use TMyDUMP.restore.

Another issue which is not bug but not logical is that when I doDatabase in Objects but not select AddDrop, the dump file will create the database but NOT SELECT IT. It will make the following create/update either pop error of no database selected or restored to the current database which is not desirable. If you have to create a database, I think that tables should restore to THAT database.

If you need my developer license number to follow this issue, I can email to you.

Thanks in advance.

Justmade wrote:I have encounter same problem and some more with TMyDump.

I am using
Delphi 7
MySQL 5.0 latest version
MySQL DAC Professional 5.30.0.36

The table and data when I encounter this error is :

CREATE TABLE `config` (
`KeyData` varchar(255) default NULL,
`ValueData` varchar(100) default NULL,
`Category` varchar(100) default NULL,
`ID` int(11) NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO `config` VALUES ('KioskManager.shutdownTime', '22;00', NULL, 0);

There is another error saying invalid default value in the following table

CREATE TABLE `appparam` (
`tag` varchar(100) NOT NULL default '',
`val` varchar(100) NOT NULL default '',
`modified_by` varchar(50) NOT NULL default '',
`lud` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

They work well when I run the dump file in MySQL browser but it didnt work when I use TMyDUMP.restore.

We could not reproduce the problem. Please make sure that you have the most recent version of MyDAC. Also specify the exact version of MySQL server you are using.

Justmade wrote:Another issue which is not bug but not logical is that when I doDatabase in Objects but not select AddDrop, the dump file will create the database but NOT SELECT IT. It will make the following create/update either pop error of no database selected or restored to the current database which is not desirable. If you have to create a database, I think that tables should restore to THAT database.

Thank you for information. We will change this behavior of TMyDump in the next MyDAC build.