не мога да импортирам sql файл- отнема цяла вечност

naskobg

Well-Known Member
имам един sql файл с големина 53 мб. (ограничението на хостинга пише (Максимален размер: 55МБ) ) Давам импортиране и задавам файла. Следя по таск менаджера броя на изпратените байтове и като стигне 55 милиона + и зацепва.и така повече от 1 час не се случва нищо..нито грешка ..нищо.Има ли нещо по специфично което трябва да направя ?дали е проблем от хостинга или от файла?
при импортирането имам опции :
Набор от знаци на файла
Формат
Режим на съвместимост на SQL:Документация
 
От: не мога да импортирам sql файл- отнема цяла вечност

С този скрипт трябва да стане. Прочети някъде как става номера. Импортвал съм с него над 100 мб при ограничение 25.
 
От: не мога да импортирам sql файл- отнема цяла вечност

Раздели файла на 2 по-малки с текстов редактор. Разделянето нека бъде между 2 заявки, приблизително по средата на файла. Импортирай ги отделно.
Повечето текстови редактори не могат да работят с 53 MB файл, но TextPad може.

Втори вариант - ако това е дъмп от уърдпрес, има един плъгин, който трие ревизиите на постовете. Инсталирай го, изтрий старите ревизии и направи нов SQL дъмп. Файлът ще бъде 10тина МБ.
 
От: не мога да импортирам sql файл- отнема цяла вечност

Свържи се с съпорта и им кажи да ти го качат, не мисля, че ще ти откажат.
 
От: не мога да импортирам sql файл- отнема цяла вечност

Това лимит за размер на файл ли е или лимит на MySQL сървъра.
Ако е първото, просто нарязваш файла без значение през къде (т.е. може и посред някоя заявка), а като качиш парчетата го сглобяваш с подобен прост скрипт и правиш import.
Ако път е второто, тогава ще е хубаво да си разцепиш файла на по-малки заявки. Ако имаш малко на брой дълги заявки, то ще трябва да ги приспособиш да станат повече на брой по-къси.
Мога да се опитам да ти помогна (дребна помощ), ако поясниш по-подробно проблема си.
 
От: не мога да импортирам sql файл- отнема цяла вечност

Провери и лимита на php за upload_max_filesize, max_input_time, ограничението за execution time. Оказват влияние при такива големи фалйлове.
 
От: не мога да импортирам sql файл- отнема цяла вечност

А ти файла компресирал ли си го.
Ако не си го, компресирай и тогава качвай.
Ако с компресията ти е 53 мб , то тогава имаш 2 начина, или да го цепиш или да се свържеш със съпорта, да им го пратиш и те да импортират
 
От: не мога да импортирам sql файл- отнема цяла вечност

Компресирай го bzip, gzip, каквато компресия поддържа хостинга и ще стане доста по-малък.
 
От: не мога да импортирам sql файл- отнема цяла вечност

направих го това но ми дава:

Грешка

SQL заявка:

