------------ Dump from MySQL 8.0.22 MySQL JS > \c root@localhost Creating a session to 'root@localhost' Please provide the password for 'root@localhost': Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): Fetching schema names for autocompletion... Press ^C to stop. Your MySQL connection id is 18 (X protocol) Server version: 8.0.22 MySQL Community Server - GPL No default schema selected; type \use to set one. MySQL localhost:33060+ ssl JS > MySQL localhost:33060+ ssl JS > util.dumpSchemas(["sakila"], "C:/Work/8022", {ocimds: true, compatibility: ["strip_definers"]}) Acquiring global read lock Global read lock acquired All transactions have been started Locking instance for backup Global read lock has been released Checking for compatibility with MySQL Database Service 8.0.22 NOTE: Database sakila had unsupported ENCRYPTION option commented out NOTE: Function sakila.get_customer_balance had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: Function sakila.inventory_held_by_customer had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: Function sakila.inventory_in_stock had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: Procedure sakila.film_in_stock had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: Procedure sakila.film_not_in_stock had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: Procedure sakila.rewards_report had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: Trigger sakila.customer_create_date had definer clause removed NOTE: Trigger sakila.ins_film had definer clause removed NOTE: Trigger sakila.upd_film had definer clause removed NOTE: Trigger sakila.del_film had definer clause removed NOTE: Trigger sakila.payment_date had definer clause removed NOTE: Trigger sakila.rental_date had definer clause removed NOTE: View sakila.actor_info had definer clause removed NOTE: View sakila.customer_list had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: View sakila.film_list had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: View sakila.nicer_but_slower_film_list had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: View sakila.sales_by_film_category had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: View sakila.sales_by_store had definer clause removed and SQL SECURITY characteristic set to INVOKER NOTE: View sakila.staff_list had definer clause removed and SQL SECURITY characteristic set to INVOKER Compatibility issues with MySQL Database Service 8.0.22 were found and repaired. Please review the changes made before loading them. Writing global DDL files Writing DDL for schema `sakila` Writing DDL for view `sakila`.`film_list` Writing DDL for view `sakila`.`customer_list` Writing DDL for view `sakila`.`actor_info` Preparing data dump for table `sakila`.`actor` Data dump for table `sakila`.`actor` will be chunked using column `actor_id` Preparing data dump for table `sakila`.`address` Data dump for table `sakila`.`address` will be chunked using column `address_id` Preparing data dump for table `sakila`.`category` Data dump for table `sakila`.`category` will be chunked using column `category_id` Preparing data dump for table `sakila`.`city` Data dump for table `sakila`.`city` will be chunked using column `city_id` Writing DDL for view `sakila`.`nicer_but_slower_film_list` Writing DDL for view `sakila`.`sales_by_film_category` Writing DDL for view `sakila`.`sales_by_store` Writing DDL for view `sakila`.`staff_list` Preparing data dump for table `sakila`.`country` Data dump for table `sakila`.`country` will be chunked using column `country_id` Preparing data dump for table `sakila`.`customer` Data dump for table `sakila`.`customer` will be chunked using column `customer_id` Preparing data dump for table `sakila`.`film` Data dump for table `sakila`.`film` will be chunked using column `film_id` Preparing data dump for table `sakila`.`film_actor` Data dump for table `sakila`.`film_actor` will be chunked using column `actor_id` Writing DDL for table `sakila`.`category` Writing DDL for table `sakila`.`address` Writing DDL for table `sakila`.`actor` Writing DDL for table `sakila`.`city` Preparing data dump for table `sakila`.`film_category` Data dump for table `sakila`.`film_category` will be chunked using column `film_id` Preparing data dump for table `sakila`.`film_text` Data dump for table `sakila`.`film_text` will be chunked using column `film_id` Preparing data dump for table `sakila`.`inventory` Data dump for table `sakila`.`inventory` will be chunked using column `inventory_id` Writing DDL for table `sakila`.`country` Preparing data dump for table `sakila`.`language` Data dump for table `sakila`.`language` will be chunked using column `language_id` Writing DDL for table `sakila`.`film` Writing DDL for table `sakila`.`film_actor` Writing DDL for table `sakila`.`customer` Preparing data dump for table `sakila`.`payment` Data dump for table `sakila`.`payment` will be chunked using column `payment_id` Writing DDL for table `sakila`.`film_category` Preparing data dump for table `sakila`.`rental` Data dump for table `sakila`.`rental` will be chunked using column `rental_id` Preparing data dump for table `sakila`.`staff` Data dump for table `sakila`.`staff` will be chunked using column `staff_id` Writing DDL for table `sakila`.`film_text` Preparing data dump for table `sakila`.`store` Data dump for table `sakila`.`store` will be chunked using column `store_id` Writing DDL for table `sakila`.`inventory` Running data dump using 4 threads. NOTE: Progress information uses estimated values and may not be accurate. Writing DDL for table `sakila`.`language` Writing DDL for table `sakila`.`payment` Writing DDL for table `sakila`.`rental` Writing DDL for table `sakila`.`staff` Writing DDL for table `sakila`.`store` Data dump for table `sakila`.`actor` will be written to 1 file Data dump for table `sakila`.`address` will be written to 1 file Data dump for table `sakila`.`category` will be written to 1 file Data dump for table `sakila`.`city` will be written to 1 file Data dump for table `sakila`.`country` will be written to 1 file Data dump for table `sakila`.`customer` will be written to 1 file Data dump for table `sakila`.`film` will be written to 1 file Data dump for table `sakila`.`film_text` will be written to 1 file Data dump for table `sakila`.`film_actor` will be written to 1 file Data dump for table `sakila`.`film_category` will be written to 1 file Data dump for table `sakila`.`inventory` will be written to 1 file Data dump for table `sakila`.`language` will be written to 1 file Data dump for table `sakila`.`payment` will be written to 1 file Data dump for table `sakila`.`rental` will be written to 1 file Data dump for table `sakila`.`store` will be written to 1 file Data dump for table `sakila`.`staff` will be written to 1 file 1 thds dumping - 99% (47.27K rows / ~47.27K rows), 0.00 rows/s, 0.00 B/s uncompressed, 0.00 B/s compressed Duration: 00:00:00s Schemas dumped: 1 Tables dumped: 16 Uncompressed data size: 3.03 MB Compressed data size: 557.10 KB Compression ratio: 5.4 Rows written: 47273 Bytes written: 557.10 KB Average uncompressed throughput: 3.03 MB/s Average compressed throughput: 557.10 KB/s MySQL localhost:33060+ ssl JS > ------------ Load on 5.7.32 MySQL example.com:3333 ssl JS > util.loadDump("C:/Work/8022", {ignoreVersion: true}) Loading DDL and Data from 'C:/Work/8022' using 4 threads. Opening dump... Target is MySQL 5.7.32. Dump was produced from MySQL 8.0.22 WARNING: Destination MySQL version is older than the one where the dump was created. Loading dumps from different major MySQL versions is not fully supported and may not work. 'ignoreVersion' option is enabled, so loading anyway. NOTE: Load progress file detected. Load will be resumed from where it was left, assuming no external updates were made. You may enable the 'resetProgress' option to discard progress for this MySQL instance and force it to be completely reloaded. Executing common preamble SQL Re-executing DDL script for schema `sakila` [Worker003] Re-executing DDL script for `sakila`.`store` [Worker001] Re-executing DDL script for `sakila`.`actor_info` (placeholder for view) [Worker000] Re-executing DDL script for `sakila`.`film_list` (placeholder for view) [Worker002] Re-executing DDL script for `sakila`.`customer_list` (placeholder for view) [Worker003] Re-executing DDL script for `sakila`.`nicer_but_slower_film_list` (placeholder for view) [Worker001] Re-executing DDL script for `sakila`.`sales_by_film_category` (placeholder for view) [Worker002] Re-executing DDL script for `sakila`.`sales_by_store` (placeholder for view) [Worker000] Re-executing DDL script for `sakila`.`staff_list` (placeholder for view) Re-executing DDL script for view `sakila`.`actor_info` Re-executing DDL script for view `sakila`.`customer_list` Re-executing DDL script for view `sakila`.`nicer_but_slower_film_list` Re-executing DDL script for view `sakila`.`film_list` Re-executing DDL script for view `sakila`.`sales_by_film_category` Re-executing DDL script for view `sakila`.`sales_by_store` Re-executing DDL script for view `sakila`.`staff_list` [Worker000] sakila@staff@@0.tsv.zst: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0 [Worker003] sakila@payment@@0.tsv.zst: Records: 16049 Deleted: 0 Skipped: 0 Warnings: 0 [Worker002] sakila@rental@@0.tsv.zst: Records: 16044 Deleted: 0 Skipped: 0 Warnings: 0 [Worker000] sakila@address@@0.tsv.zst: Records: 603 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@film@@0.tsv.zst: Records: 1000 Deleted: 0 Skipped: 0 Warnings: 0 4 thds loading \ 96% (2.92 MB / 3.03 MB), 26.07 KB/s, 5 / 16 tables done[Worker003] sakila@film_text@@0.tsv.zst: Records: 1000 Deleted: 0 Skipped: 0 Warnings: 0 4 thds loading / 96% (2.92 MB / 3.03 MB), 28.77 KB/s, 6 / 16 tables done[Worker002] sakila@film_actor@@0.tsv.zst: Records: 5462 Deleted: 0 Skipped: 0 Warnings: 0 4 thds loading \ 98% (2.97 MB / 3.03 MB), 28.77 KB/s, 7 / 16 tables done[Worker000] sakila@inventory@@0.tsv.zst: Records: 4581 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@customer@@0.tsv.zst: Records: 599 Deleted: 0 Skipped: 0 Warnings: 0 [Worker003] sakila@city@@0.tsv.zst: Records: 600 Deleted: 0 Skipped: 0 Warnings: 0 [Worker002] sakila@film_category@@0.tsv.zst: Records: 1000 Deleted: 0 Skipped: 0 Warnings: 0 [Worker000] sakila@actor@@0.tsv.zst: Records: 200 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@country@@0.tsv.zst: Records: 109 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] Recreating indexes for `sakila`.`film_text` [Worker003] sakila@category@@0.tsv.zst: Records: 16 Deleted: 0 Skipped: 0 Warnings: 0 2 thds loading - 1 thds indexing - 100% (3.03 MB / 3.03 MB), 28.67 KB/s, 14 / 16 tables done[Worker002] sakila@language@@0.tsv.zst: Records: 6 Deleted: 0 Skipped: 0 Warnings: 0 [Worker000] sakila@store@@0.tsv.zst: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0 Executing triggers SQL for `sakila`.`film` Executing triggers SQL for `sakila`.`customer` Executing triggers SQL for `sakila`.`payment` Executing triggers SQL for `sakila`.`rental` Executing common postamble SQL 16 chunks (47.27K rows, 3.03 MB) for 16 tables in 1 schemas were loaded in 2 min 28 sec (avg throughput 20.50 KB/s) 0 warnings were reported during the load. ------------ Load on 5.7.27 Loading DDL and Data from 'C:/Work/8022' using 4 threads. Opening dump... Target is MySQL 5.7.27. Dump was produced from MySQL 8.0.22 WARNING: Destination MySQL version is older than the one where the dump was created. Loading dumps from different major MySQL versions is not fully supported and may not work. 'ignoreVersion' option is enabled, so loading anyway. Checking for pre-existing objects... Executing common preamble SQL Executing DDL script for schema `sakila` [Worker002] Executing DDL script for `sakila`.`city` [Worker000] Executing DDL script for `sakila`.`actor` [Worker001] Executing DDL script for `sakila`.`film` [Worker003] Executing DDL script for `sakila`.`address` [Worker002] Executing DDL script for `sakila`.`customer` [Worker001] Executing DDL script for `sakila`.`payment` [Worker000] Executing DDL script for `sakila`.`country` [Worker003] Executing DDL script for `sakila`.`staff` [Worker002] Executing DDL script for `sakila`.`category` [Worker001] Executing DDL script for `sakila`.`film_actor` [Worker000] Executing DDL script for `sakila`.`film_category` [Worker003] Executing DDL script for `sakila`.`film_text` (indexes removed for deferred creation) [Worker002] Executing DDL script for `sakila`.`inventory` [Worker001] Executing DDL script for `sakila`.`language` [Worker000] Executing DDL script for `sakila`.`rental` [Worker003] Executing DDL script for `sakila`.`store` [Worker002] Executing DDL script for `sakila`.`actor_info` (placeholder for view) [Worker001] Executing DDL script for `sakila`.`customer_list` (placeholder for view) [Worker000] Executing DDL script for `sakila`.`film_list` (placeholder for view) [Worker003] Executing DDL script for `sakila`.`nicer_but_slower_film_list` (placeholder for view) [Worker002] Executing DDL script for `sakila`.`sales_by_film_category` (placeholder for view) [Worker001] Executing DDL script for `sakila`.`sales_by_store` (placeholder for view) [Worker000] Executing DDL script for `sakila`.`staff_list` (placeholder for view) Executing DDL script for view `sakila`.`nicer_but_slower_film_list` Executing DDL script for view `sakila`.`film_list` Executing DDL script for view `sakila`.`actor_info` Executing DDL script for view `sakila`.`customer_list` Executing DDL script for view `sakila`.`sales_by_film_category` Executing DDL script for view `sakila`.`sales_by_store` Executing DDL script for view `sakila`.`staff_list` [Worker003] sakila@staff@@0.tsv.zst: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@film@@0.tsv.zst: Records: 1000 Deleted: 0 Skipped: 0 Warnings: 0 4 thds loading | 82% (2.51 MB / 3.03 MB), 21.89 KB/s, 2 / 16 tables done[Worker000] sakila@payment@@0.tsv.zst: Records: 16049 Deleted: 0 Skipped: 0 Warnings: 0 [Worker003] sakila@address@@0.tsv.zst: Records: 603 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@film_text@@0.tsv.zst: Records: 1000 Deleted: 0 Skipped: 0 Warnings: 0 4 thds loading \ 96% (2.92 MB / 3.03 MB), 23.72 KB/s, 5 / 16 tables done[Worker000] sakila@film_actor@@0.tsv.zst: Records: 5462 Deleted: 0 Skipped: 0 Warnings: 0 [Worker003] sakila@inventory@@0.tsv.zst: Records: 4581 Deleted: 0 Skipped: 0 Warnings: 0 [Worker002] sakila@rental@@0.tsv.zst: Records: 16044 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@customer@@0.tsv.zst: Records: 599 Deleted: 0 Skipped: 0 Warnings: 0 [Worker000] sakila@city@@0.tsv.zst: Records: 600 Deleted: 0 Skipped: 0 Warnings: 0 [Worker003] sakila@film_category@@0.tsv.zst: Records: 1000 Deleted: 0 Skipped: 0 Warnings: 0 [Worker002] sakila@actor@@0.tsv.zst: Records: 200 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] sakila@country@@0.tsv.zst: Records: 109 Deleted: 0 Skipped: 0 Warnings: 0 [Worker001] Recreating indexes for `sakila`.`film_text` 3 thds loading / 99% (3.03 MB / 3.03 MB), 24.96 KB/s, 13 / 16 tables done[Worker000] sakila@category@@0.tsv.zst: Records: 16 Deleted: 0 Skipped: 0 Warnings: 0 2 thds loading - 100% (3.03 MB / 3.03 MB), 24.83 KB/s, 14 / 16 tables done[Worker003] sakila@language@@0.tsv.zst: Records: 6 Deleted: 0 Skipped: 0 Warnings: 0 [Worker002] sakila@store@@0.tsv.zst: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0 Executing triggers SQL for `sakila`.`film` Executing triggers SQL for `sakila`.`customer` Executing triggers SQL for `sakila`.`payment` Executing triggers SQL for `sakila`.`rental` Executing common postamble SQL 16 chunks (47.27K rows, 3.03 MB) for 16 tables in 1 schemas were loaded in 2 min 44 sec (avg throughput 18.50 KB/s) 0 warnings were reported during the load. MySQL example.com:3333 JS >