• I have set up a mysqldump process to run under cron.daily to backup the data in our mysql database running the clouse ENGINE.

    I recently tried to import that sql from the dump file and had an error returned to me. Here is the relevant sql code.
    `
    DROP TABLE IF EXISTS wp_10_cloud_media_content;
    /*!40101 SET @saved_cs_client = @@character_set_client */;
    /*!40101 SET character_set_client = utf8 */;
    CREATE TABLE wp_10_cloud_media_content (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    name varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ”,
    value$wblob_info blob,
    value$wblob longblob,
    PRIMARY KEY (id,name)
    ) ENGINE=ClouSE DEFAULT CHARSET=latin1;
    /*!40101 SET character_set_client = @saved_cs_client */;


    — Dumping data for table wp_10_cloud_media_content

    LOCK TABLES wp_10_cloud_media_content WRITE;
    /*!40000 ALTER TABLE wp_10_cloud_media_content DISABLE KEYS */;
    `

    ERROR 1105 (HY000) at line 39: ClouSE does not support ALTER TABLE with LOCK TABLES.

    Any suggestions to make this work? Are their params I need to set on mysqldump or mysql import cmd.

    https://www.ads-software.com/plugins/wp2cloud-wordpress-to-cloud/

Viewing 1 replies (of 1 total)
  • Plugin Author Artem Livshits

    (@artemlivshits)

    You can add the –skip-add-locks flag to the mysqldump command and it won’t generate the LOCK TABLES statements.

Viewing 1 replies (of 1 total)
  • The topic ‘Reimport sql data from mysqldump of clouse database’ is closed to new replies.