Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Database Dump And Issue With Timestamp Column Data No Treated As A Str

forums forums SQLyog SQLyog: Bugs / Feature Requests Database Dump And Issue With Timestamp Column Data No Treated As A Str

Tagged: , ,

This topic contains 3 replies, has 0 voices, and was last updated by  treadmill 6 years, 3 months ago.

  • Author
    Posts
  • #12857

    treadmill
    Member

    In the current release 10.4, there is most definitely a bug in the database backup. Any column that is a timestamp is not exported as a string – it has no single-quotes around the data, therefore all restores fail.

    This is causing major issues for our backups regime, please can you supply an immediate fix for this asap.

    In the meantime, can you supply a previous version 10.2 or 10.3 so I can continue backups, as this is critical.

  • #33982

    Zaph
    Participant

    Was just about to post exactly the same issue

  • #33983

    peterlaursen
    Participant

    Verified as described – here with latest internal development build. TIMESTAMPS are affected. Not DATETIME, DATE and TIME columns.

    /*

    SQLyog Ultimate v10.5 Beta1

    MySQL – 5.1.66-community : Database – times

    *********************************************************************

    */

    /*!40101 SET NAMES utf8 */;

    /*!40101 SET SQL_MODE=''*/;

    /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

    /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

    /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

    CREATE DATABASE /*!32312 IF NOT EXISTS*/`times` /*!40100 DEFAULT CHARACTER SET utf8 */;

    USE `times`;

    /*Table structure for table `times` */

    DROP TABLE IF EXISTS `times`;

    CREATE TABLE `times` (

    `id` int(11) DEFAULT NULL,

    `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

    `dt` datetime DEFAULT NULL,

    `da` date DEFAULT NULL,

    `ti` time DEFAULT NULL

    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    /*Data for the table `times` */

    insert into `times`(`id`,`ts`,`dt`,`da`,`ti`) values (NULL,2012-11-20 17:11:52,'2012-11-20 17:11:52','2012-11-20','17:11:52');

    /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

    /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

    /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

    Priority fix, of course!

  • #33984

    ashwin
    Member

    We have fixed and released v10.41. Refer: http://blog.webyog.com/2012/11/21/sqlyog-mysql-gui-10-41-released/

  • #33985

    treadmill
    Member

    Fantastic, thank you very much for such a quick fix release. 🙂

You must be logged in to reply to this topic.