Skip to content

Instantly share code, notes, and snippets.

View teej2542's full-sized avatar

Tim Millett teej2542

View GitHub Profile
@iamcryptoki
iamcryptoki / export-restore-kubernetes-mysql-database.txt
Created November 5, 2019 13:28
Export MySQL database from Kubernetes pod.
# 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
@spalladino
spalladino / mysql-docker.sh
Created December 22, 2015 13:47
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
@double16
double16 / build.gradle
Last active July 11, 2024 13:13
Gradle task to collect JUnit test results into a CSV, makes your manager happier, they like Excel ;)
task collectResults() {
def output = file("build/reports/summary.csv")
doLast {
file("build/reports").mkdirs()
output.text = '"Project","Test","Time","Result","Duration"\r\n'
allprojects.each { project2 ->
logger.info("Processing project ${project2.name}")
def resultFiles = project2.fileTree("build") { include '**/TEST-*.xml' }
resultFiles.each { file ->
logger.info("Processing report ${file}")