MySQL

Datenbanken konvertieren

Phpwebgallery 1.3.2 nach Piwigo 2.3.3

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

TYPO3 Latin1 nach UTF8

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

MYSQL query logging

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';

CentOS 5.6 install mysql 5.6

Sources:

• http://www.servermule.com.au/help/linux/install-lemp-mysql-5-6-centos-6/
• http://bugs.mysql.com/bug.php?id=70431

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