Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DB="mistraldb"
- USER="root"
- PASS=""
- (
- echo 'ALTER DATABASE `'"$DB"'` CHARACTER SET utf8 COLLATE utf8_general_ci;'
- mysql -p$PASS -u $USER "$DB" -e "SHOW TABLES" --batch --skip-column-names \
- | xargs -I{} echo 'ALTER TABLE `'{}'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;'
- ) \
- | mysql -p$PASS -u $USER "$DB"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement