/
collatedb
23 lines (20 loc) · 1.08 KB
/
collatedb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#!/bin/sh
#Copyright ABDENNOUR TOUMI 2013
# change all tables and fields collation in MYSQL
# collatedb.sh root 0000 mydb utf8_unicode_ci
#********************************************************
#This program is free software: you can redistribute it and/or modify
#it under the terms of the GNU General Public License as published by
#the Free Software Foundation, either version 3 of the License, or
#(at your option) any later version.
#This program is distributed in the hope that it will be useful,
#but WITHOUT ANY WARRANTY; without even the implied warranty of
#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
#GNU General Public License for more details.
#You should have received a copy of the GNU General Public License
#along with this program. If not, see <http://www.gnu.org/licenses/>.
u=$1;
p=$2;
d=$3;
c=$4;
mysql --user=$u --password=$p --database=$d -B -N -e "SHOW TABLES" | awk '{print "SET foreign_key_checks = 0; ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE '$c'; SET foreign_key_checks = 1; "}' | mysql --user=$u --password=$p --database=$d &