John Rickerd jrickerd

## gist:2852383
mysqldump -u root -d -R --single-transaction <db> | sed 's/ AUTO_INCREMENT=[0-9]*\b//' | gzip > out.sql.gz

## gist:2252267
mysqldbcopy bis:bis --source=u:p@host1 --destination=u:p@host1 --force

## gist:1961461
# display php errors
php_flag display_errors on

# turn off caching
php_flag apc.cache_by_default Off

# log rewrites
RewriteLog "/home/rob4/www/logs/rewrite.log"
RewriteLogLevel 3

## gist:1925505
wget http://nodejs.tchol.org/repocfg/el/nodejs-stable-release.noarch.rpm
sudo yum localinstall --nogpgcheck ./nodejs-stable-release.noarch.rpm
sudo yum install nodejs

## gist:1913353

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jrickerd
                / gist:1913353
            
            
              Created
              February 26, 2012 05:17
            
              
                curl commands
              
          
    post

curl -X POST -H  -d<this=that> 
easier post

curl -d  
post form

curl -F<name=content> 
data GET


## gist:1904339
grant all on mp.* to itrans@'10.%.%.%' identified by '';

## gist:1866299
php -i | clip.exe

paste into http://xdebug.org/find-binary.php

## gist:1713441
#
# Create Sonar database and user.
#
# Command: mysql -u root -p < create_database.sql
#

CREATE DATABASE name CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'user' IDENTIFIED BY 'user';
GRANT ALL ON name.* TO 'user'@'%' IDENTIFIED BY 'user';

## gist:1648272
DROP PROCEDURE IF EXISTS ANALYZE_INVALID_FOREIGN_KEYS$$

CREATE
    PROCEDURE `ANALYZE_INVALID_FOREIGN_KEYS`(
        checked_database_name VARCHAR(64),
        checked_table_name VARCHAR(64),
        temporary_result_table ENUM('Y', 'N'))

    LANGUAGE SQL
    NOT DETERMINISTIC

## gist:1636768
call analyze_invalid_foreign_keys('<database>', '%', 'N');
select * from invalid_foreign_keys;
	# display php errors
	php_flag display_errors on

	# turn off caching
	php_flag apc.cache_by_default Off

	# log rewrites
	RewriteLog "/home/rob4/www/logs/rewrite.log"
	RewriteLogLevel 3
	wget http://nodejs.tchol.org/repocfg/el/nodejs-stable-release.noarch.rpm
	sudo yum localinstall --nogpgcheck ./nodejs-stable-release.noarch.rpm
	sudo yum install nodejs
	php -i \| clip.exe

	paste into http://xdebug.org/find-binary.php
	#
	# Create Sonar database and user.
	#
	# Command: mysql -u root -p < create_database.sql
	#

	CREATE DATABASE name CHARACTER SET utf8 COLLATE utf8_general_ci;

	CREATE USER 'user' IDENTIFIED BY 'user';
	GRANT ALL ON name.* TO 'user'@'%' IDENTIFIED BY 'user';
	DROP PROCEDURE IF EXISTS ANALYZE_INVALID_FOREIGN_KEYS$$

	CREATE
	PROCEDURE `ANALYZE_INVALID_FOREIGN_KEYS`(
	checked_database_name VARCHAR(64),
	checked_table_name VARCHAR(64),
	temporary_result_table ENUM('Y', 'N'))

	LANGUAGE SQL
	NOT DETERMINISTIC
	call analyze_invalid_foreign_keys('<database>', '%', 'N');
	select * from invalid_foreign_keys;