0
Kayıt Ol

sql import sorunu (500 MB)

3

●

565

  • 23-12-2009, 09:57:04
    #1
    MyBB
    MyBB
    Merhaba arkadaşlar..Elimde 500 mb büyüklüğünde bir yedek var.Bunu siteme import etmem gerekiyor ama ne yaptıysam olmadı.
    Bigdump denedim,mysql dumper denedim hatta bir program yardımıyla sql'i parçalayıp atmayı denedim ama yine olmadı.Sürekli hata veriyor.

    Bigdump'da bu hatayı alıyorum:

    Alıntı
    (3629,96,1),(3629,97,1),(3629,99,1),(4571,542,1),( 4571,5,1),(4571,543,1),(4571,4,1),(4571,293,1),(45 71,55,1),(4571,432,1),(4571,249,1),(4571,346,1),(4 571,438,1),(4571,437,1),(4571,436,1),(4571,434,1), (4571,442,1),(4571,306,1),(4571,307,1),(4571,355,1 ),(4571,308,1),(4571,441,1),(4571,440,1),(4571,435 ,1),(4571,52,1),(4571,51,1),(4571,232,1),(4571,443 ,1),(4571,264,1),(4571,310,1),(4571,309,1),(4571,3 56,1),(4571,357,1),(4571,358,1),(4571,444,1),(4571 ,445,1),(4571,446,1),(4571,256,1),(4571,258,1),(45 71,488,1),(4571,489,1),(4571,490,1),(4571,538,1),( 4571,269,1),(4571,259,1),(4571,353,1),(4571,352,1) ,(4571,354,1),(4571,360,1),(4571,359,1),(4571,218, 1),(4571,456,1),(4571,109,1),(4571,248,1),(4571,27 3,1),(4571,285,1),(4571,230,1),(4571,231,1),(4571, 59,1),(4571,286,1),(4571,49,1),(4571,450,1),(4571, 532,1),(4571,62,1),(4571,451,1),(4571,453,1),(4571 ,452,1),(4571,123,1),(4571,361,1),(4571,223,1),(45 71,61,1),(4571,48,1),(4571,376,1),(4571,219,1),(45 71,544,1),(4571,545,1),(4571,296,1),(4571,44,1),(4 571,47,1),(4571,58,1),(4571,235,1),(4571,292,1),(4 571,236,1),(4571,237,1),(4571,238,1),(4571,239,1), (4571,240,1),(4571,241,1),(4571,242,1),(4571,243,1 ),(4571,244,1),(4571,245,1),(4571,246,1),(4571,247 ,1),(4571,56,1),(4571,57,1),(4571,371,1),(4571,303 ,1),(4571,463,1),(4571,348,1),(4571,302,1),(4571,4 58,1),(4571,459,1),(4571,491,1),(4571,492,1),(4571 ,493,1),(4571,494,1),(4571,495,1),(4571,496,1),(45 71,497,1),(4571,498,1),(4571,67,1),(4571,68,1),(45 71,508,1),(4571,382,1),(4571,509,1),(4571,69,1),(4 571,460,1),(4571,536,1),(4571,535,1),(4571,297,1), (4571,343,1),(4571,511,1),(4571,345,1),(4571,347,1 ),(4571,510,1),(4571,344,1),(4571,384,1),(4571,363 ,1),(4571,499,1),(4571,386,1),(4571,97,1),(4571,99 ,1),(4571,385,1),(4571,546,1),(4571,454,1),(4571,4 5,1),(4571,291,1),(4571,46,1),(4571,6,1),(4571,7,1 ),(4571,430,1),(4571,8,1),(4571,9,1),(4571,10,1),( 4571,11,1),(4571,12,1),(4571,84,1),(4571,14,1),(45 71,81,1),(4571,133,1),(4571,533,1),(4571,134,1),(4 571,519,1),(4571,135,1),(4571,429,1),(4571,290,1), (4571,137,1),(4571,96,1),(4571,261,1),(4571,138,1) ,(4571,143,1),(4571,140,1),(4571,141,1),(4571,142, 1),(4571,146,1),(4571,145,1),(4571,139,1),(4571,14 4,1),(4571,26,1),(4571,82,1),(4571,128,1),(4571,26 5,1),(4571,27,1),(4571,136,1),(4571,85,1),(4571,28 ,1),(4571,233,1),(4571,250,1),(4571,251,1),(4571,4 28,1),(4571,252,1),(4571,253,1),(4571,255,1),(4571 ,254,1),(4571,87,1),(4571,393,1),(4571,396,1),(457 1,397,1),(4571,398,1),(4571,399,1),(4571,91,1),(45 71,400,1),(4571,401,1),(4571,21,1),(4571,426,1),(4 571,23,1),(4571,22,1),(4571,24,1),(4571,427,1),(45 71,25,1),(4571,373,1),(4571,147,1),(4571,149,1),(4 571,150,1),(4571,163,1),(4571,164,1),(4571,165,1), (4571,166,1),(4571,155,1),(4571,156,1),(4571,157,1 ),(4571,158,1),(4571,159,1),(4571,160,1),(4571,161 ,1),(4571,162,1),(4571,152,1),(4571,153,1),(4571,1 75,1),(4571,176,1),(4571,177,1),(4571,178,1),(4571 ,167,1),(4571,168,1),(4571,169,1),(4571,170,1),(45 71,171,1),(4571,172,1),(4571,173,1),(4571,174,1),( 4571,474,1),(4571,475,1),(4571,484,1),(4571,485,1) ,(4571,486,1),(4571,487,1),(4571,476,1),(4571,477, 1),(4571,478,1),(4571,479,1),(4571,480,1),(4571,48 1,1),(4571,482,1),(4571,483,1),(4571,154,1),(4571, 266,1),(4571,263,1),(4571,267,1),(4571,195,1),(457 1,196,1),(4571,197,1),(4571,201,1),(4571,202,1),(4 571,203,1),(4571,204,1),(4571,205,1),(4571,206,1), (4571,207,1),(4571,208,1),(4571,209,1),(4571,210,1 ),(4571,211,1),(4571,179,1),(4571,180,1),(4571,181 ,1),(4571,182,1),(4571,183,1),(4571,184,1),(4571,1 85,1),(4571,186,1),(4571,187,1),(4571,188,1),(4571 ,189,1),(4571,190,1),(4571,191,1),(4571,192,1),(45 71,193,1),(4571,194,1),(4571,29,1),(4571,30,1),(45 71,421,1),(4571,122,1),(4571,260,1),(4571,422,1),( 4571,31,1),(4571,32,1),(4571,301,1),(4571,71,1),(4 571,271,1),(4571,72,1),(4571,349,1),(4571,74,1),(4 571,75,1),(4571,76,1),(4571,77,1),(4571,78,1),(457 1,79,1),(4571,80,1),(4571,418,1),(4571,351,1),(457 1,350,1),(4571,383,1),(4571,368,1),(4571,419,1),(4 571,420,1),(4571,101,1),(4571,364,1),(4571,117,1), (4571,116,1),(4571,118,1),(4571,111,1),(4571,113,1 ),(4571,115,1),(4571,110,1),(4571,362,1),(4571,105 ,1),(4571,102,1),(4571,389,1),(4571,390,1),(4571,3 91,1),(4571,392,1),(4571,106,1),(4571,37,1),(4571, 40,1),(4571,330,1),(4571,410,1),(4571,331,1),(4571 ,333,1),(4571,332,1),(4571,38,1),(4571,405,1),(457 1,407,1),(4571,406,1),(4571,408,1),(4571,411,1),(4 571,39,1),(4571,299,1),(4571,300,1),(4571,298,1),( 4571,409,1),(4571,412,1),(4571,41,1),(4571,413,1), (4571,417,1),(4571,415,1),(4571,416,1),(4571,414,1 ),(4571,534,1),(4571,455,1),(4571,512,1),(4571,514 ,1),(4571,515,1),(4571,516,1),(4571,121,1),(4571,2 24,1),(4571,42,1),(4571,402,1),(4571,540,1),(4571, 403,1),(4571,43,1),(4571,404,1),(4571,288,1),(4571 ,507,1),(4571,504,1),(4571,505,1),(4571,506,1),(45 71,289,1),(4571,369,1);
    Query: INSERT INTO `access` VALUES (3629,96,1),(3629,97,1),(3629,99,1),(4571,542,1),( 4571,5,1),(4571,543,1),(4571,4,1),(4571,293,1),(45 71,55,1),(4571,432,1),(4571,249,1),(4571,346,1),(4 571,438,1),(4571,437,1),(4571,436,1),(4571,434,1), (4571,442,1),(4571,306,1),(4571,307,1),(4571,355,1 ),(4571,308,1),(4571,441,1),(4571,440,1),(4571,435 ,1),(4571,52,1),(4571,51,1),(4571,232,1),(4571,443 ,1),(4571,264,1),(4571,310,1),(4571,309,1),(4571,3 56,1),(4571,357,1),(4571,358,1),(4571,444,1),(4571 ,445,1),(4571,446,1),(4571,256,1),(4571,258,1),(45 71,488,1),(4571,489,1),(4571,490,1),(4571,538,1),( 4571,269,1),(4571,259,1),(4571,353,1),(4571,352,1) ,(4571,354,1),(4571,360,1),(4571,359,1),(4571,218, 1),(4571,456,1),(4571,109,1),(4571,248,1),(4571,27 3,1),(4571,285,1),(4571,230,1),(4571,231,1),(4571, 59,1),(4571,286,1),(4571,49,1),(4571,450,1),(4571, 532,1),(4571,62,1),(4571,451,1),(4571,453,1),(4571 ,452,1),(4571,123,1),(4571,361,1),(4571,223,1),(45 71,61,1),(4571,48,1),(4571,376,1),(4571,219,1),(45 71,544,1),(4571,545,1),(4571,296,1),(4571,44,1),(4 571,47,1),(4571,58,1),(4571,235,1),(4571,292,1),(4 571,236,1),(4571,237,1),(4571,238,1),(4571,239,1), (4571,240,1),(4571,241,1),(4571,242,1),(4571,243,1 ),(4571,244,1),(4571,245,1),(4571,246,1),(4571,247 ,1),(4571,56,1),(4571,57,1),(4571,371,1),(4571,303 ,1),(4571,463,1),(4571,348,1),(4571,302,1),(4571,4 58,1),(4571,459,1),(4571,491,1),(4571,492,1),(4571 ,493,1),(4571,494,1),(4571,495,1),(4571,496,1),(45 71,497,1),(4571,498,1),(4571,67,1),(4571,68,1),(45 71,508,1),(4571,382,1),(4571,509,1),(4571,69,1),(4 571,460,1),(4571,536,1),(4571,535,1),(4571,297,1), (4571,343,1),(4571,511,1),(4571,345,1),(4571,347,1 ),(4571,510,1),(4571,344,1),(4571,384,1),(4571,363 ,1),(4571,499,1),(4571,386,1),(4571,97,1),(4571,99 ,1),(4571,385,1),(4571,546,1),(4571,454,1),(4571,4 5,1),(4571,291,1),(4571,46,1),(4571,6,1),(4571,7,1 ),(4571,430,1),(4571,8,1),(4571,9,1),(4571,10,1),( 4571,11,1),(4571,12,1),(4571,84,1),(4571,14,1),(45 71,81,1),(4571,133,1),(4571,533,1),(4571,134,1),(4 571,519,1),(4571,135,1),(4571,429,1),(4571,290,1), (4571,137,1),(4571,96,1),(4571,261,1),(4571,138,1) ,(4571,143,1),(4571,140,1),(4571,141,1),(4571,142, 1),(4571,146,1),(4571,145,1),(4571,139,1),(4571,14 4,1),(4571,26,1),(4571,82,1),(4571,128,1),(4571,26 5,1),(4571,27,1),(4571,136,1),(4571,85,1),(4571,28 ,1),(4571,233,1),(4571,250,1),(4571,251,1),(4571,4 28,1),(4571,252,1),(4571,253,1),(4571,255,1),(4571 ,254,1),(4571,87,1),(4571,393,1),(4571,396,1),(457 1,397,1),(4571,398,1),(4571,399,1),(4571,91,1),(45 71,400,1),(4571,401,1),(4571,21,1),(4571,426,1),(4 571,23,1),(4571,22,1),(4571,24,1),(4571,427,1),(45 71,25,1),(4571,373,1),(4571,147,1),(4571,149,1),(4 571,150,1),(4571,163,1),(4571,164,1),(4571,165,1), (4571,166,1),(4571,155,1),(4571,156,1),(4571,157,1 ),(4571,158,1),(4571,159,1),(4571,160,1),(4571,161 ,1),(4571,162,1),(4571,152,1),(4571,153,1),(4571,1 75,1),(4571,176,1),(4571,177,1),(4571,178,1),(4571 ,167,1),(4571,168,1),(4571,169,1),(4571,170,1),(45 71,171,1),(4571,172,1),(4571,173,1),(4571,174,1),( 4571,474,1),(4571,475,1),(4571,484,1),(4571,485,1) ,(4571,486,1),(4571,487,1),(4571,476,1),(4571,477, 1),(4571,478,1),(4571,479,1),(4571,480,1),(4571,48 1,1),(4571,482,1),(4571,483,1),(4571,154,1),(4571, 266,1),(4571,263,1),(4571,267,1),(4571,195,1),(457 1,196,1),(4571,197,1),(4571,201,1),(4571,202,1),(4 571,203,1),(4571,204,1),(4571,205,1),(4571,206,1), (4571,207,1),(4571,208,1),(4571,209,1),(4571,210,1 ),(4571,211,1),(4571,179,1),(4571,180,1),(4571,181 ,1),(4571,182,1),(4571,183,1),(4571,184,1),(4571,1 85,1),(4571,186,1),(4571,187,1),(4571,188,1),(4571 ,189,1),(4571,190,1),(4571,191,1),(4571,192,1),(45 71,193,1),(4571,194,1),(4571,29,1),(4571,30,1),(45 71,421,1),(4571,122,1),(4571,260,1),(4571,422,1),( 4571,31,1),(4571,32,1),(4571,301,1),(4571,71,1),(4 571,271,1),(4571,72,1),(4571,349,1),(4571,74,1),(4 571,75,1),(4571,76,1),(4571,77,1),(4571,78,1),(457 1,79,1),(4571,80,1),(4571,418,1),(4571,351,1),(457 1,350,1),(4571,383,1),(4571,368,1),(4571,419,1),(4 571,420,1),(4571,101,1),(4571,364,1),(4571,117,1), (4571,116,1),(4571,118,1),(4571,111,1),(4571,113,1 ),(4571,115,1),(4571,110,1),(4571,362,1),(4571,105 ,1),(4571,102,1),(4571,389,1),(4571,390,1),(4571,3 91,1),(4571,392,1),(4571,106,1),(4571,37,1),(4571, 40,1),(4571,330,1),(4571,410,1),(4571,331,1),(4571 ,333,1),(4571,332,1),(4571,38,1),(4571,405,1),(457 1,407,1),(4571,406,1),(4571,408,1),(4571,411,1),(4 571,39,1),(4571,299,1),(4571,300,1),(4571,298,1),( 4571,409,1),(4571,412,1),(4571,41,1),(4571,413,1), (4571,417,1),(4571,415,1),(4571,416,1),(4571,414,1 ),(4571,534,1),(4571,455,1),(4571,512,1),(4571,514 ,1),(4571,515,1),(4571,516,1),(4571,121,1),(4571,2 24,1),(4571,42,1),(4571,402,1),(4571,540,1),(4571, 403,1),(4571,43,1),(4571,404,1),(4571,288,1),(4571 ,507,1),(4571,504,1),(4571,505,1),(4571,506,1),(45 71,289,1),(4571,369,1);
    MySQL: Duplicate entry '3629-96' for key 'PRIMARY'
    Stopped on error
    Mysql Dumper'da bu hatayı alıyorum.

    Alıntı
    MySQL-ERROR
    MySQL bildirisi:
    Table 'domain_kvb.account_types' doesn't exist

    Sorguda hata oluştu:
    INSERT INTO `account_types` VALUES ('paid','Platinum','4.95',0,1024,1024,1024,0,85,0, 5,1,5,20,10,1,1,1000,100,'13.05','24.95','44.95'), ('free','LitePlan','0.00',0,500,800,600,0,50,1,3,1 ,1,5,3,1,1,250,20,'0.00','0.00','0.00');
    INSERT INTO `account_types` VALUES ('paid','Platinum','4.95',0,1024,1024,1024,0,85,0, 5,1,5,20,10,1,1,1000,100,'13.05','24.95','44.95'), ('free','LitePlan','0.00',0,500,800,600,0,50,1,3,1 ,1,5,3,1,1,250,20,'0.00','0.00','0.00'); -> Table 'domain_kvb.account_types' doesn't exist
  • 23-12-2009, 23:20:01
    #2
    emredemir
    emredemir
    Üyeliği durduruldu
    veritabani_geri_yukle.php le yükle. olmadı mysql-font la . önerim veritabani_geri_yukle.php le yüklemen.
  • 23-12-2009, 23:37:49
    #3
    serhatcasmin
    serhatcasmin
    yuklemede sorun olmayabilir...
    sorun yuklemek istediginiz yerde o tablonun olmayisi
    domain_kvb isimli database de account_types adli tablo yok diyor hata.
  • 24-12-2009, 19:21:07
    #4
    okanberk
    okanberk
    Üyeliği durduruldu
    parçalara bölererk yükleyiniz...