|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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'*'AMSR S D2 10.55am SMacLean paper v2.doc'*0xd0cf11e0a1b11ae1000000000000000000000000 000000003e000300feff09000600000000000000000000000a 000000e40400000000000000100000e604000001000000feff ffff00000000da040000db040000dc040000dd040000de0400 00df040000e0040000e1040000e2040000e3040000ffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff 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. __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Attachment DB Table Too Large...??? | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-13-2010 03:10 AM |
How to move Similar Threads table | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 09-11-2009 05:10 AM |
just move server -Random Forbidden 403 + 404 & random Attachment problem | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 08-11-2009 01:20 PM |
Move Attachment to other server | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-13-2009 08:40 AM |
Attachment/Album uploading problems after server move | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-25-2009 02:10 AM |