-- -- Ссхема на данните от таблица `cms` -- INSERT INTO `cms` (`id`, `name`, `content`) VALUES (1, 'privacy-policy', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'), (2, 'contact-us', '<p>Contact Us if u have any questions</p><p>e-mail - [email protected]<br></p>'), (3, 'about-us', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'), (4, 'legal-statement', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'), (5, 'terms-of-service', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0[...]

MySQL отговори: Документация
#1062 - Duplicate entry '1' for key 1

Компресирай го bzip, gzip, каквато компресия поддържа хостинга и ще стане доста по-малък.
 
От: не мога да импортирам sql файл- отнема цяла вечност

С линка по-горе, който ти дадох, си сваляш php-то и го ъплоудваш на сървъра си.. Ъплоудваш си и базата данни при него. Въвеждаш си данните за връзка, отваряш го през браузъра и пердашиш.. Това видео ще те насочи: [video=youtube;2JEkLMKAUZc]http://www.youtube.com/watch?v=2JEkLMKAUZc[/video]
 
От: От: не мога да импортирам sql файл- отнема цяла вечност

направих всичко както е описано в 2 варианта ..в sql и gz
1.jpg

и пи двата опита грешка:

Error at the line 42: (18, 'goldmon', '6776153755856a5a628a01297812539c', '[email protected]');

Query: --
--
INSERT INTO `admin` (`id`, `admin_user`, `admin_pass`, `admin_email`) VALUES
(18, 'goldmon', '6776153755856a5a628a01297812539c', '[email protected]')

MySQL: Duplicate entry '18' for key 1

Stopped on error



edit:
когато изтрих username и паролата на [email protected] сега ми дава:

Error at the line 97: (8, 'videos', '');

Query: --
--
INSERT INTO `cms` (`id`, `name`, `content`) VALUES
(1, 'privacy-policy', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(2, 'contact-us', '<p>Contact Us if u have any questions</p><p>e-mail - [email protected]<br></p>'),
(3, 'about-us', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(4, 'legal-statement', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(5, 'terms-of-service', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(7, 'free-sites', '<style type="text/css">\r\n<!--\r\n.style2 {color: #000000}\r\n-->\r\n</style>\r\n\r\n<h2 align="center">Join All The Sites Below With Just Your Email Address!!! </h2>\r\n<table width="511" border="0" align="center" id="table4">\r\n <tr>\r\n <td colspan="4" bgcolor="#000000" style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px">\r\n <p align="center"><b> <font color="#FFFF00" face="Verdana" size="5">100''S OF LIVE SEX SHOWS IN THESE CATEGORIES AT WEBCAMS.COM</font></b></td>\r\n </tr>\r\n <tr bgcolor="#FFFFFF">\r\n <td width="131" align="center" style="border-left-style: solid; border-left-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheasians1"> Asian Girls</font></a></span></td>\r\n <td width="134" align="center" style="border-top-style: solid; border-top-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheanal1"> Anal Sex</font></a></span></td>\r\n <td width="125" align="center" style="border-top-style: solid; border-top-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichebbw1"> BBW Girls</font></a></span></td>\r\n <td width="103" align="center" style="border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichebigtits1"> Big Tits</font></a></span></td>\r\n </tr>\r\n <tr bgcolor="#FFFFFF">\r\n <td width="131" align="center" style="border-left-style: solid; border-left-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheblowjobs1"> Blowjobs</font></a></span></td>\r\n <td width="134" align="center"><span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichecumshots1"> Cumshots</font></a></span></td>\r\n <td width="125" align="center"><span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheebony1"> Ebony Girls</font></a></span></td>\r\n <td width="103" align="center" style="border-right-style: solid; border-right-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichegroup1"> Group Sex</font></a></span></td>\r\n </tr>\r\n <tr>\r\n <td width="131" align="center" bgcolor="#FFFFFF" style="border-left-style: solid; border-left-width: 1px; border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheteens1"> Live Teens (18+)</font></a></span></td>\r\n <td width="134" align="center" bgcolor="#FFFFFF" style="border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blan" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichelatina1"> Latina Girls</font></a></span></td>\r\n <td width="125" align="center" bgcolor="#FFFFFF" style="border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichelesbian1"> Lesbians</font></a></span></td>\r\n <td width="103" align="center" bgcolor="#FFFFFF" style="border-right-style: solid; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichemilfs1"> MILF''s</font></a></span></td>\r\n </tr>\r\n</table>\r\n<table width="50%" border="0" align="center">\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/55/crazybitch/AAA/_E/" target="_blank">Super Star Flicks </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/84/crazybitch/AAA/_E/" target="_blank">All Anal Flicks </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/57/crazybitch/AAA/_E/" target="_blank">Amateur Teen Fuck </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/16/crazybitch/AAA/_E/" target="_blank">Amateur Porn 4 Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/91/crazybitch/AAA/_E/" target="_blank">Asian Xxx Spice </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/20/crazybitch/AAA/_E/" target="_blank">Asian Sex For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/82/crazybitch/AAA/_E/" target="_blank">Bang This Milf </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/58/crazybitch/AAA/_E/" target="_blank">Big Fat Fun </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/33/crazybitch/AAA/_E/" target="_blank">Bi Sexuals For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/8/crazybitch/AAA/_E/" target="_blank">Ebony Women For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/97/crazybitch/AAA/_E/" target="_blank">BlowJob Factory </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/9/crazybitch/AAA/_E/" target="_blank">Blow Jobs For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/10/crazybitch/AAA/_E/" target="_blank">Boobs For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/18/crazybitch/AAA/_E/" target="_blank">Brunette Babes For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/14/crazybitch/AAA/_E/" target="_blank">Sexy Center Folds For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/34/crazybitch/AAA/_E/" target="_blank">Chubby Videos </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/81/crazybitch/AAA/_E/" target="_blank">Crazy Party Girls For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/59/crazybitch/AAA/_E/" target="_blank">Cum Covered Faces </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/78/crazybitch/AAA/_E/" target="_blank">Creampies For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/89/crazybitch/AAA/_E/" target="_blank">Dark Meat White Meat </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/88/crazybitch/AAA/_E/" target="_blank">Deceiving Divas </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/60/crazybitch/AAA/_E/" target="_blank">Latina Sluts </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/53/crazybitch/AAA/_E/" target="_blank">Fetish For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/61/crazybitch/AAA/_E/" target="_blank">Foot Fetishes </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/13/crazybitch/AAA/_E/" target="_blank">Free Fuck Cams </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/96/crazybitch/AAA/_E/" target="_blank">Fucking Tit Videos </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/23/crazybitch/AAA/_E/" target="_blank">GangBang For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/62/crazybitch/AAA/_E/" target="_blank">Big Ass Cocks </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/24/crazybitch/AAA/_E/" target="_blank">Girl Girl For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/92/crazybitch/AAA/_E/" target="_blank">Hairy Muff Lover </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/63/crazybitch/AAA/_E/" target="_blank">Hardcore interracial Videos </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/64/crazybitch/AAA/_E/" target="_blank">Hardcore Slut adventures </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/94/crazybitch/AAA/_E/" target="_blank">Hotties &amp; Fatties </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/83/crazybitch/AAA/_E/" target="_blank">Kinky Porn Stars </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/37/crazybitch/AAA/_E/" target="_blank">Latin Girls For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/86/crazybitch/AAA/_E/" target="_blank">Lesbian Lane </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/65/crazybitch/AAA/_E/" target="_blank">Lesbian Orgys </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/39/crazybitch/AAA/_E/" target="_blank">Mature Sex For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/25/crazybitch/AAA/_E/" target="_blank">Naughty Wives For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/66/crazybitch/AAA/_E/" target="_blank">Petite Mania</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/54/crazybitch/AAA/_E/" target="_blank">Porn Passes For Free</a> </div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/42/crazybitch/AAA/_E/" target="_blank">Red Heads For Free</a> </div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/43/crazybitch/AAA/_E/" target="_blank">Hot Russian Girls For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/46/crazybitch/AAA/_E/" target="_blank">Spy For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/69/crazybitch/AAA/_E/" target="_blank">Suck My Dick Bitch </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/15/crazybitch/AAA/_E/" target="_blank">Teen Sluts For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/70/crazybitch/AAA/_E/" target="_blank">The Pantie Insider </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/48/crazybitch/AAA/_E/" target="_blank">Undies For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/28/crazybitch/AAA/_E/" target="_blank">Virgins For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/73/crazybitch/AAA/_E/" target="_blank">Xxx Beach Blondes </a></div></td>\r\n </tr>\r\n</table>\r\n\r\n<p align="center"><a href="http://www.sex-or-sin.com" target="_blank"><img src="http://www.Fuck-Films.Com/banner-1.gif" width="468" height="80" border="0"></a></p>\r\n<p align="center"><a href="http://www.Fuck-Films.Com" target="_blank"><img src="http://www.Fuck-Films.Com/120x120-3.gif" width="120" height="120" border="0"></a><a href="http://www.my-free-porn-movies.com" target="_blank"><img src="http://www.Fuck-Films.Com/125x125-7.gif" width="125" height="125" border="0"></a><a href="http://www.lesbian-sex-tales.com" target="_blank"><img src="http://www.Fuck-Films.Com/125x125.gif" width="125" height="125" border="0"></a><a href="http://www.hardcore-hentai-videos.com" target="_blank"><img src="http://www.Fuck-Films.Com/125x125-8.gif" width="125" height="125" border="0"></a>\r\n <!-- BEGIN WEBCAMS.COM TEXT LINK CODE -->\r\n</p>\r\n<!-- END WEBCAMS.COM TEXT LINK CODE -->\r\n</p>\r\n'),
(8, 'videos', '')

MySQL: Duplicate entry '1' for key 1

Stopped on error


С линка по-горе, който ти дадох, си сваляш php-то и го ъплоудваш на сървъра си.. Ъплоудваш си и базата данни при него. Въвеждаш си данните за връзка, отваряш го през браузъра и пердашиш.. Това видео ще те насочи:
 
Последно редактирано:
От: От: От: не мога да импортирам sql файл- отнема цяла вечност

направих всичко както е описано в 2 варианта ..в sql и gz
Виж файлът 4381

и пи двата опита грешка:

Error at the line 42: (18, 'goldmon', '6776153755856a5a628a01297812539c', '[email protected]');

Query: --
--
INSERT INTO `admin` (`id`, `admin_user`, `admin_pass`, `admin_email`) VALUES
(18, 'goldmon', '6776153755856a5a628a01297812539c', '[email protected]')

MySQL: Duplicate entry '18' for key 1

Stopped on error



edit:
когато изтрих username и паролата на [email protected] сега ми дава:

Error at the line 97: (8, 'videos', '');

Query: --
--
INSERT INTO `cms` (`id`, `name`, `content`) VALUES
(1, 'privacy-policy', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(2, 'contact-us', '<p>Contact Us if u have any questions</p><p>e-mail - [email protected]<br></p>'),
(3, 'about-us', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(4, 'legal-statement', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(5, 'terms-of-service', '<SCRIPT LANGUAGE=JAVASCRIPT SRC="http://www.vipstream.com/exports/tour/?&c=4&r=9&nfc=1&cat=0&jpol=programs.wegcash.com/click/_S/ezcams/7500/crazybitch//_E/tour4/&df=7&mpd=10&otype=js&"></SCRIPT>'),
(7, 'free-sites', '<style type="text/css">\r\n<!--\r\n.style2 {color: #000000}\r\n-->\r\n</style>\r\n\r\n<h2 align="center">Join All The Sites Below With Just Your Email Address!!! </h2>\r\n<table width="511" border="0" align="center" id="table4">\r\n <tr>\r\n <td colspan="4" bgcolor="#000000" style="border-left-style: solid; border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px">\r\n <p align="center"><b> <font color="#FFFF00" face="Verdana" size="5">100''S OF LIVE SEX SHOWS IN THESE CATEGORIES AT WEBCAMS.COM</font></b></td>\r\n </tr>\r\n <tr bgcolor="#FFFFFF">\r\n <td width="131" align="center" style="border-left-style: solid; border-left-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheasians1"> Asian Girls</font></a></span></td>\r\n <td width="134" align="center" style="border-top-style: solid; border-top-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheanal1"> Anal Sex</font></a></span></td>\r\n <td width="125" align="center" style="border-top-style: solid; border-top-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichebbw1"> BBW Girls</font></a></span></td>\r\n <td width="103" align="center" style="border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichebigtits1"> Big Tits</font></a></span></td>\r\n </tr>\r\n <tr bgcolor="#FFFFFF">\r\n <td width="131" align="center" style="border-left-style: solid; border-left-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheblowjobs1"> Blowjobs</font></a></span></td>\r\n <td width="134" align="center"><span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichecumshots1"> Cumshots</font></a></span></td>\r\n <td width="125" align="center"><span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheebony1"> Ebony Girls</font></a></span></td>\r\n <td width="103" align="center" style="border-right-style: solid; border-right-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichegroup1"> Group Sex</font></a></span></td>\r\n </tr>\r\n <tr>\r\n <td width="131" align="center" bgcolor="#FFFFFF" style="border-left-style: solid; border-left-width: 1px; border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nicheteens1"> Live Teens (18+)</font></a></span></td>\r\n <td width="134" align="center" bgcolor="#FFFFFF" style="border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blan" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichelatina1"> Latina Girls</font></a></span></td>\r\n <td width="125" align="center" bgcolor="#FFFFFF" style="border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichelesbian1"> Lesbians</font></a></span></td>\r\n <td width="103" align="center" bgcolor="#FFFFFF" style="border-right-style: solid; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px"> <span class="style2"> <a target="_blank" href="http://www.webcams.com/link.php?reseller=xxxmaster&type=1&_u=/index.php?page=nichemilfs1"> MILF''s</font></a></span></td>\r\n </tr>\r\n</table>\r\n<table width="50%" border="0" align="center">\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/55/crazybitch/AAA/_E/" target="_blank">Super Star Flicks </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/84/crazybitch/AAA/_E/" target="_blank">All Anal Flicks </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/57/crazybitch/AAA/_E/" target="_blank">Amateur Teen Fuck </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/16/crazybitch/AAA/_E/" target="_blank">Amateur Porn 4 Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/91/crazybitch/AAA/_E/" target="_blank">Asian Xxx Spice </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/20/crazybitch/AAA/_E/" target="_blank">Asian Sex For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/82/crazybitch/AAA/_E/" target="_blank">Bang This Milf </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/58/crazybitch/AAA/_E/" target="_blank">Big Fat Fun </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/33/crazybitch/AAA/_E/" target="_blank">Bi Sexuals For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/8/crazybitch/AAA/_E/" target="_blank">Ebony Women For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/97/crazybitch/AAA/_E/" target="_blank">BlowJob Factory </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/9/crazybitch/AAA/_E/" target="_blank">Blow Jobs For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/10/crazybitch/AAA/_E/" target="_blank">Boobs For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/18/crazybitch/AAA/_E/" target="_blank">Brunette Babes For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/14/crazybitch/AAA/_E/" target="_blank">Sexy Center Folds For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/34/crazybitch/AAA/_E/" target="_blank">Chubby Videos </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/81/crazybitch/AAA/_E/" target="_blank">Crazy Party Girls For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/59/crazybitch/AAA/_E/" target="_blank">Cum Covered Faces </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/78/crazybitch/AAA/_E/" target="_blank">Creampies For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/89/crazybitch/AAA/_E/" target="_blank">Dark Meat White Meat </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/88/crazybitch/AAA/_E/" target="_blank">Deceiving Divas </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/60/crazybitch/AAA/_E/" target="_blank">Latina Sluts </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/53/crazybitch/AAA/_E/" target="_blank">Fetish For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/61/crazybitch/AAA/_E/" target="_blank">Foot Fetishes </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/13/crazybitch/AAA/_E/" target="_blank">Free Fuck Cams </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/96/crazybitch/AAA/_E/" target="_blank">Fucking Tit Videos </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/23/crazybitch/AAA/_E/" target="_blank">GangBang For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/62/crazybitch/AAA/_E/" target="_blank">Big Ass Cocks </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/24/crazybitch/AAA/_E/" target="_blank">Girl Girl For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/92/crazybitch/AAA/_E/" target="_blank">Hairy Muff Lover </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/63/crazybitch/AAA/_E/" target="_blank">Hardcore interracial Videos </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/64/crazybitch/AAA/_E/" target="_blank">Hardcore Slut adventures </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/94/crazybitch/AAA/_E/" target="_blank">Hotties & Fatties </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/83/crazybitch/AAA/_E/" target="_blank">Kinky Porn Stars </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/37/crazybitch/AAA/_E/" target="_blank">Latin Girls For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/86/crazybitch/AAA/_E/" target="_blank">Lesbian Lane </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/65/crazybitch/AAA/_E/" target="_blank">Lesbian Orgys </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/39/crazybitch/AAA/_E/" target="_blank">Mature Sex For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/25/crazybitch/AAA/_E/" target="_blank">Naughty Wives For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/66/crazybitch/AAA/_E/" target="_blank">Petite Mania</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/54/crazybitch/AAA/_E/" target="_blank">Porn Passes For Free</a> </div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/42/crazybitch/AAA/_E/" target="_blank">Red Heads For Free</a> </div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/43/crazybitch/AAA/_E/" target="_blank">Hot Russian Girls For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/46/crazybitch/AAA/_E/" target="_blank">Spy For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/69/crazybitch/AAA/_E/" target="_blank">Suck My Dick Bitch </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/15/crazybitch/AAA/_E/" target="_blank">Teen Sluts For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/70/crazybitch/AAA/_E/" target="_blank">The Pantie Insider </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/48/crazybitch/AAA/_E/" target="_blank">Undies For Free </a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/28/crazybitch/AAA/_E/" target="_blank">Virgins For Free </a></div></td>\r\n <td><div align="left"><a href="http://free.wegcash.com/click/_S/free/73/crazybitch/AAA/_E/" target="_blank">Xxx Beach Blondes </a></div></td>\r\n </tr>\r\n</table>\r\n\r\n<p align="center"><a href="http://www.sex-or-sin.com" target="_blank"><img src="http://www.Fuck-Films.Com/banner-1.gif" width="468" height="80" border="0"></a></p>\r\n<p align="center"><a href="http://www.Fuck-Films.Com" target="_blank"><img src="http://www.Fuck-Films.Com/120x120-3.gif" width="120" height="120" border="0"></a><a href="http://www.my-free-porn-movies.com" target="_blank"><img src="http://www.Fuck-Films.Com/125x125-7.gif" width="125" height="125" border="0"></a><a href="http://www.lesbian-sex-tales.com" target="_blank"><img src="http://www.Fuck-Films.Com/125x125.gif" width="125" height="125" border="0"></a><a href="http://www.hardcore-hentai-videos.com" target="_blank"><img src="http://www.Fuck-Films.Com/125x125-8.gif" width="125" height="125" border="0"></a>\r\n <!-- BEGIN WEBCAMS.COM TEXT LINK CODE -->\r\n</p>\r\n<!-- END WEBCAMS.COM TEXT LINK CODE -->\r\n</p>\r\n'),
(8, 'videos', '')

MySQL: Duplicate entry '1' for key 1

Stopped on error
Малииии, я постни цялото файл да позяпаме малко фрий порн и ний :-o .
Тия горе вече съм ги гледал сичките :rolleyes: .

ПС: Блинки и Кулайс определено ше се зарадват на гъстите keywords. Тамън форумът ще се ранкне за малко по-интересни terms, че аман от Интернет печалбарство тука...
 
От: Re: не мога да импортирам sql файл- отнема цяла вечност

а как да ги почистя тия заявки?
Стартираш два пъти импорта без да си почистил базата, а явно импорта ти не съдържа почистващи заявки
 
Заявки не се чистят, чисти се базата (бази данни, таблици). Почистването зависи изцяло от това какво импортваш (повече от една база или само една, таблиците).
 
От: не мога да импортирам sql файл- отнема цяла вечност

Маркирай всички таблици и избери да дропне всички маркирани таблици.
 
От: не мога да импортирам sql файл- отнема цяла вечност

Човече (naskobg), за твое добро ти препоръчвам да си цензурираш написаното и да махнеш нещата, които могат да представляват интерес за милиционерите.
 
От: не мога да импортирам sql файл- отнема цяла вечност

имам един sql файл с големина 53 мб. (ограничението на хостинга пише (Максимален размер: 55МБ) ) Давам импортиране и задавам файла. Следя по таск менаджера броя на изпратените байтове и като стигне 55 милиона + и зацепва.и така повече от 1 час не се случва нищо..нито грешка ..нищо.Има ли нещо по специфично което трябва да направя ?дали е проблем от хостинга или от файла?
при импортирането имам опции :
Набор от знаци на файла
Формат
Режим на съвместимост на SQL:Документация


с това качвам аз като видя зор и по 600мб качва :) http://www.mysqldumper.de/
 

Горе