[pLog-svn] r3274 - in plog/trunk: . class/configclass/databaseconfig templates/wizard

[Mark Wu]

Maybe we can just zip the mysql database folder (as I know different
database has different folders ) ...

Not so sure.

Mark

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Jon Daley
> Sent: Friday, April 28, 2006 12:01 AM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] r3274 - in plog/trunk: . 
> class/configclass/databaseconfig templates/wizard
> 
>  	There is a binary format, I believe, though I don't 
> know if it affects the import speed all that much.
> 
> On Thu, 27 Apr 2006, Oscar Renalias wrote:
> 
> > I had the same problem this morning. I tried to restore the 
> dump in my 
> > work laptop (an ibm t-40 with a 1.6ghz pentium-m) just to 
> see how fast 
> > the data generation script would work in it, and after 5 
> hours it had 
> > only managed to load about 100.000 records of the 
> lt_articles_comments 
> > table, out of over 200.000. I don't know if there is a 
> better format 
> > for mysql dumps, but if we ever manage to get a dump with 500.000 
> > comments, it's going to take more than
> > 2 days to restore it!
> >
> > Oscar
> >
> > On 27 Apr 2006, at 15:37, Jon Daley wrote:
> >
> >> 	Restoring the dump is taking forever.  My machine load 
> is at 16... I 
> >> am not sure why it is taking so long - The system is RAID5, but I 
> >> hadn't seen disk writes be a bottleneck before, and it seems to be 
> >> the disk causing the trouble now.
> >> 
> >> 
> >> On Wed, 26 Apr 2006, Oscar Renalias wrote:
> >>> 2) restore the 450mb dump that I linked to a couple of days ago
> >>> (http://www.lifetype.net/test_dump_20060424.sql.bz2) This is not 
> >>> strictly necessary, but if we want to reach the target of 10.000 
> >>> blogs, you'll get a head start with 5000 blogs already in place.
> >>> 
> >>> 3) Run generateData.php from the command line (you will 
> need to move 
> >>> it from the tools/ folder to the root LT folder)
> >>> 
> >>> I was using the following command line to run the script from the 
> >>> command line, creating 100 blogs at a time. There is a 
> pause in the 
> >>> end so that I get time to stop the process if needed, instead of 
> >>> interrupting its processing while it's working (I don't want to 
> >>> interrupt it while it's adding data) But you can do it in any way 
> >>> you like :-)
> >>> 
> >>> while true; do php generateData.php; echo "-- 5 sec break 
> --";sleep 
> >>> 5;done
> >> _______________________________________________
> >> pLog-svn mailing list
> >> pLog-svn at devel.lifetype.net
> >> http://devel.lifetype.net/mailman/listinfo/plog-svn
> >> 
> >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://devel.lifetype.net/mailman/listinfo/plog-svn
> 
> **************************************
> Jon Daley
> http://jon.limedaley.com/
> 
> We know about as much about software quality problems as they 
> knew about the Black Plague in the 1600s. We've seen the 
> victims' agonies and helped burn the corpses. We don't know 
> what causes it; we don't really know if there is only one 
> disease. We just suffer - and keep pouring our sewage into 
> our water supply.
> -- Tom Van Vleck
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn