Announcement

Collapse
No announcement yet.

Server Move and Attachment Table?

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

  • Server Move and Attachment Table?

    I'm moving from one server to another. Both using MySQL. Every table copied over just fine, with the exception of the attachment table.

    I tried using Navicat's Data Transfer feature, and got this error:

    [Msg] [Dtf] Data transfer start
    [Msg] [Dtf] Get Table Data from: attachment
    [Msg] [Dtf] Drop Table: attachment
    [Msg] [Dtf] Create Table: attachment
    [Msg] [Dtf] Transfer Data to Server: attachment
    [Err] [Dtf] Transfer Data [insert into `attachment` values('30','1141','1214357692','1214357692','AMSRS D2 10.55am SMacLean paper v2.doc',0xd0cf11e0a1b11ae1000000000000000000000000000000003e000300feff09000600000000000000 000000000a000000e40400000000000000100000e604000001000000feffffff00000000da040000db040000dc 040000dd040000de040000df040000e0040000e1040000e2040000e3040000ffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff fffffffffffffffffffff ... ]: Got a packet bigger than 'max_allowed_packet' bytes

    [Err] [Dtf] Terminated

    I also tried exporting from phpMyAdmin on one, and importing using the same tool on the other. Exported just fine from the source, but in the target database it just seems to try forever, but doesn't get anywhere. The attachment table is only 2.7 MB in size, so it shouldn't take too long, I wouldn't think.

    MySQL Versions...

    Source: 5.0.51a
    Target: 5.0.81-community

    Any ideas?

    Thanks.

  • #2
    Given you're having problems with it, I'd move the attachments from the database to the file system, then back up your files and database and do your move then...
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      What he said ^^

      OR

      Got a packet bigger than 'max_allowed_packet' bytes
      Happening because you are importing via phpmyadmin, which is not a good practise. Most reliable way to backup AND import is via SSH.

      Comment


      • #4
        I'm not entirely sure where we store our files, but how does one remove it from the DB and move it to the file system? Will there be any noticable change to the users?

        Comment


        • #5
          Originally posted by dboogie2288 View Post
          I'm not entirely sure where we store our files, but how does one remove it from the DB and move it to the file system? Will there be any noticable change to the users?
          bump. a little help?

          /edit...disregard, found it easily enough
          Last edited by dboogie2288; Fri 4 Dec '09, 1:10pm.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X