Tag: Database

  • Passbolt – Backup/Export Password Database To Keepass

    Passbolt – Backup/Export Password Database To Keepass

    The quickest and easiest (once Passbolt is installed) to backup a Passbolt Database, is to export it to KeePass. Here’s how.’The quickest and easiest (once Passbolt is installed) to backup a Passbolt Database, is to export it to KeePass. Here’s how. Remember to keep it in a safe place, preferably encrypted cold-storage. Back me up…

  • MySQL – Calculating Disk Usage Per Database

    MySQL – Calculating Disk Usage Per Database

    The answer usually lies within /var/lib/mysql/[DATABASE]. But the answer can also be found in, you guessed it, information_schema! 😀 Here’s an one-liner for you, that displays database sizes in megabytes (nice long float() included) If gigabytes are more your thing, run the following: Example output: Query on 👾

  • Kubernetes – Kubectl MySQL Client One-Liner

    Kubernetes – Kubectl MySQL Client One-Liner

    Some of my applications, if not all of them, use MySQL in some fashion. The database pod is not exposed outside it’s kube-network service and is only reachable from within it’s namespace… Troubleshooting or random database querying can be a hassle. Here’s a one-liner to help you: The container will disappear when you exit the…