######################## COMPILED NEW VERSION ######################## root@vagrant:~/mydumper# git pull remote: Enumerating objects: 14, done. remote: Counting objects: 100% (14/14), done. remote: Compressing objects: 100% (10/10), done. remote: Total 14 (delta 7), reused 6 (delta 4), pack-reused 0 Unpacking objects: 100% (14/14), done. From https://github.com/maxbube/mydumper 768362c..6f058b0 master -> origin/master * [new branch] table_names -> origin/table_names Updating 768362c..6f058b0 Fast-forward myloader.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) root@vagrant:~/mydumper# git log -p commit 6f058b020e016bda2b5f4ae7bc5cbe24837a2891 (HEAD -> master, origin/master, origin/HEAD) Merge: 768362c 308db3c Author: davidducos Date: Tue Aug 24 09:53:34 2021 -0300 Merge pull request #398 from maxbube/fix-config-file-set-session Adding the set session execution root@vagrant:~/mydumper# make clean root@vagrant:~/mydumper# cmake . -- Using mysql-config: /usr/bin/mysql_config -- Found MySQL: /usr/include/mysql, /usr/lib/x86_64-linux-gnu/libmysqlclient.so;/usr/lib/x86_64-linux-gnu/libpthread.so;/usr/lib/x86_64-linux-gnu/libz.so;/usr/lib/x86_64-linux-gnu/libm.so;/usr/lib/x86_64-linux-gnu/librt.so;/usr/lib/x86_64-linux-gnu/libatomic.so.1;/usr/lib/x86_64-linux-gnu/libssl.so;/usr/lib/x86_64-linux-gnu/libcrypto.so;/usr/lib/x86_64-linux-gnu/libdl.so CMake Warning at docs/CMakeLists.txt:9 (message): Unable to find Sphinx documentation generator -- ------------------------------------------------ -- MYSQL_CONFIG = /usr/bin/mysql_config -- CMAKE_INSTALL_PREFIX = /usr/local -- BUILD_DOCS = ON -- WITH_BINLOG = OFF -- RUN_CPPCHECK = OFF -- Change a values with: cmake -D= -- ------------------------------------------------ -- -- Configuring done -- Generating done -- Build files have been written to: /root/mydumper root@vagrant:~/mydumper# make [ 6%] Building C object CMakeFiles/myloader.dir/myloader.c.o [ 12%] Building C object CMakeFiles/myloader.dir/connection.c.o [ 18%] Building C object CMakeFiles/myloader.dir/getPassword.c.o [ 25%] Building C object CMakeFiles/myloader.dir/logging.c.o [ 31%] Building C object CMakeFiles/myloader.dir/set_verbose.c.o [ 37%] Building C object CMakeFiles/myloader.dir/common.c.o [ 43%] Linking C executable myloader [ 43%] Built target myloader [ 50%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o [ 56%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o [ 62%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o [ 68%] Building C object CMakeFiles/mydumper.dir/connection.c.o [ 75%] Building C object CMakeFiles/mydumper.dir/getPassword.c.o [ 81%] Building C object CMakeFiles/mydumper.dir/logging.c.o [ 87%] Building C object CMakeFiles/mydumper.dir/set_verbose.c.o [ 93%] Building C object CMakeFiles/mydumper.dir/common.c.o [100%] Linking C executable mydumper [100%] Built target mydumper root@vagrant:~/mydumper# ./myloader --version myloader 0.10.8, built against MySQL 5.7.35 ######################## TESTING WITH NEW BINARY ######################## root@vagrant:~/mydumper# cat /root/mydumper/myloader_config.ini [myloader_variables] sql_mode='NO_AUTO_VALUE_ON_ZERO' root@vagrant:~/mydumper# ./myloader --threads=4 --overwrite-tables --verbose 3 --directory=/root/mydumper/DUMPS/ --config=/root/mydumper/myloader_config.ini .... ** Message: 16:11:00.591: Creating table `mysql`.`proc` ** (myloader:1907): CRITICAL **: 16:11:00.592: Error restoring mysql.proc from file mysql.proc-schema.sql: Invalid default value for 'modified' ** (myloader:1907): CRITICAL **: 16:11:00.592: Error restoring mysql.proc from file mysql.proc-schema.sql: Invalid default value for 'modified' ** Message: 16:11:00.593: Dropping table or view (if exists) `sys`.`user_summary_by_statement_latency` ** Message: 16:11:00.593: Creating table `sys`.`user_summary_by_statement_latency` .... ######################## GENERAL LOG OUPTUT ######################## 2021-08-26T16:03:45.071083Z 4 Query SHOW CREATE DATABASE `mysql` 2021-08-26T16:03:45.071606Z 4 Query DROP TABLE IF EXISTS `mysql`.`proc` 2021-08-26T16:03:45.072246Z 4 Query DROP VIEW IF EXISTS `mysql`.`proc` 2021-08-26T16:03:45.072566Z 4 Query USE `mysql` 2021-08-26T16:03:45.079479Z 4 Query /*!40101 SET NAMES binary*/ 2021-08-26T16:03:45.079635Z 4 Query /*!40014 SET FOREIGN_KEY_CHECKS=0*/ 2021-08-26T16:03:45.079711Z 4 Query /*!40103 SET TIME_ZONE='+00:00' */ 2021-08-26T16:03:45.079924Z 4 Query CREATE TABLE `proc` ( `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `name` char(64) NOT NULL DEFAULT '', `type` enum('FUNCTION','PROCEDURE') NOT NULL, `specific_name` char(64) NOT NULL DEFAULT '', `language` enum('SQL') NOT NULL DEFAULT 'SQL', `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',