Pagina 2 din 3
Scris: 02-Noi-2006, 23:09:41
de Etherfast
Cod: Selectaţi tot
MySQL: User 'atomicfun_04' has exceeded the 'max_updates' resource (current value: 10000)
Ce ti-am zis eu ca evonet nu-ti permite mai mult de 10.000 query-uri SQL pe ora?
Daca ai sa citesti cu atentie php-ul, o sa vezi ca la un moment dat poti stabili o variabila de delay (sa astepte un numar de milisecunde intre importari).
Cod: Selectaţi tot
linespersession = 3000; // Lines to be executed per one import session
$delaypersession = 0; // You can specify a sleep time in milliseconds after each session // Works only if JavaScript is activated. Use to reduce server overrun
Seteaza in loc de 3000, 9000 de exemplu, si la $delay pui 3300000
Scris: 03-Noi-2006, 09:16:57
de Plutonium
deci zimi in ce fisier tre sa modific
Scris: 03-Noi-2006, 09:27:39
de Etherfast
bigdump.php - SINGURUL fisier din arhiva...
Scris: 04-Noi-2006, 10:28:48
de Plutonium
BigDump: Staggered MySQL Dump Importer v0.26b
Processing file: atomicfun_lx_ro.sql
Starting from line: 1
Session Done To go Total
Lines 9000 9000 ? ?
Queries 8567 8567 ? ?
Bytes 932443 932443 219295 1151738
KB 910.59 910.59 214.16 1124.74
MB 0.89 0.89 0.21 1.1
% 81 81 19 100
% bar
Now I'm waiting 3300000 milliseconds before starting next session...
Press STOP to abort the import OR WAIT!
© 2003-2006 Alexey Ozerov - BigDump Home
e bine ce imi arata?
Scris: 04-Noi-2006, 10:43:15
de Plutonium
BigDump: Staggered MySQL Dump Importer v0.26b
Processing file: atomicfun_lx_ro(2).sql
Starting from line: 9001
Error at the line 10434: INSERT INTO `phpbb_search_wordlist` VALUES ('exclusively', 12945, 0);
Query: INSERT INTO `phpbb_search_wordlist` VALUES ('exclusively', 12945, 0);
MySQL: User 'atomicfun_04' has exceeded the 'max_updates' resource (current value: 10000)
Stopped on error
Start from the beginning (DROP the old tables before restarting)
© 2003-2006 Alexey Ozerov - BigDump Home
damn!
Scris: 04-Noi-2006, 11:10:59
de Etherfast
Da ma omule, trebuie sa faca o pauza de o ora la fiecare 9000 de query-uri executate, deci porneste-l si lasa-l pana termina.
Scris: 04-Noi-2006, 11:54:16
de Plutonium
pai il las ma si imi apare: BigDump: Staggered MySQL Dump Importer v0.26b
Processing file: atomicfun_lx_ro(2).sql
Starting from line: 9001
Error at the line 10434: INSERT INTO `phpbb_search_wordlist` VALUES ('exclusively', 12945, 0);
Query: INSERT INTO `phpbb_search_wordlist` VALUES ('exclusively', 12945, 0);
MySQL: User 'atomicfun_04' has exceeded the 'max_updates' resource (current value: 10000)
Stopped on error
Start from the beginning (DROP the old tables before restarting)
© 2003-2006 Alexey Ozerov - BigDump Home
si ii dau iar start from the beginig acum nu?
Scris: 04-Noi-2006, 11:57:46
de Etherfast
Ai pus la delay cele 3300000 de milisecunde cum ti-am spus mai sus?
Ai rulat in Internet Explorer (nu Firefox, Opera sau mai stiu eu ce)?
Da, trebuie sa astepti o ora, si acum o iei de la capat.
Scris: 04-Noi-2006, 11:59:22
de Plutonium
aa am rulat in firefox:(
Scris: 05-Noi-2006, 16:24:01
de Plutonium
BigDump: Staggered MySQL Dump Importer v0.26b
Processing file: atomicfun_lx_ro(2).sql
Starting from line: 9001
Error at the line 9001: INSERT INTO `phpbb_search_wordlist` VALUES ('dimineatza', 11110, 0);
Query: INSERT INTO `phpbb_search_wordlist` VALUES ('dimineatza', 11110, 0);
MySQL: User 'atomicfun_04' has exceeded the 'max_updates' resource (current value: 10000)
Stopped on error
Start from the beginning (DROP the old tables before restarting)
© 2003-2006 Alexey Ozerov - BigDump Home
rulai in ie si dupa ceva timp o ora si ceva daca nu 2 imi apare eroarea asta...