Exportieren:
mysqldump --opt -Q -u root lac_bild > lc_dump.sql
Konvertieren
iconv --from-code=ISO-8859-1 --to-code=UTF-8 ./db_dump_from.sql > ./db_dump_to.sql
Importieren:
mysql db_name < ./db_dump_to.sql -u root -p
Exportieren:
mysqldump --opt -Q -u root lac_bild > lc_dump.sql
Konvertieren
iconv --from-code=ISO-8859-1 --to-code=UTF-8 ./db_dump_from.sql > ./db_dump_to.sql
Importieren:
mysql db_name < ./db_dump_to.sql -u root -p
Zeige aktuelle Logging Einstellung
show variables LIKE 'general_log';
Zeige alle verfügbaren Variablen
show variables;
Verwendete Logfile
show variables LIKE 'general_log_file';
Aktivieren des Loggings
SET GLOBAL general_log = 'ON';
Deaktivieren des Loggings
SET GLOBAL general_log = 'OFF';
Sources:
Install mysql repo and disable it by default:
rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm sed -i s'/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo
Install mysql 5.6
yum -y --enablerepo=mysql56-community install mysql-server
Add the following in your my.cnf [mysqld] section:
skip-grant-tables