mysqladmin -u root -p  create database cert
mysqladmin -u root -p  drop database cert


/* mysqldump */
`date +/tmp/cert.%Y%m%d.%H%M%S.sql` 
mysqldump -u root -p cert406 > `date +/opt/kck-tomcat-7.0.16/temp/cert406-%d-%m-%Y.sql` 
mysqldump -u root -p cert > `date +/opt/kck-tomcat-7.0.16/temp/cert-%d-%m-%Y.sql` 
mysqldump --no-data -u root -p cert > /tmp/certSchema.sql


/* ALTER */
USE `cert`;
ALTER TABLE `RequestFNS` ADD name varchar(500) DEFAULT '' ;
ALTER TABLE `RequestFNS` DROP `name`;

 

 

How to convert a MySQL database to UTF-8 encoding

SELECT * FROM information_schema.SCHEMATA WHERE schema_name = "pec";
ALTER DATABASE pec CHARACTER SET utf8 COLLATE utf8_general_ci;

 https://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf-8-in-my-cnf

 http://gahcep.github.io/blog/2013/01/05/mysql-utf8/

[mysqld] 
sql_mode=''

init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8' 
character-set-server=utf8 
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake



show variables like "%character%";show variables like "%collation%";

 

 

CREATE TABLE IF NOT EXISTS `boot`.`log` (
  `id` INT(11)  NULL AUTO_INCREMENT,
  `addr` VARCHAR(200) NULL DEFAULT NULL,
  `name` VARCHAR(200) NULL DEFAULT NULL,
  `date` DATETIME NULL DEFAULT NULL,
  `json` text NULL DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci
;



CREATE TABLE IF NOT EXISTS `boot`.`log` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `goup_id` INT(11) NOT NULL,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`goup_id`, `id`),
  INDEX `fk_participant_goup_idx` (`goup_id` ASC),
  CONSTRAINT `fk_participant_goup`
    FOREIGN KEY (`goup_id`)
    REFERENCES `test`.`goup` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci