Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Backing up Traffic Totals on an routinely?

    Scheduled Pinned Locked Moved Traffic Monitoring
    3 Posts 3 Posters 1.7k Views 3 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • P Offline
      pulsartiger
      last edited by

      I had an error today with Traffic Totals, "database disk image is malformed". Researching this error it appears that the database is corrupt and I had to disable/enable graphing to create a new database.

      Is it possible to run a shell script or cron job to routinely backup this database? I would also like this data exported as a CSV every week. Is this possible?

      S K 2 Replies Last reply Reply Quote 0
      • S Offline
        SteveITS Galactic Empire @pulsartiger
        last edited by

        @pulsartiger Not familiar with that package but pfSense has a cron package.

        Only install packages for your version, or risk breaking it. Select your branch in System/Update/Update Settings.
        When upgrading, allow 10-15 minutes to reboot, or more depending on packages, CPU, and/or disk speed.
        Upvote 👍 helpful posts!

        1 Reply Last reply Reply Quote 0
        • K Offline
          kikuyu @pulsartiger
          last edited by

          @pulsartiger
          The database name is vnstat.db and its location is under /var/db/vnstat.
          With "Backup Files/Dir" we are able to do backup or also with a cron.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.