open-menu closeme
Home
Archives
Links icon
LinkedIn Twitter
About
English
github linkedin
  • MySQL workbench on Ubuntu 20

    calendar Jun 11, 2020 · 1 min read · MYSQL UBUNTU UBUNTU-20  ·
    Share on: twitter facebook linkedin copy

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


    Read More
  • MYSQL Backup to S3 script

    calendar Sep 18, 2019 · 1 min read · linux mysql  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Openstack Queens - Cinder: Deleting volumes using Mysql

    calendar Apr 24, 2018 · 1 min read · OPENSTACK-QUEENS CINDER MYSQL DATABASE  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • MySQL dump over SSH to a remote host

    calendar Dec 14, 2015 · 1 min read · mysql bash ssh  ·
    Share on: twitter facebook linkedin copy

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


    Read More

Cory Hawkvelt photo

Cory Hawkvelt

Career Nerd and Open Source Cloud Architect
Read More

Recent Posts

  • RabbitMQ in HA
  • MemcacheD connection limits inside Docker
  • Use grep to view a file without comments
  • Use grep to view a file without comments
  • Scrub all local disks
  • Use grep to view a file without comments
  • tcpdump HTTP traffic
  • List all local linux disks

Tags

LINUX 31 CEPH 22 BASH 19 OPENSTACK 11 NETWORKING 10 DOCKER 7 CONFIG 6 OPENSTACK-QUEENS 5 QEMU 5 TROUBLESHOOTING 5 CENTOS7 4 MYSQL 4 SSH 4 UBUNTU 4
All Tags
ACTIVE-BACKUP1 ADB1 ANDROID1 ANSIBLE2 APT1 AUTODISCOVER1 BACKUP1 BASH19 BIND1 BLUETOOTH1 CAS1 CENTOS74 CEPH22 CEPH-NAUTILUS1 CERTIFICATES1 CINDER3 COLLECTD1 COMWARE1 CONFIG6 CRYPTOLOCK1 CRYPTOMINER2 DATABASE1 DELL-S600-ON1 DELLMD3060JBOD1 DHCP1 DISK-MGMT1 DNS1 DOCKER7 DRIVERS1 ESP826621 ESPTOOL1 FAIL2BAN1 FEDORA261 FIBRECHANNEL1 FIRMWARE1 FREEOTP1 GIT1 GNOCCHI2 HAPROXY2 HARDWARE2 HORIZON1 HP2 HP-ILO1 HPACUCLI3 HTTP1 HUGO1 HYPER-V1 INDEX1 IP2 IPTABLES1 IPV61 KEYCLOAK1 KEYGEN3 KEYSTONE1 KOLLA1 KVM2 LE1 LIBRENMS1 LINUX31 LOGO1 MAAS1 MATTERMOST1 MEGACLI1 MELLANOX1 MELTDOWN1 MEMCACHED1 MIKROTIK2 MOUSE1 MTP1 MYSQL4 NAMED1 NAT1 NETBOX1 NETBOX-IPAM1 NETWORK-MANAGER1 NETWORKING10 NEUTRON1 NOVA1 NOVNC1 NPS1 OPENNEBULA1 OPENSTACK11 OPENSTACK-QUEENS5 OPENSWITCH1 OPENVSWITCH1 OVN1 PKI1 PORT1 PRINTER1 PROXMOX1 PUTTY1 PYTHON1 QEMU5 RABBITMQ1 RADIUS1 RADOSGW2 RAID3 RBD3 ROCKY-GLANCE1 ROUTING1 SCRIPT1 SERVER1 SERVER-20121 SMTP1 SNMP1 SPECTRE1 SPEEDTEST1 SSH4 SSL1 SVG1 SWAP1 SYSCOMMANDS1 TCP1 TCP-DUMP1 TCPDUMP1 TROUBLESHOOTING5 UBUNTU4 UBUNTU-182 UBUNTU-201 UBUNTU-GNOME1 UBUNTU171 UEFI1 VAGRANT2 VIRTUAL-NETWORK1 VIRTUALISATION1 VLAN1 VM2 VPN1 VXLAN1 WINDOWS2 WINDOWS-AD1 WIRESHARK1 YOUTUBE-DL1
[A~Z][0~9]

Copyright 2022-  . All Rights Reserved

to-top