Posted by John Bokma on 01/17/95 11:36

Charles Sweeney <me@charlessweeney.com> wrote:

> John Bokma wrote
>
>> If anyone has tips to speed things up?
>>
>> i.e mysql -ufoo -p -database bar < dump.sql takes ages and ages, even
>> locally. I know that the inserts are done one by one (not the smart
>> way), but why my harddisk is spinning for 20-30 minutes when I do
>> something like this is beyond me. Can't remember that it was that
>> slow in the past.
>
> I experimented once using mysql from the command line. I was
> impressed by how fast it was, compared with phpmyadmin.
>
> I had the same problem when trying to reinstall a lot of data through
> phpmyadmin, it was either timing out on me, or giving errors (can't
> remember exactly).
>
> For my command-line test I was using a local data file, so in the
> example you gave, you would still have to upload it somehow. I
> suppose then the question is what is the quickest way to do this, ftp,
> wget, other?

By looking at the local run, 5M of data takes like 40 minutes to get
inserted, I would say that the upload time isn't the problem. I will time
it exactly later today, and compare my old mysql install with the new one.

--
John Perl SEO tools: http://johnbokma.com/perl/
or have them custom made
Experienced (web) developer: http://castleamber.com/

[Back to original message]