<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">What do the mysql error logs say? If they show nothing then restart mysql in debug mode and run it again and see what it says.<div><br></div><div>Once you actually have some errors then you can start looking for a solution.</div><div><br><div> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>- Steven</div></div></span> </div><br><div><div>On 1-Jun-09, at 11:41 PM, Chris Bruner wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Is mysql configured the same in all cases?<br>Is mysql version the same in all cases?<br><br>If a large database is dumped can it import it ok, (ie is it your script or the mysql that's the problem).<br><br>Those are the questions I'd be asking.<br><br>Insurance Squared Inc. wrote:<br><blockquote type="cite">I've got a script that's importing pages into a wordpress (website) database. The script is not behaving consistently and the culprit seems to be mysql. The inconsistency is what's puzzling. I've experienced the same consistent inconsistency across two machines now.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">For example I imported 6 blocks of 500 pages each without any problem. It imported and ran fast. Then I deleted the database and recreated it (due to unrelated issues). I then imported 2 of the same blocks again and it was dead slow importing each page. The third block I imported, the script output looked like it barfed the mysql database all over my terminal session :). Restarting mysql regularly doesn't seem to fix it.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I have noticed that it will tend to die earlier and earlier. i.e. if it dies on page 100 and I don't restart mysql but delete the pages and start again, it'll die on page 97 next time, then page 92 if I try it again, and so on. That's as consistent as I've got. It seems to die at different places even if I try to keep inputs the same.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Any ideas what would cause mysql to do this? Perhaps something's not getting flushed or a cache? I did the last run on my desktop so there really wasn't much else running on the machine. Our developer spent 2-3 days and decided that mysql was timing out (I don't think so :) ) and this seems to be so vague that Google doesn't even know where to start.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">g.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">kwlug-disc_kwlug.org mailing list<br></blockquote><blockquote type="cite"><a href="mailto:kwlug-disc_kwlug.org@kwlug.org">kwlug-disc_kwlug.org@kwlug.org</a><br></blockquote><blockquote type="cite"><a href="http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org">http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org</a><br></blockquote><blockquote type="cite"><br></blockquote><br><br>_______________________________________________<br>kwlug-disc_kwlug.org mailing list<br><a href="mailto:kwlug-disc_kwlug.org@kwlug.org">kwlug-disc_kwlug.org@kwlug.org</a><br>http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org<br></div></blockquote></div><br></div></body></html>