前提・実現したいこと
MySQLのmysqlpumpコマンドで、警告メッセージが出てしまいます。
(mysqlpumpは、MySQLがインストールされているサーバで実行しております。)
mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
なぜ、この警告が出てしまうのでしょうか?
ご存知の方がいらっしゃれば、ご教示頂けないでしょうか?
■環境
OS:Wiondows Server 2016 STD
MySQL:MySQL Community Server 8.0.15
発生している問題・エラーメッセージ
C:\Users\Administrator>mysqlpump -u root -p --databases dbo --single-transaction > D:\mysql_backup_201907181629.sql Enter password: ******** Dump progress: 1/6 tables, 0/89 rows mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. mysqlpump: [WARNING] (3719) 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. Dump completed in 1632
試したこと
出力されたSQLファイルを見ても、CHARSET=utf8 で指定している箇所はありませんでした。
utf8mb3もありませんでした。
テーブルを作成するときは、CHARSET=utf8mb4で作成しております。
回答2件
あなたの回答
tips
プレビュー