Конвертируем все таблицы в UTF8 mysql

09.08.2015

<

pre> mysql –user=username –password=your_pass –database=dbname -B -N -e “SHOW TABLES” | awk ’{print “ALTER TABLE”, $1, “CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;”}’ | mysql –user=username –password=your_pass –database=dbname &

<

pre>

#MySQL‏‎