can't restore

The sql file seems valid.
Here the begin and the end of the file :

"
-- Generator: Backup and Migrate
-- https://www.drupal.org/project/backup_migrate
--
-- Host: localhost
-- Database: codiald9-v2
-- Generation Time: Wed, 04 Jan 2023 16:36:49 +0000
-- Database Type: MySQL
-- MySQL Version: 80031

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;

SET AUTOCOMMIT = 0;
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET NAMES utf8mb4;
DROP TABLE IF EXISTS `batch`;
CREATE TABLE `batch` ( `bid` int unsigned NOT NULL COMMENT 'Primary Key: Unique batch ID.', `token` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'A string token generated against the current user''s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.', `timestamp` int NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.', `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.', PRIMARY KEY (`bid`), KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores details about batches (processes that run in…';
INSERT INTO `batch` VALUES ('4','IzbXf7YBrQpB7wGethk-Ynb5bZskpvfU6bZODR7kp38','1594994666','a:13:{s:4:"sets";a:2:{i:0;a:14:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";i:0;s:7:"elapsed";i:0;s:5:"title";O:48:"Drupal\\Core\\StringTranslation\\TranslatableMarkup":3:{s:9:"\0*\0string";s:21:"Updating translations";s:12:"\0*\0arguments";a:0:{}s:10:"\0*\0options";a:0:{}}s:16:"progress_message";s:0:"";s:13:"error_message";O:48:"Drupal\\Core\\StringTranslation\\TranslatableMarkup":3:{s:9:"\0*\0string";s:33:"Error importing translation files";s:12:"\0*\0arguments";a:0:{}s:10:"\0*\0options";a:0:{}}s:8:"finished";s:39:"locale_translation_batch_fetch_finished";s:4:"file";s:36:"core/modules/locale/locale.batch.inc";s:12:"init_message";s:26:"Initialisation.
 ";s:5:"total";i:36;s:5:"count";i:36;s:5:"queue";a:2:{s:4:"name";s:16:"drupal_batch:4:0";s:5:"class";s:23:"Drupal\\Core\\Queue\\Batch";}}i:1;a:14:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";i:0;s:7:"elapsed";i:0;s:5:"title";O:48:"Drupal\\Core\\StringTranslation\\TranslatableMarkup":3:{s:9:"\0*\0string";s:35:"Updating configuration translations";s:12:"\0*\0arguments";a:0:{}s:10:"\0*\0options";a:0:{}}s:12:"init_message";s:56:"Début de la mise à jour de la configuration
 ";s:13:"error_message";O:48:"Drupal\\Core\\StringTranslation\\TranslatableMarkup":3:{s:9:"\0*\0string";s:41:"Error updating configuration translations";s:12:"\0*\0arguments";a:0:{}s:10:"\0*\0options";a:0:{}}s:4:"file";s:35:"core/modules/locale/locale.bulk.inc";s:9:"completed";s:28:"locale_config_batch_finished";s:16:"progress_message";O:48:"Drupal\\Core\\StringTranslation\\TranslatableMarkup":3:{s:9:"\0*\0string";s:29:"Completed @current of @total.";s:12:"\0*\0arguments";a:0:{}s:10:"\0*\0options";a:0:{}}s:5:"total";i:16;s:5:"count";i:16;s:5:"queue";a:2:{s:4:"name";s:16:"drupal_batch:4:1";s:5:"class";s:23:"Drupal\\Core\\Queue\\Batch";}}}s:16:"has_form_submits";b:0;s:10:"form_state";O:26:"Drupal\\Core\\Form\\FormState":33:{s:16:"\0*\0complete_form";a:32:{s:11:"#attributes";a:2:{s:5:"class";a:2:{i:0;s:27:"system-modules-confirm-form";i:1;s:12:"confirmation";}s:20:"data-drupal-selector";s:27:"system-modules-confirm-form";}s:7:"message";a:15:{s:6:"#theme";s:9:"item_list";s:6:"#items";a:2:{i:0;O:54:"Drupal\\Core\\StringTranslation\\PluralTranslatableMarkup":4:{s:9:"\0*\0string";s:114:"You must enable the @required module to install @module.You must enable the @required modules to install @module.";s:12:"\0*\0arguments";a:2:{s:7:"@module";s:13:"Display Suite";s:9:"@required";s:16:"Layout Discovery";}s:10:"\0*\0options";a:0:{}s:8:"\0*\0count";i:1;}i:1;O:54:"Drupal\\Core\\StringTranslation\\PluralTranslatableMarkup":4:{s:9

...

DROP TABLE IF EXISTS `webform_submission_log`;
CREATE TABLE `webform_submission_log` ( `lid` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique log event ID.', `webform_id` varchar(32) NOT NULL COMMENT 'The webform id.', `sid` int unsigned DEFAULT NULL COMMENT 'The webform submission id.', `handler_id` varchar(64) DEFAULT NULL COMMENT 'The webform handler id.', `uid` int unsigned NOT NULL DEFAULT '0' COMMENT 'The users.uid of the user who triggered the event.', `operation` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Type of operation, for example "save", "sent", or "update."', `message` longtext NOT NULL COMMENT 'Text of log message.', `variables` longblob NOT NULL COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.', `data` longblob NOT NULL COMMENT 'Serialized array of data.', `timestamp` int NOT NULL DEFAULT '0' COMMENT 'Unix timestamp of when event occurred.', PRIMARY KEY (`lid`), KEY `webform_id` (`webform_id`), KEY `sid` (`sid`), KEY `uid` (`uid`), KEY `handler_id` (`handler_id`), KEY `handler_id_operation` (`handler_id`,`operation`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Table that contains logs of all webform submission events.' AUTO_INCREMENT=1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

SET FOREIGN_KEY_CHECKS = 1;
COMMIT;
SET AUTOCOMMIT = 1;
"

Have you any idea ?

I have tested with several backup (zip, gzip, bzip) and the problem is the same.
It looks like the file cannot be saved for processing.

I've no error in php and mysql logs.

I've no message in dblog.

If I copy backup to schedule backup and try to restore, I have the same message...

Finally, I found, the encoding (interclassement in French) of tables was different on my local server and on my production server !..

Encoding of database was the same but for each local table he was different... (crazy!!)

I corrected the local encoding with the operations of phpmyadmin. I did a backup with backup and migrate. I restored with backup and migrate and it worked.

Sorry for the inconvenience, but if it can help others...