DB (mysql) Import Failure
-
If I remove this “Definer” error during import, will it break the plugin on the new site I’m moving the DB to? Or, is there another workaround. I don’t want to fiddle with the SED on my server for this obstacle. Thanks for a great plugin !!!
-- -- Functions -- CREATE DEFINER=
wp_kqdlq
@%
FUNCTIONmca_fn_realmedialibrary_childs
(rootId
INT,_useTempChildTableForCheck
BOOLEAN) RETURNS VARCHAR(1000) CHARSET utf8 COLLATE utf8_general_ci READS SQL DATA SQL SECURITY INVOKER BEGIN DECLARE sTemp VARCHAR(1000); DECLARE sTempChd VARCHAR(1000); SET sTemp = '$'; SET sTempChd = CAST(rootId AS CHAR); SET SESSION group_concat_max_len = 100000; WHILE sTempChd IS NOT NULL DO SET sTemp = CONCAT(sTemp,',',sTempChd); IF _useTempChildTableForCheck IS NULL OR _useTempChildTableForCheck = false THEN SELECT GROUP_CONCAT(id) INTO sTempChd FROM mca_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0; ELSE SELECT GROUP_CONCAT(id) INTO sTempChd FROM mca_realmedialibrary_tmp WHERE FIND_IN_SET(parent,sTempChd) > 0; END IF; END WHILE; RETURN sTemp; END;
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘DB (mysql) Import Failure’ is closed to new replies.