How to change all columns' and tables' collation to 'utf8

How to change all columns' and tables' collation to 'utf8_bin' in MySQL

Run The following Command

SELECT * FROM information_schema.COLUMNS WHERE table_schema = '<dbname>' AND collation_name != 'utf8_bin';

SELECT * FROM information_schema.COLUMNS WHERE table_schema = '<dbname>' AND collation_name != 'utf8_bin' \G;

use <dbname>;

SET foreign_key_checks = 0;

ALTER TABLE <table name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

SET foreign_key_checks = 1;

Note: for more detail info visit following link
https://confluence.atlassian.com/jirakb/how-to-change-all-columns-and-tables-collation-to-utf8_bin-in-mysql-601456761.html

Comments

Understanding the dm-multipath Configuration file /etc/multipath.conf #centos7

Understanding the dm-multipath Configuration file /etc/multipath.conf The main configuration file for DM-Multipath is /etc/multipath.conf . This file is not created by the initial installation of the RPM package. However, the following file is installed in the /usr/share/doc/device-mapper-multipath-[version] directory: multipath.conf – Basic configuration file with some examples for DM-Multipath. This file is used to create the /etc/multipath.conf file. Sample /etc/multipath.conf file The multipath.conf file contains the following sections, and each section contains one or more attributes or subsections. Section Description defaults Defines the default settings for DM-Multipath. These settings can be overwritten by the devices and multipaths sections. blacklist Defines the devices to be excluded from the multipath topology discovery. Devices that are blacklisted are not grouped into a multipath device. blacklist_exceptions Defines the devices to ...

upload file type rocket chat #Accepted file upload. Can not send .xlsx

Enabling File format for upload at ROCKET CHAT application/msword - for .doc application/vnd.openxmlformats-officedocument.wordprocessingml.document - for .docx application/vnd.ms-excel - for xls application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - for .xlsx application/vnd.ms-powerpoint - for .ppt application/vnd.openxmlformats-officedocument.presentationml.presentation - for .pptx image/*,audio/*,video/*,application/zip,application/x-rar-compressed,application/pdf,text/plain,application/msword,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Troubleshooting DRBD #Centos #DRBD

Troubleshooting DRBD This article presents common DRBD problems and solutions. DRBD (Distributed Replicated Block Device) runs on the master and slave nodes only, and is responsible for mirroring the contents of a partition between master and slave. Typical problems in DRBD include: A lack of Primary-Secondary connectivity The Secondary operating in standalone mode Both nodes reporting connectivity but neither one in the role of master Both nodes reporting themselves in the role of master Verify the DRBD status The following command is used to verify that DRBD is operating normally on the master and slave nodes. drbd-overview When run on the master node, the output should look like the following: 1:r0/0 Connected Primary/Secondary UpToDate/UpToDate C r----- /mnt/drbd ... When run on the slave node, the output should look like the following: 1:r0/0 Connected Secondary/Primary UpToDate/UpToDate C r----- The following sections are exampl...

Linux/ Centos7/ Tech Info

Search This Blog