Title: Export SQL error
Last modified: July 24, 2023

---

# Export SQL error

 *  Resolved [wireinet](https://wordpress.org/support/users/wireinet/)
 * (@wireinet)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/export-sql-error/)
 * HellO! This very usefull plugin gets me error where i try export database to 
   dump. See the screenshot:
   [https://disk.yandex.ru/i/qwT8hgyg4hdhdw](https://disk.yandex.ru/i/qwT8hgyg4hdhdw)
   also, I put this as text:CREATE DEFINER=`CURRENT_USER` FUNCTION `wp_fn_realmedialibrary_childs`(`
   rootId` INT, `_useTempChildTableForCheck` BOOLEAN) RETURNS VARCHAR(1000) CHARSET
   utf8mb4 COLLATE utf8mb4_unicode_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 wp_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0; ELSE
   SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary_tmp WHERE FIND_IN_SET(
   parent,sTempChd) > 0; END IF; END WHILE; RETURN sTemp; END
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexport-sql-error%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [wireinet](https://wordpress.org/support/users/wireinet/)
 * (@wireinet)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/export-sql-error/#post-16917247)
 * HellO! This very usefull plugin gets me error where i try export database to 
   dump. See the screenshot:
   [https://disk.yandex.ru/i/qwT8hgyg4hdhdw](https://disk.yandex.ru/i/qwT8hgyg4hdhdw)
   also, I put this as text:
 *     ```wp-block-code
       --
       -- Функции
       --
       CREATE DEFINER=root@% FUNCTION wp_fn_realmedialibrary_childs (rootId INT, _useTempChildTableForCheck BOOLEAN) RETURNS VARCHAR(1000) CHARSET utf8mb4 COLLATE utf8mb4_unicode_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 wp_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0;
               		ELSE
               		    SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary_tmp WHERE FIND_IN_SET(parent,sTempChd) > 0;
               		END IF;
               	END WHILE;
               	RETURN sTemp;
               END
       ```
   
 *  Plugin Contributor [Matthias Günter](https://wordpress.org/support/users/mguenter/)
 * (@mguenter)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/export-sql-error/#post-16920386)
 * Hey [@wireinet](https://wordpress.org/support/users/wireinet/) !
 * Thanks for your message. Please check out this help article about the Real Media
   Library database dump: [https://devowl.io/knowledge-base/real-media-library-sql-dump-import-failed-due-to-function-procedure/](https://devowl.io/knowledge-base/real-media-library-sql-dump-import-failed-due-to-function-procedure/)

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Export SQL error’ is closed to new replies.

 * ![](https://ps.w.org/real-media-library-lite/assets/icon-256x256.gif?rev=2293211)
 * [Real Media Library: Media Library Folder & File Manager](https://wordpress.org/plugins/real-media-library-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/real-media-library-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/real-media-library-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/real-media-library-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/real-media-library-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/real-media-library-lite/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Matthias Günter](https://wordpress.org/support/users/mguenter/)
 * Last activity: [2 years, 10 months ago](https://wordpress.org/support/topic/export-sql-error/#post-16920386)
 * Status: resolved