|
|
Posted by Charles Sweeney on 12/19/88 11:36
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?
--
Charles Sweeney
http://CharlesSweeney.com
Navigation:
[Reply to this message]
|