I hereby claim:
- I am tony4d on github.
- I am tony4d (https://keybase.io/tony4d) on keybase.
- I have a public key whose fingerprint is 3F64 5B71 C70B 4BFE 5E2A D205 2AEC 93AD 5C92 5CAC
To claim this, I am signing this object:
#!/bin/bash | |
# To avoid doing things like putting your mysql password on the cli which is not secure | |
# Use mysql config editor http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html | |
for table in $(mysql --login-path=mylogins -D database_name -Bse "show tables"); | |
do mysql --login-path=mylogins -D database_name -Bse "analyze table $table"; | |
done |
# Assumptions: | |
# - You are using rbenv, installed in ~/.rbenv | |
# - You are using homebrew | |
# - You want to install ruby 2.1.2 (for example) | |
# | |
# Make sure you have openssl installed first | |
brew install openssl | |
# Before you begin, download ruby source from https://www.ruby-lang.org/en/downloads/ |
I hereby claim:
To claim this, I am signing this object:
#!/bin/bash | |
# No username or passwords in this script, you should use mysql_config_editor | |
# to store it securely. The login-path in this script is set to "local-backup" so when you create | |
# your .mylogin.cnf with the mysql-config-editor make sure it is set the same | |
# See http://dev.mysql.com/doc/refman/5.6/en/mysql-config-editor.html | |
# An example to create your config for a mysql user "backup": | |
# shell> sudo mysql_config_editor set --login-path=local-backup --host=localhost --user=backup --password | |
# The backup user in the mysql server needs these privileges: SELECT, RELOAD, SHOW DATABASES, REPLICATION CLIENT |
mysqldump -u [user] -p -xQce -R --master-data=2 --max-allowed-packet=1024M -B [db_name] | gzip > [db_name].sql.gz |
# first download and install virtual box | |
curl -O http://download.virtualbox.org/virtualbox/4.2.12/VirtualBox-4.2.12-84980-OSX.dmg | |
# Then install ie8, 9 & 10 vms | |
curl -s https://raw.github.com/xdissent/ievms/master/ievms.sh | env IEVMS_VERSIONS="8 9 10" bash |
mysqldump -u [user_name] -p -Qce --max-allowed-packet=1024M -B [database_name] > database_name.sql |
<?php | |
/* | |
exit codes: | |
0 - everything ok. | |
1 - failure to connect | |
*/ | |
if ( ! extension_loaded('memcache') ) { | |
die("memcache pecl module is not available. Please install a STABLE version from http://pecl.php.net/package/memcache"); | |
} |
Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0; Xbox) |