Page 1 of 1

UniDump problem with MySQL4

Posted: Thu 16 Jan 2014 16:44
by redone
Hello,

i use UniDAC 5.2.5 with XE5. When i use Unidump with MySQL4 there is no CREATE TABLE in the dumpfile. Instead CREATE TABLE there is ?????????????†?????????????????????†?? written.
Options of UniDump:
AddDro
CompleteInsert
GenerateHeader
QuoteNames
all true

SpecifiedOptions
BackupTables
BackupViews
UseExtSyntax
on true

InsertTyp = itInsert

How can i fix the problem?

Re: UniDump problem with MySQL4

Posted: Fri 17 Jan 2014 10:44
by redone
Hello,

the same in Delphi7 tried, no problems.

Re: UniDump problem with MySQL4

Posted: Sat 25 Jan 2014 16:59
by hh-cm
I have the same problem. Any news on this?

Re: UniDump problem with MySQL4

Posted: Fri 31 Jan 2014 11:56
by hh-cm
By the way,

it occurs only in DirectMode. With libmysql its ok.

Re: UniDump problem with MySQL4

Posted: Fri 31 Jan 2014 14:58
by PavloP
Please provide the script for creating the table, on which the problem can be reproduced, and specify the exact MySQL version

Re: UniDump problem with MySQL4

Posted: Sat 01 Feb 2014 08:26
by hh-cm
MySQL Version : 4.1.22-community-nt

Code: Select all

CREATE DATABASE IF NOT EXISTS `dumptest` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `dumptest`;

CREATE TABLE IF NOT EXISTS `test` (
  `Column 1` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
The result is

DROP TABLE IF EXISTS test;
???????????†?????????????????????????????????????;

Re: UniDump problem with MySQL4

Posted: Tue 04 Feb 2014 12:19
by PavloP
Thank you for the information.

We have reproduced the problem and fixed it.

This fix will be included in the next UniDAC build.