Navigate to the MySQL binary directory and run the dump:
cd C:\laragon\bin\mysql\mysql-8.4.3-winx64\bin
.\mysqldump.exe -u root -p --default-character-set=latin1 dbname > dump.sql
Using
latin1here avoids double-encoding issues during export from a Latin1-encoded database.
Open dump.sql and replace:
/*!50503 SET NAMES latin1 */;
with:
/*!50503 SET NAMES utf8mb4 */;
Then import the corrected dump into the target database.
Recommended: For WordPress sites, use the UpdraftPlus plugin for backup and restore instead.
Upload backup files via SSH towp-content/updraft/, install the UpdraftPlus plugin, and restore from there.