problema restaurare mysql

[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

[Plutonium]

deci zimi in ce fisier tre sa modific

[Etherfast]

bigdump.php - SINGURUL fisier din arhiva...

[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?

[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!

[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.

[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?

[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.

[Plutonium]

aa am rulat in firefox:(

[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...