Skip to content
Voina Blog (a tech warrior's blog)
code, tech recipes, mindfulness, books, reviews and more
Follow us on Twitter Follow us on Facebook Follow us on Instagram Follow us on LinkedIn Follow us on rss
  • Home
  • Professional interests and hobbies
  • George’s CV
  • Romana’s CV

Bash one liner: Fix Grafana SqLite

By George Valentin Voina | May 19, 2025
0 Comment

At times when closing Grafana with a kill command SqLite can get corrupted.

This is the one liner that saves the day:

# echo ".dump" | sqlite3 grafana.db | sqlite3 grafana_new.db

This will load, clean, validate and then dump the db file in a new db file. 

Then simply copy the new grafana_new.db as the new grafana.db and restart Grafana.

Share this:

  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Reddit (Opens in new window) Reddit
  • Share on Mastodon (Opens in new window) Mastodon
  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook
  • Share on WhatsApp (Opens in new window) WhatsApp
  • Email a link to a friend (Opens in new window) Email
  • Share on Telegram (Opens in new window) Telegram
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Tumblr (Opens in new window) Tumblr
  • Print (Opens in new window) Print
  • Share on Nextdoor (Opens in new window) Nextdoor
  • More
  • Share on Threads (Opens in new window) Threads
  • Share on X (Opens in new window) X
  • Share on Bluesky (Opens in new window) Bluesky

Like this:

Like Loading...

Related

Category: Databases
Post navigation
← My Family Name Domain and the Multilingual Ransomware Scam Bash one liners: Keeping an Eye on Connections: Using tcpdump to Monitor Client-Server Port Activity →

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to Blog via Email

Topics

  • A. I. (20)
  • Amazon Review (4)
  • Application Servers (32)
  • Audiophile (2)
  • Banking (48)
  • Blog Links (32)
  • Books (8)
  • Databases (56)
  • DataCenter (162)
    • Docker (27)
    • Hp Microserver Gen8 (13)
    • Linux (70)
    • Storage (26)
  • Fintech (48)
  • Health (4)
  • Human Mind (25)
  • IoT (8)
  • Networking (52)
    • EdgeRouter (16)
    • Security (24)
  • Payments (31)
  • Programming (36)
  • RaspberryPi (10)
  • Technology Fails (20)
  • Travel (16)
  • Uncategorized (6)
  • Vintage Tech (3)
  • Watches (1)

Authors

  • 1 Romana Salageanu
  • 1 George Valentin Voina
  • RSS - Posts

Mastodon

Mastodon
Copyright 2015-2021 Donate for the site maintenance
voina.org voina.in voina.uk voina.fr voina.it voina.be
Iconic One Theme | Powered by Wordpress
%d