FUDforum: How To » Data dump hangs

Home » FUDforum » How To » Data dump hangs

Show: Today's Messages :: Polls :: Message Navigator

Re: Data dump hangs [message #34151 is a reply to message #34111]

Mon, 09 October 2006 00:20

mdbrown

Messages: 18
Registered: December 2005

Karma:

Junior Member

To heck with using the browser interface to import. The command line is the way to go. I copied admimport.php to cliimport.php and modified it with the --

define('recovery_mode', 1);
$_POST['path'] = '/path/to/dumpfile';

-- method, and fired if off in background mode. Now we're getting somewhere! So far, it has processed 350,000 queries in about an hour and a quarter, so it's not quite half-way finished yet, but it's processing to beat the band. I'm guessing it will take about three hours or so to import the entire 800,000 record dump.

At some point, if no one else has done so, I'll modify both clidump.php and cliimport.php to output non-HTML text to the terminal.

For large, time-consuming operations, running scripts via the command line can't be beat.

Report message to a moderator

[Message index]

		Data dump hangs By: mdbrown on Fri, 06 October 2006 05:09
		Re: Data dump hangs By: Ilia on Fri, 06 October 2006 15:05
		Re: Data dump hangs By: mdbrown on Fri, 06 October 2006 18:14
		Re: Data dump hangs By: Ilia on Sat, 07 October 2006 00:10
		Re: Data dump hangs By: mdbrown on Sat, 07 October 2006 21:29
		Re: Data dump hangs By: mdbrown on Sun, 08 October 2006 05:56
		Re: Data dump hangs By: mdbrown on Sun, 08 October 2006 07:33
		Re: Data dump hangs By: mdbrown on Mon, 09 October 2006 00:20
		Re: Data import blows up By: mdbrown on Mon, 09 October 2006 01:09
		Re: Data import blows up By: mdbrown on Mon, 09 October 2006 01:28
		Re: Data import blows up By: mdbrown on Mon, 09 October 2006 03:32
		Re: Data import blows up By: Ilia on Mon, 09 October 2006 13:49
		Re: Data import blows up By: mdbrown on Mon, 09 October 2006 20:36
		Re: Data import blows up By: Ilia on Tue, 10 October 2006 13:27

Previous Topic:	Attachment problem
Next Topic:	how view one image in a post

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 12:52:01 GMT 2024

Total time taken to generate the page: 0.04712 seconds