Results 1 to 3 of 3

Thread: Splitting large captures

  1. #1

    Default Splitting large captures

    Hi all.

    I let a computer run for a few days, and captured the hwole thing in a 430 MB file. Now, to load it on another Chanalyzer, it takes forever. Does there exist any tool to split the capture, so the chunks could be a little more manageable?

    Thanks,

    Edit:

    Here is some info from analyzing the dump file with sqlite3_analyzer:

    Page size in bytes.................... 1024
    Pages in the whole file (measured).... 434027
    Pages in the whole file (calculated).. 434033
    Pages that store data................. 434033 100.001%
    Pages on the freelist (per header).... 0 0.0%
    Pages on the freelist (calculated).... -6 -0.0%
    Pages of auto-vacuum overhead......... 0 0.0%
    Number of tables in the database...... 12
    Number of indices..................... 3
    Number of named indices............... 3
    Automatically generated indices....... 0
    Size of the file in bytes............. 444443648
    Bytes of user payload stored.......... 309367670 69.6%

    *** Page counts for all tables with their indices ********************

    SWEEP................................. 343240 79.1%
    NETWORK_SCAN.......................... 90771 20.9%
    NETWORK_CONFIG........................ 7 0.002%
    SQLITE_MASTER......................... 7 0.002%
    DB_VERSION............................ 1 0.0%
    DEVICE................................ 1 0.0%
    DEVICE_SETTING........................ 1 0.0%
    L_DEVICE_SETTING_PURPOSE.............. 1 0.0%
    L_DEVICE_TYPE......................... 1 0.0%
    NETWORK............................... 1 0.0%
    SETTING............................... 1 0.0%
    SQLITE_SEQUENCE....................... 1 0.0%
    Last edited by BroboMan; 07-01-2013 at 06:28 AM. Reason: Added file structure analyze.

  2. #2

    Default

    There are several tools available to split sql files.
    I don't know if they will be usable in the split state.

    Old Mod by the Sea

  3. Default

    Unfortunately we don't have an official way to do it. Back up your file, and give ua549's method a shot. I personally recommend recordings of 8 hours or less, because after 8 hours, the data doesn't fit on Chanalyzer Pro's waterfall view, and that's just too much data to sift through. Let us know if you find a way to split up the capture!

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •