Import mysql DB with XAMPP in command LINE shell

mysql -u root -p db_name < "C:\folder_name\db_name.sql"

Importing database: Unknown collation: 'utf8mb4_0900_ai_ci' 


Open dump.sql file in Notepad++ and hit CTRL+H to find and replace the string "utf8mb4_0900_ai_ci" and replaced it with "utf8mb4_general_ci".