Announcement

Collapse
No announcement yet.

Moving attachments from DB to filesystem - how long expect to take?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Moving attachments from DB to filesystem - how long expect to take?

    It is well overdue.
    We have 1G of attachments in the DB.
    ~22.5k very small attachments over 4 million posts.

    We started the move over 8 hours ago and it is still going like a strobe-light. How long should we expect this process take?

    - - - Updated - - -

    Figured out the issue - unsure how to fix it.

    Our attachment ID's start at 1-3000, then jumps to
    67108864

    So, all that time was blank attachment moves.

    Anyway to set a start attachment ID in the code temporarily for this move?





    - - - Updated - - -

    My solution:

    Open /admincp/attachment.php
    Code:
    Changed...
    $vbulletin->GPC['startat'] = intval($start['min']);
    to
    $vbulletin->GPC['startat'] = "67108864";
    Took about 5 minutes total to complete. Appears to have successfully migrated over without error.
    ??

  • #2
    You should look into what hack you had previously installed changed the autoincrement on your attachment table(s)

    It shouldnt cause a issue in the long run, but you may want to fix your auto increment counter on the affected tables.
    Gentoo Geek

    Comment


    • #3
      Several years ago we had a HD crash and had to rebuild the indexes for the entire forum.
      ??

      Comment

      Related Topics

      Collapse

      Working...
      X