k12u

vagrant@ubuntu:/tmp$ docker run -d --name=test -e MYSQL_DATABASE=db -e MYSQL_ROOT_PASSWORD=pass -p 3307:3306 mysql
83a04cde686930ad72df76df5d2662ed927c901867c4e4562b18841a49140aa3
vagrant@ubuntu:/tmp$ docker exec test cat /var/lib/mysql/db/db.opt
default-character-set=latin1
default-collation=latin1_swedish_ci

k12u

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

k12u

[root@ip-10-120-94-184 php55]# env LANG=C yum install php55u-pecl-jsonc.x86_64
Loaded plugins: priorities, update-motd, upgrade-helper
49 packages excluded due to repository priority protections
Resolving Dependencies
--> Running transaction check
---> Package php55u-pecl-jsonc.x86_64 0:1.3.5-1.ius.centos6 will be installed
--> Processing Dependency: /usr/bin/pecl for package: php55u-pecl-jsonc-1.3.5-1.ius.centos6.x86_64
--> Processing Dependency: /usr/bin/pecl for package: php55u-pecl-jsonc-1.3.5-1.ius.centos6.x86_64
--> Running transaction check
---> Package php55u-pear.noarch 1:1.9.4-20.ius.centos6 will be installed

k12u

VAGRANTFILE_API_VERSION = "2"

Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
  config.vm.box = "base"

  config.vm.box_url = "http://opscode-vm-bento.s3.amazonaws.com/vagrant/virtualbox/opscode_centos-6.5_chef-provisionerless.box"
  config.vm.network "forwarded_port", guest: 80, host: 8080
  config.vm.network "private_network", ip: "192.168.33.10"

  config.vm.synced_folder ".", "/var/www/html"

k12u

[vagrant@localhost setup]$ gem install chef --version 11.10
ERROR:  While executing gem ... (Gem::RemoteFetcher::FetchError)
    bad response Service Unavailable 503 (https://api.rubygems.org/api/v1/dependencies?gems=highline)
[vagrant@localhost setup]$ gem install chef --version 11.10

^CERROR:  Interrupted
[vagrant@localhost setup]$ gem install chef --version 11.10
ERROR:  While executing gem ... (Gem::RemoteFetcher::FetchError)
    bad response Service Unavailable 503 (https://api.rubygems.org/api/v1/dependencies?gems=puma)
[vagrant@localhost setup]$ gem install chef --version 11.10

k12u

 mysql -uroot dbname -S `ls -1t /var/folders/*/*/-TMP-/*/tmp/mysql.sock  |head -1`

k12u

# dbserver から new_serverへのコピー
$ mysqldump -t -n --compact -hdbserver -uuser_id \
  db_name table_name -w 'row_id = 111' \
  | mysql -hnew_server -uuser_id

k12u

$ mysqldump -t -n --compact -hdbserver -uuser_id \
  db_name table_name -w 'row_id = 111'

--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES (ry
--
INSERT INTO `table_name` VALUES (111,0,0,0);

k12u

$ ps -ef -E |grep ssh-a[g]ent  | perl -lne 'm/SSH_AUTH_SOCK=([^ ]+)/;print $1'
/tmp/launch-aaaaaa/Listeners

k12u

mysql> show create table m\G
*************************** 1. row ***************************
       Table: m
Create Table: CREATE TABLE `m` (
  `id` int(11) NOT NULL,
  `status` varchar(64) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)