在MYSQL中導入cookbook.sql文件

參考資料：

GitHub 項目：svetasmirnova/mysqlcookbook
CSDN 博客：https://blog.csdn.net/u011868279/category_11645577.html

建庫：

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> CREATE DATABASE cookbook;
Query OK, 1 row affected (0.00 sec)mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| carrefour          |
| cookbook           |
| information_schema |
| menagerie          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
7 rows in set (0.00 sec)mysql> 
Guide:
[root@MaxwellDBA backup]# ls -ltt
total 16428
-rw-r--r-- 1 root root 16813610 Oct 13 14:18 cookbook.sql
-rw-r--r-- 1 root root     4794 Oct 13 11:03 carrefour_dump.sql
[root@MaxwellDBA backup]# pwd
/var/lib/mysql/backup
[root@MaxwellDBA backup]# mysql -u root -p cookbook < cookbook.sql
Enter password: 
[root@MaxwellDBA backup]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 100
Server version: 8.0.26 Source distributionCopyright (c) 2000, 2021, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| carrefour          |
| cookbook           |
| information_schema |
| menagerie          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
7 rows in set (0.00 sec)mysql> use cookbook
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> 
mysql> show tables;
+-----------------------+
| Tables_in_cookbook    |
+-----------------------+
| actors                |
| adcount               |
| al_winner             |
| app_log               |
| artist                |
| book_authors          |
| book_vendor           |
| booksales             |
| catalog_list          |
| cd                    |
| city                  |
| color                 |
| cow_color             |
| cow_order             |
| date_val              |
| datetbl               |
| datetime_val          |
| die                   |
| doremi                |
| drawing               |
| driver_log            |
| expt                  |
| formula1              |
| goods_characteristics |
| goods_shops           |
| groceries             |
| groceries_order_items |
| hitcount              |
| hitlog                |
| hostip                |
| hostname              |
| housewares            |
| housewares2           |
| housewares3           |
| housewares4           |
| httpdlog              |
| httpdlog2             |
| hw_category           |
| image                 |
| ingredient            |
| insect                |
| inv_item              |
| invoice               |
| item                  |
| limbs                 |
| mail                  |
| marathon              |
| mark_log              |
| metal                 |
| money                 |
| movies                |
| movies_actors         |
| movies_actors_link    |
| name                  |
| news                  |
| newsstaff             |
| numbers               |
| obs                   |
| occasion              |
| painting              |
| passtbl               |
| passwd                |
| patients              |
| perl_session          |
| person                |
| php_session           |
| phrase                |
| player_stats          |
| player_stats2         |
| poi                   |
| poll_vote             |
| profile               |
| profile_contact       |
| rainfall              |
| rand_names            |
| rank                  |
| ranks                 |
| reviews               |
| roster                |
| ruby_session          |
| sales_region          |
| sales_tax_rate        |
| sales_volume          |
| sibling               |
| standings1            |
| standings2            |
| states                |
| str_val               |
| sundays               |
| testscore             |
| testscore_withmisses  |
| testscore_withmisses2 |
| time_val              |
| tmp                   |
| tomcat_role           |
| tomcat_session        |
| tomcat_user           |
| top_names             |
| trip_leg              |
| trip_log              |
| tsdemo                |
| weatherdata           |
| weekday               |
+-----------------------+
103 rows in set (0.00 sec)

————————————————

                        版權聲明：本文為博主原創文章，遵循 CC 4.0 BY-SA 版權協議，轉載請附上原文出處鏈接和本聲明。

原文鏈接：https://blog.csdn.net/u011868279/article/details/127301090

D:\software\MySql\bin>mysql -u root -p cookbook < D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql
Enter password: ****
ERROR 1050 (42S01) at line 1073: Table 'limbs' already existsD:\software\MySql\bin>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.40 MySQL Community Server - GPLCopyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| cookbook           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)mysql> use cookbook
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_cookbook    |
+-----------------------+
| actors                |
| adcount               |
| al_winner             |
| app_log               |
| artist                |
| book_authors          |
| book_vendor           |
| booksales             |
| catalog_list          |
| cd                    |
| city                  |
| color                 |
| cow_color             |
| cow_order             |
| date_val              |
| datetbl               |
| datetime_val          |
| die                   |
| doremi                |
| drawing               |
| driver_log            |
| expt                  |
| formula1              |
| goods_characteristics |
| goods_shops           |
| groceries             |
| groceries_order_items |
| hitcount              |
| hitlog                |
| hostip                |
| hostname              |
| housewares            |
| housewares2           |
| housewares3           |
| housewares4           |
| httpdlog              |
| httpdlog2             |
| hw_category           |
| image                 |
| ingredient            |
| insect                |
| inv_item              |
| invoice               |
| item                  |
| limbs                 |
| mail                  |
| mail_view             |
| mytable               |
| profile               |
| profile_contact       |
| some table            |
| taxpayer              |
+-----------------------+
52 rows in set (0.00 sec)

小迪，為什么導入D:\software\MySql\bin>mysql -u root -p cookbook < D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql 只有52個文件，原程序有
103 rows in set (0.00 sec）

關于MySQL導入文件數量不一致的問題
您遇到的問題是：從cookbook.sql文件導入時只導入了52個表/數據，而原程序應該有103個。

可能的原因
SQL文件不完整：檢查cookbook.sql文件是否完整，可能只包含了部分內容

字符編碼問題：文件可能在傳輸或保存過程中使用了不兼容的字符編碼，導致部分SQL語句無法正確解析

執行錯誤：導入過程中可能有部分語句執行失敗，但未顯示錯誤

文件路徑問題：確認D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql確實是完整的文件

解決方案
檢查文件完整性：

type D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql | find “CREATE TABLE”
統計文件中包含的CREATE TABLE語句數量

分步導入：

mysql -u root -p cookbook < D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql > import.log 2>&1
這樣可以將導入過程的輸出和錯誤保存到import.log文件中查看

使用MySQL客戶端直接導入：mysql -u root -p
use cookbook;
source D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql;

這樣可以實時看到執行過程中的任何錯誤

驗證數據：
導入后執行：

SHOW TABLES;
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ‘cookbook’;
查看實際導入的表數量

如果您能提供導入過程中的錯誤信息或SQL文件的開頭部分，我可以給出更具體的建議。
mysql> source D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql;

mysql Ver 8.0.40 for Win64 on x86_64 (MySQL Community Server - GPL)

Connection id: 19
Current database: cookbook
Current user: root@localhost
SSL: Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter: ;
Server version: 8.0.40 MySQL Community Server - GPL
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Binary data as: Hexadecimal
Uptime: 6 days 22 hours 53 min 31 sec

Threads: 2 Questions: 855 Slow queries: 0 Opens: 202 Flush tables: 3 Open tables: 120 Queries per second avg: 0.001

向小迪咨詢，解決方案：
ERROR:
Unknown command ‘\M’.
ERROR:
Unknown command ‘\m’.
ERROR 1049 (42000): Unknown database ‘ecipescookbook.sql;’
從您提供的錯誤信息來看，導入過程中出現了幾個關鍵問題：

問題分析
字符編碼問題：

客戶端字符集是GBK，而服務器使用utf8mb4

這可能導致SQL文件中的某些特殊字符被錯誤解析

路徑解析錯誤：

錯誤顯示 Unknown database ‘ecipescookbook.sql;’，表明MySQL嘗試將您的SQL文件名的一部分當作數據庫名

轉義字符問題：

\M 和 \m 被當作MySQL命令，但實際可能是文件中的內容

解決方案
統一字符集：

sql
SET NAMES utf8mb4;
在導入前先執行這條命令，確保客戶端、連接和結果使用一致的字符集

使用完整路徑的正確格式：

Windows路徑中的反斜杠需要轉義或改為正斜杠：

sql
source D:/sql/MySQL_cookbook/mysqlcookbook-master/recipes/cookbook.sql
或

sql
source D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql
檢查文件內容：
用文本編輯器打開SQL文件，檢查開頭部分是否有異常內容或特殊字符

嘗試替代導入方法：

bash
mysql -u root -p cookbook --default-character-set=utf8mb4 < “D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql”
分塊導入：
如果文件很大，可以嘗試用文本編輯器分割成多個小文件分別導入

您能否提供SQL文件的開頭幾行內容？這樣我可以更準確地判斷問題所在。

-- Dump created by MySQL pump utility, version: 8.0.27, Linux (x86_64)
-- Dump start time: Mon Feb 14 02:25:01 2022
-- Server version: 8.0.27SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET @OLD_TIME_ZONE=@@TIME_ZONE;
SET TIME_ZONE='+00:00';
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8mb4;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cookbook` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

根據您提供的SQL文件開頭內容，這是一個由MySQL 8.0.27的pump工具創建的完整數據庫轉儲文件。結合之前的錯誤信息，以下是解決方案：

問題根源
字符集沖突：

文件指定了utf8mb4但客戶端使用gbk

導致特殊字符和轉義序列被錯誤解析

Windows路徑問題：

反斜杠被解釋為轉義字符

客戶端版本差異：

轉儲文件來自8.0.27(Linux)，您使用的是8.0.40(Windows)

完整解決方案
方法1：使用命令行導入（推薦）
cmd
mysql -u root -p --default-character-set=utf8mb4 cookbook < “D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql”
方法2：在MySQL客戶端中正確導入

先連接到MySQL：cmd
mysql -u root -p --default-character-set=utf8mb4
然后執行：sql
SET NAMES utf8mb4;
USE cookbook;
SOURCE D:/sql/MySQL_cookbook/mysqlcookbook-master/recipes/cookbook.sql;

方法3：修復環境變量
如果仍有問題，臨時修改客戶端字符集：

cmd
chcp 65001
mysql -u root -p --default-character-set=utf8mb4
重要提示
確保cookbook數據庫不存在或可以覆蓋：

sql
DROP DATABASE IF EXISTS cookbook;
CREATE DATABASE cookbook CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
如果文件很大(>100MB)，建議使用：

cmd
mysql -u root -p --max_allowed_packet=512M --default-character-set=utf8mb4 cookbook < “sql文件路徑”
檢查文件完整性：

確保文件沒有在Windows編輯器中意外被保存為UTF-8 with BOM格式

用十六進制編輯器檢查文件開頭是否有EF BB BF序列(BOM標記)

請嘗試以上方法后告知結果，如果仍有問題，可能需要檢查文件傳輸過程中是否損壞（比對MD5校驗值）。

mysql> show tables;
+-----------------------+
| Tables_in_cookbook    |
+-----------------------+
| actors                |
| adcount               |
| al_winner             |
| app_log               |
| artist                |
| book_authors          |
| book_vendor           |
| booksales             |
| catalog_list          |
| cd                    |
| city                  |
| color                 |
| cow_color             |
| cow_order             |
| date_val              |
| datetbl               |
| datetime_val          |
| die                   |
| doremi                |
| drawing               |
| driver_log            |
| expt                  |
| formula1              |
| goods_characteristics |
| goods_shops           |
| groceries             |
| groceries_order_items |
| hitcount              |
| hitlog                |
| hostip                |
| hostname              |
| housewares            |
| housewares2           |
| housewares3           |
| housewares4           |
| httpdlog              |
| httpdlog2             |
| hw_category           |
| image                 |
| ingredient            |
| insect                |
| inv_item              |
| invoice               |
| item                  |
| limbs                 |
| mail                  |
| mail_view             |
| marathon              |
| mark_log              |
| metal                 |
| money                 |
| movies                |
| movies_actors         |
| movies_actors_link    |
| mytable               |
| name                  |
| news                  |
| newsstaff             |
| numbers               |
| obs                   |
| occasion              |
| painting              |
| passtbl               |
| passwd                |
| patients              |
| perl_session          |
| person                |
| php_session           |
| phrase                |
| player_stats          |
| player_stats2         |
| poi                   |
| poll_vote             |
| profile               |
| profile_contact       |
| rainfall              |
| rand_names            |
| rank                  |
| ranks                 |
| reviews               |
| roster                |
| ruby_session          |
| sales_region          |
| sales_tax_rate        |
| sales_volume          |
| sibling               |
| some table            |
| standings1            |
| standings2            |
| states                |
| str_val               |
| sundays               |
| taxpayer              |
| testscore             |
| testscore_withmisses  |
| testscore_withmisses2 |
| time_val              |
| tmp                   |
| tomcat_role           |
| tomcat_session        |
| tomcat_user           |
| top_names             |
| trip_leg              |
| trip_log              |
| tsdemo                |
| weatherdata           |
| weekday               |
+-----------------------+
107 rows in set (0.00 sec)

小迪后續建議：
驗證數據完整性
可以簡單檢查幾個關鍵表，確保數據完整：

sql
USE cookbook;
SHOW TABLES; – 確認表數量
SELECT COUNT(*) FROM 某重要表; – 抽查數據量
字符集統一方案
為避免未來出現類似問題，可以在my.ini中添加：

ini
[client]
default-character-set=utf8mb4
備份小技巧
下次導出時建議使用：

bash
mysqldump -u root -p --default-character-set=utf8mb4 cookbook > backup.sql

https://blog.csdn.net/u011868279/category_11645577.html

``sql

D:\software\MySql\bin>mysql -u root -p cookbook < D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql
Enter password: ****
ERROR 1050 (42S01) at line 1073: Table 'limbs' already existsD:\software\MySql\bin>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.40 MySQL Community Server - GPLCopyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| cookbook           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)mysql> use cookbook
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_cookbook    |
+-----------------------+
| actors                |
| adcount               |
| al_winner             |
| app_log               |
| artist                |
| book_authors          |
| book_vendor           |
| booksales             |
| catalog_list          |
| cd                    |
| city                  |
| color                 |
| cow_color             |
| cow_order             |
| date_val              |
| datetbl               |
| datetime_val          |
| die                   |
| doremi                |
| drawing               |
| driver_log            |
| expt                  |
| formula1              |
| goods_characteristics |
| goods_shops           |
| groceries             |
| groceries_order_items |
| hitcount              |
| hitlog                |
| hostip                |
| hostname              |
| housewares            |
| housewares2           |
| housewares3           |
| housewares4           |
| httpdlog              |
| httpdlog2             |
| hw_category           |
| image                 |
| ingredient            |
| insect                |
| inv_item              |
| invoice               |
| item                  |
| limbs                 |
| mail                  |
| mail_view             |
| mytable               |
| profile               |
| profile_contact       |
| some table            |
| taxpayer              |
+-----------------------+
52 rows in set (0.00 sec)


mysql> source D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql;
--------------
mysql  Ver 8.0.40 for Win64 on x86_64 (MySQL Community Server - GPL)Connection id:          19
Current database:       cookbook
Current user:           root@localhost
SSL:                    Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter:        ;
Server version:         8.0.40 MySQL Community Server - GPL
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Binary data as:         Hexadecimal
Uptime:                 6 days 22 hours 53 min 31 secThreads: 2  Questions: 855  Slow queries: 0  Opens: 202  Flush tables: 3  Open tables: 120  Queries per second avg: 0.001
--------------ERROR:
Unknown command '\M'.
ERROR:
Unknown command '\m'.
ERROR 1049 (42000): Unknown database 'ecipescookbook.sql;'
從您提供的錯誤信息來看，導入過程中出現了幾個關鍵問題：問題分析
字符編碼問題：客戶端字符集是GBK，而服務器使用utf8mb4這可能導致SQL文件中的某些特殊字符被錯誤解析路徑解析錯誤：錯誤顯示 Unknown database 'ecipescookbook.sql;'，表明MySQL嘗試將您的SQL文件名的一部分當作數據庫名轉義字符問題：\M 和 \m 被當作MySQL命令，但實際可能是文件中的內容解決方案
統一字符集：sql
SET NAMES utf8mb4;
在導入前先執行這條命令，確保客戶端、連接和結果使用一致的字符集使用完整路徑的正確格式：Windows路徑中的反斜杠需要轉義或改為正斜杠：sql
source D:/sql/MySQL_cookbook/mysqlcookbook-master/recipes/cookbook.sql
或sql
source D:\\sql\\MySQL_cookbook\\mysqlcookbook-master\\recipes\\cookbook.sql
檢查文件內容：
用文本編輯器打開SQL文件，檢查開頭部分是否有異常內容或特殊字符嘗試替代導入方法：bash
mysql -u root -p cookbook --default-character-set=utf8mb4 < "D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql"
分塊導入：
如果文件很大，可以嘗試用文本編輯器分割成多個小文件分別導入您能否提供SQL文件的開頭幾行內容？這樣我可以更準確地判斷問題所在。-- Dump created by MySQL pump utility, version: 8.0.27, Linux (x86_64)
-- Dump start time: Mon Feb 14 02:25:01 2022
-- Server version: 8.0.27SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET @OLD_TIME_ZONE=@@TIME_ZONE;
SET TIME_ZONE='+00:00';
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8mb4;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cookbook` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
根據您提供的SQL文件開頭內容，這是一個由MySQL 8.0.27的pump工具創建的完整數據庫轉儲文件。結合之前的錯誤信息，以下是解決方案：問題根源
字符集沖突：文件指定了utf8mb4但客戶端使用gbk導致特殊字符和轉義序列被錯誤解析Windows路徑問題：反斜杠被解釋為轉義字符客戶端版本差異：轉儲文件來自8.0.27(Linux)，您使用的是8.0.40(Windows)完整解決方案
方法1：使用命令行導入（推薦）
cmd
mysql -u root -p --default-character-set=utf8mb4 cookbook < "D:\sql\MySQL_cookbook\mysqlcookbook-master\recipes\cookbook.sql"
方法2：在MySQL客戶端中正確導入
先連接到MySQL：cmd
mysql -u root -p --default-character-set=utf8mb4
然后執行：sql
SET NAMES utf8mb4;
USE cookbook;
SOURCE D:/sql/MySQL_cookbook/mysqlcookbook-master/recipes/cookbook.sql;
方法3：修復環境變量
如果仍有問題，臨時修改客戶端字符集：cmd
chcp 65001
mysql -u root -p --default-character-set=utf8mb4
重要提示
確保cookbook數據庫不存在或可以覆蓋：sql
DROP DATABASE IF EXISTS cookbook;
CREATE DATABASE cookbook CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
如果文件很大(>100MB)，建議使用：cmd
mysql -u root -p --max_allowed_packet=512M --default-character-set=utf8mb4 cookbook < "sql文件路徑"
檢查文件完整性：確保文件沒有在Windows編輯器中意外被保存為UTF-8 with BOM格式用十六進制編輯器檢查文件開頭是否有EF BB BF序列(BOM標記)請嘗試以上方法后告知結果，如果仍有問題，可能需要檢查文件傳輸過程中是否損壞（比對MD5校驗值）。```sql
mysql> show tables;
+-----------------------+
| Tables_in_cookbook    |
+-----------------------+
| actors                |
| adcount               |
| al_winner             |
| app_log               |
| artist                |
| book_authors          |
| book_vendor           |
| booksales             |
| catalog_list          |
| cd                    |
| city                  |
| color                 |
| cow_color             |
| cow_order             |
| date_val              |
| datetbl               |
| datetime_val          |
| die                   |
| doremi                |
| drawing               |
| driver_log            |
| expt                  |
| formula1              |
| goods_characteristics |
| goods_shops           |
| groceries             |
| groceries_order_items |
| hitcount              |
| hitlog                |
| hostip                |
| hostname              |
| housewares            |
| housewares2           |
| housewares3           |
| housewares4           |
| httpdlog              |
| httpdlog2             |
| hw_category           |
| image                 |
| ingredient            |
| insect                |
| inv_item              |
| invoice               |
| item                  |
| limbs                 |
| mail                  |
| mail_view             |
| marathon              |
| mark_log              |
| metal                 |
| money                 |
| movies                |
| movies_actors         |
| movies_actors_link    |
| mytable               |
| name                  |
| news                  |
| newsstaff             |
| numbers               |
| obs                   |
| occasion              |
| painting              |
| passtbl               |
| passwd                |
| patients              |
| perl_session          |
| person                |
| php_session           |
| phrase                |
| player_stats          |
| player_stats2         |
| poi                   |
| poll_vote             |
| profile               |
| profile_contact       |
| rainfall              |
| rand_names            |
| rank                  |
| ranks                 |
| reviews               |
| roster                |
| ruby_session          |
| sales_region          |
| sales_tax_rate        |
| sales_volume          |
| sibling               |
| some table            |
| standings1            |
| standings2            |
| states                |
| str_val               |
| sundays               |
| taxpayer              |
| testscore             |
| testscore_withmisses  |
| testscore_withmisses2 |
| time_val              |
| tmp                   |
| tomcat_role           |
| tomcat_session        |
| tomcat_user           |
| top_names             |
| trip_leg              |
| trip_log              |
| tsdemo                |
| weatherdata           |
| weekday               |
+-----------------------+
107 rows in set (0.00 sec)

后續建議：
驗證數據完整性
可以簡單檢查幾個關鍵表，確保數據完整：

sql
USE cookbook;
SHOW TABLES; – 確認表數量
SELECT COUNT(*) FROM 某重要表; – 抽查數據量
字符集統一方案
為避免未來出現類似問題，可以在my.ini中添加：

ini
[client]
default-character-set=utf8mb4
備份小技巧
下次導出時建議使用：

bash
mysqldump -u root -p --default-character-set=utf8mb4 cookbook > backup.sql

https://blog.csdn.net/u011868279/category_11645577.html