Reimport sql data from mysqldump of clouse database
-
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 EXISTSwp_10_cloud_media_content
;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLEwp_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 tablewp_10_cloud_media_content
—LOCK TABLES
wp_10_cloud_media_content
WRITE;
/*!40000 ALTER TABLEwp_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/
- The topic ‘Reimport sql data from mysqldump of clouse database’ is closed to new replies.