Takashi Nojima nojimage

## content.md

      
              1 file
            
          
              0 forks
            
          
              2 comments
            
          
              0 stars
            
          
                nojimage
                / content.md
            
            
              Last active
              May 25, 2022 01:30
            
              
                MariaDBのダンプをMySQL Workbenchで取る方法
              
          
      View content.md
  
      
    参考（Windowsとかはこっち）:

How to disable column-statistics in MySQL 8 permanently? - Stack Overflow
MYSQL WORKBENCH vs MARIADB problem in data export - Stack Overflow

前提

MySQL Workbench 8.0.29
macOS
mysqldump (Homebrew で入れた MySQL 8.0に付属しているもの)
エクスポートしようとすると、「COLUMN_STATISTICSテーブルがない」とかで怒られる


## gearman-code-completion.php
<?php

/**
 * for code completion
 *
 * @link http://docs.php.net/manual/en/book.gearman.php
 */
if (false) {

    define('GEARMAN_SUCCESS', 0);

## session_acl_component.php
<?php

/**
 * AclComponent using Session Cache for CakePHP 1.3
 *
 * Copyright 2011, nojimage (http://php-tips.com/)
 *
 * Licensed under The MIT License
 * Redistributions of files must retain the above copyright notice.
 *

## xdebug-3-upgrade-guide.ja.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              2 stars
            
          
                nojimage
                / xdebug-3-upgrade-guide.ja.md
            
            
              Last active
              December 29, 2020 00:26
            
              
                Xdebug 3 アップグレードガイド
              
          
      View xdebug-3-upgrade-guide.ja.md
  
      
    Xdebug 3 アップグレードガイド
原文: https://xdebug.org/docs/upgrade_guide
Xdebug 2 から 3 へのアップグレード

An upgrade guide detailing which changes there are between Xdebug 2 and 3, and how to reconfigure your set-up to do similar things.

このアップグレードガイドは、Xdebug 2から3への変更点と、同様のことを行うようにセットアップを再構成する方法を詳しく説明します。

  
## index.html
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>jQuery Justify</title>
<script type="text/javascript" src="js/jquery.1.3.2.min.js"></script>
<script type="text/javascript" src="js/jquery.justify.js"></script>
<script type="text/javascript">
$(document).ready(function(){

## 01-instration
sudo port install gearmand +drizzle
sudo port install php5-gearman
sudo vim /Library/LaunchDaemons/org.macports.gearmand.plist

## init-vmware-catalina.sh
#!/bin/sh

#
# Running on macOS Recovery Mode Terminal
#
# 1. Save this script to Your home dir.
#    eg) /Users/your-name/init-vmware-catalina.sh
#
# 2. Restart the machine and go to Recovery Mode.
#    (hold [⌘ + R] when the computer starts until you see an Apple logo)

## AppModel.php
class AppModel extends Model {
	/**
	 * set SQL_CALC_FOUND_ROWS for MySQL
	 *
	 * @param array $conditions
	 * @param array $fields
	 * @param array $order
	 * @param int $limit
	 * @param int $page
	 * @param int $recursive

## build.sh
## install openssl 1.0.2t
cd /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/
git checkout 8b9d6d688f483a0f33fcfc93d433de501b9c3513 -- openssl.rb
brew install openssl

## build php: "/usr/local/Cellar/icu4c/64.2" is a specific icu4c version.
LDFLAGS=-L/usr/local/Cellar/icu4c/64.2 \
CONFIGURE_OPTS="--with-pear --with-openssl=/usr/local/Cellar/openssl/1.0.2t --with-icu-dir=/usr/local/Cellar/icu4c/64.2" \
phpenv install 5.6.40

## rector.sh

docker run --rm -v "$(pwd)":/app -w /app --entrypoint /rector/bin/rector rector/rector process src --dry-run
	<?php

	/**
	* for code completion
	*
	* @link http://docs.php.net/manual/en/book.gearman.php
	*/
	if (false) {

	define('GEARMAN_SUCCESS', 0);
	<?php

	/**
	* AclComponent using Session Cache for CakePHP 1.3
	*
	* Copyright 2011, nojimage (http://php-tips.com/)
	*
	* Licensed under The MIT License
	* Redistributions of files must retain the above copyright notice.
	*
	<?xml version="1.0" encoding="UTF-8" ?>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title>jQuery Justify</title>
	<script type="text/javascript" src="js/jquery.1.3.2.min.js"></script>
	<script type="text/javascript" src="js/jquery.justify.js"></script>
	<script type="text/javascript">
	$(document).ready(function(){
	sudo port install gearmand +drizzle
	sudo port install php5-gearman
	sudo vim /Library/LaunchDaemons/org.macports.gearmand.plist
	#!/bin/sh

	#
	# Running on macOS Recovery Mode Terminal
	#
	# 1. Save this script to Your home dir.
	# eg) /Users/your-name/init-vmware-catalina.sh
	#
	# 2. Restart the machine and go to Recovery Mode.
	# (hold [⌘ + R] when the computer starts until you see an Apple logo)
	class AppModel extends Model {
	/**
	* set SQL_CALC_FOUND_ROWS for MySQL
	*
	* @param array $conditions
	* @param array $fields
	* @param array $order
	* @param int $limit
	* @param int $page
	* @param int $recursive
	## install openssl 1.0.2t
	cd /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/
	git checkout 8b9d6d688f483a0f33fcfc93d433de501b9c3513 -- openssl.rb
	brew install openssl

	## build php: "/usr/local/Cellar/icu4c/64.2" is a specific icu4c version.
	LDFLAGS=-L/usr/local/Cellar/icu4c/64.2 \
	CONFIGURE_OPTS="--with-pear --with-openssl=/usr/local/Cellar/openssl/1.0.2t --with-icu-dir=/usr/local/Cellar/icu4c/64.2" \
	phpenv install 5.6.40

	docker run --rm -v "$(pwd)":/app -w /app --entrypoint /rector/bin/rector rector/rector process src --dry-run