mysql |

MySQL workbench on Ubuntu 20

Jun 11, 2020 · 1 min read · MYSQL UBUNTU UBUNTU-20 ·

Snap \ Apparmour aaagh 1sudo snap connect mysql-workbench-community:password-manager-service :password-manager-service

MYSQL Backup to S3 script

Sep 18, 2019 · 1 min read · linux mysql ·

Script #!/bin/bash # Set the enviroment variable so read function knows to seperate on ",". export IFS="," NOW=$(date +"%Y_%m_%d_%H_%M") DATABASES_CONFIG_FILE="/home/bfnadmin/databases.csv" S3_ENDPOINT="https://my-s3-storage.com" S3_BUCKET="s3://sql-backups" TEMP_BACKUP_DIR="backups" while read HOST USERNAME PASSWORD …

Openstack Queens - Cinder: Deleting volumes using Mysql

Apr 24, 2018 · 1 min read · OPENSTACK-QUEENS CINDER MYSQL DATABASE ·

Share on:

Sometimes things get so broken you just have to hack stuff out of the database because the API's are in a stuck state. Here is what I did to successfully remove the volume entries for some stuck volumes after a MySQL server crash. Note, You'll also need to adjust the quotas table too to decrement the number of volumes …

MySQL dump over SSH to a remote host

Dec 14, 2015 · 1 min read · mysql bash ssh ·

Share on:

Original Article - http://christiank.org/wp/2010/12/pipe-a-gzipped-mysql-dump-over-ssh/ If you want to take a SQL dump from some host, compress it and send it across SSH to another host then this is the command you are chasing mysqldump -u MYSQL_USERNAME -p YOUR_DATABASE | gzip -c | ssh USERNAME@YOUR_TO_HOST 'cat > …