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) |