Skip to content

Instantly share code, notes, and snippets.

@rathorevaibhav

rathorevaibhav/macos-windows.sql

Created July 13, 2022 06:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rathorevaibhav/f1131a4ab66bf9ae804422ff068d5f78 to your computer and use it in GitHub Desktop.
Save rathorevaibhav/f1131a4ab66bf9ae804422ff068d5f78 to your computer and use it in GitHub Desktop.
Download ZIP
Transforms SQL export from macOS to import into Windows
Raw
macos-windows.sql
-- changing charset and utf types for macOS to Windows import
sed -i '' 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' db.sql
sed -i '' 's/CHARSET=utf8mb4/CHARSET=utf8/g' db.sql
sed -i '' 's/utf8mb4_unicode_520_ci/utf8_general_ci/g' db.sql
sed -i '' 's/utf8mb4/utf8/g' db.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment