vladdancer/fix_db_collation.sh

Created June 18, 2024 12:51

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vladdancer/a7cd8a4b92d38cb2654099000a8d3558.js"></script>
Save vladdancer/a7cd8a4b92d38cb2654099000a8d3558 to your computer and use it in GitHub Desktop.

Download ZIP

Fix Unknown collation: 'utf8mb4_0900_ai_ci'

Raw

fix_db_collation.sh

	# Sed syntax for macOS
	sed -i '' 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' your_sql_file.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment