#3764 BINARY exporting error

3.5.5
invalid
5
2013-06-11
2012-12-28
zzccttu
No

When exporting BINARY field, phpMyAdmin can't export binary data to readable ASCII code, so that the exported SQL can't be reloaded again.

Discussion

  • Marc Delisle

    Marc Delisle - 2012-12-30
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2012-12-30

    Patch for 3.5.5

     
    Attachments
  • Marc Delisle

    Marc Delisle - 2012-12-30

    Please try the attached patch.

     
  • Marc Delisle

    Marc Delisle - 2013-01-05

    Any feedback on this patch?

     
  • zzccttu

    zzccttu - 2013-01-05

    The patch doesn't seem work.
    Furthermore, I found a new bug, when exporting BINARY data shown as text, the data of output is missing.

     
  • Marc Delisle

    Marc Delisle - 2013-01-05

    Could you show me the structure of your table, and some sample data? Because with my test table and the patch, all was fine for a BINARY column.

     
  • Marc Delisle

    Marc Delisle - 2013-01-12
    • status: open --> pending
     
  • zzccttu

    zzccttu - 2013-01-13

    CREATE TABLE IF NOT EXISTS sl_user (
    id int(10) unsigned NOT NULL AUTO_INCREMENT,
    username varchar(15) NOT NULL,
    `password` binary(20) NOT NULL,
    isadmin tinyint(1) NOT NULL DEFAULT '0',
    issuper tinyint(1) NOT NULL DEFAULT '0',
    email varchar(60) CHARACTER SET ascii NOT NULL,
    `status` tinyint(3) unsigned NOT NULL,
    nickname char(20) NOT NULL,
    lastvisit int(10) unsigned NOT NULL,
    lastip varbinary(16) NOT NULL,
    visittimes int(10) unsigned NOT NULL DEFAULT '0',
    regtime int(10) unsigned NOT NULL,
    regip varbinary(16) NOT NULL,
    acttime int(10) unsigned NOT NULL DEFAULT '0',
    onlinetime int(10) unsigned NOT NULL DEFAULT '0',
    tree smallint(5) unsigned NOT NULL DEFAULT '0',
    aaa smallint(5) unsigned NOT NULL DEFAULT '0',
    qq varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '',
    PRIMARY KEY (id),
    UNIQUE KEY username (username),
    UNIQUE KEY email (email),
    KEY nickname (nickname)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8

     
  • Marc Delisle

    Marc Delisle - 2013-01-20
    • status: pending --> open
     
  • Marc Delisle

    Marc Delisle - 2013-01-20

    Please show me some sample data.

     
  • Marc Delisle

    Marc Delisle - 2013-01-28
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2013-03-13
    • status: pending --> closed-invalid
     
  • Isaac Bennetch

    Isaac Bennetch - 2013-05-07

    IRC user Dylan343 reported to me that your patch (modified because the file has since been moved) fixes a similar problem.

     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-invalid --> invalid
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks