This is a Chinese version of https://gist.github.com/1207002/86f48cd3b3b72c85e6293926cf7c730de03b2f08 from lucasfais
| ⌘T | 前往文件 |
| ⌘⌃P | 前往项目 |
| ⌘R | 前往 method |
| ⌘⇧P | 命令提示 |
perfectfoolish
/ command.txt
Created
July 28, 2021 08:57
solve forget the root password of mysql installed by homebrew on macOS
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ brew services stop mysql | |
| $ pkill mysqld | |
| $ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!! | |
| $ brew postinstall mysql | |
| $ brew services restart mysql | |
| $ mysql -uroot |
perfectfoolish
/ export-restore-kubernetes-mysql-database.txt
Created
July 9, 2021 07:31
— forked from iamcryptoki/export-restore-kubernetes-mysql-database.txt
Export MySQL database from Kubernetes pod.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Export dump particular database. | |
| $ kubectl exec {{podName}} -n {{namespace}} -- mysqldump -u {{dbUser}} -p{{password}} {{DatabaseName}} > <scriptName>.sql | |
| # Export dump all databases. | |
| $ kubectl exec {{podName}} -n {{namespace}} -- mysqldump -u {{dbUser}} -p{{password}} --all-databases > <scriptName>.sql | |
| # Restore a database from a dump. | |
| $ kubectl exec -it {{podName}} -n {{namespace}} -- mysql -u {{dbUser}} -p{{password}} {{DatabaseName}} < <scriptName>.sql |
perfectfoolish
/ JdkSpecificVersion.groovy
Last active
September 22, 2017 06:19
Use the env.JAVA_HOME environment variable to specify the JDK to use as shown in the Pipeline snippet below:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| node { | |
| // https://support.cloudbees.com/hc/en-us/articles/115001595227-How-To-Specify-A-Specific-JDK-In-Pipeline- | |
| // configure the JDK in Manage Jenkins > Global Tool Configuration > JDK | |
| jdk = tool name: 'JDK17' | |
| env.JAVA_HOME = "${jdk}" | |
| echo "jdk installation path is: ${jdk}" | |
| // next 2 are equivalents | |
| sh "${jdk}/bin/java -version" |
perfectfoolish
/ find-all-branches.groovy
Last active
September 6, 2017 10:41
Install 'Extended Choice Parameter Plug-In', then selected 'Basic Parameter Types', input 'Number of Visible Items' with 100 and 'Delimiter' with ',', selected Groovy Script and input this script.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def gitURL = "[email protected]:xxxxx.git" | |
| def command = "git ls-remote -h $gitURL" | |
| def proc = command.execute() | |
| proc.waitFor() | |
| if ( proc.exitValue() != 0 ) { | |
| return ["develop", "master"] | |
| } |
perfectfoolish
/ autopgsqlbackup
Created
September 23, 2016 08:49
— forked from matthewlehner/autopgsqlbackup
Auto PostgreSQL backup script.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # PostgreSQL Backup Script Ver 1.0 | |
| # http://autopgsqlbackup.frozenpc.net | |
| # Copyright (c) 2005 Aaron Axelsen <[email protected]> | |
| # | |
| # This script is based of the AutoMySQLBackup Script Ver 2.2 | |
| # It can be found at http://sourceforge.net/projects/automysqlbackup/ | |
| # | |
| # The PostgreSQL changes are based on a patch agaisnt AutoMySQLBackup 1.9 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| user nginx; | |
| worker_processes auto; | |
| error_log /var/log/nginx/error.log; | |
| pid /var/run/nginx.pid; | |
| events { | |
| worker_connections 1024; | |
| } | |
| http { |
perfectfoolish
/ stop_server.sh
Created
February 19, 2016 07:42
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| isExistApp=`ps -ef|grep data-jar-with-dependencies.jar|grep -v grep|awk '{print $2}'` | |
| if [[ -n $isExistApp ]]; then | |
| kill -9 $isExistApp | |
| echo 'app stopped' | |
| fi |
perfectfoolish
/ stop_server.sh
Created
February 18, 2016 03:54
https://akaedu.github.io/book/ch31s05.html
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| isExistApp = `pgrep httpd` | |
| if [[ -n $isExistApp ]]; then | |
| service httpd stop | |
| fi |
perfectfoolish
/ gist:39c9fd8c15b41f787e82
Last active
August 29, 2015 14:27
— forked from lucifr/gist:1208100
Sublime Text 2 - 实用快捷键 (Mac OS X)
perfectfoolish
/ gist:c28f04a973343b91fd50
Last active
August 29, 2015 14:27
— forked from lucasfais/gist:1207002
Sublime Text 2 - Useful Shortcuts
NewerOlder