Posted by William Tasso on 01/20/69 11:36

Fleeing from the madness of the Castle Amber - software development jungle
John Bokma <john@castleamber.com> stumbled into
news:alt.html,alt.websites,alt.www.webmaster
and said:

> Charles Sweeney <me@charlessweeney.com> wrote:
>
>> John Bokma wrote
>>
>>> Charles Sweeney <me@charlessweeney.com> wrote:
>>>
>>>> John Bokma wrote
>>>>
>>>>> "Paul Watt" <paulio@wattioNOSPAM.freeserve.co.uk> wrote:
>>>>>
>>>>>> Hi Guys,
>>>>>> I'm using PhpBB and I want to customise it to fit it seamlessly
>> with
>>>>>> my site. I dont want to use an iFrame to integrate it. my question
>> is
>>>>>> do I have to mess around with the subsilver templates or do I have
>> to
>>>>>> alter the PHP index file?
>>>>>
>>>>> The former, and be prepared for a lot of "fun"
>>>>
>>>> Particularly at upgrade time!
>>>
>>> Don't get me started
>>
>> LOL!! I share your pain!
>
> Another painful experience was when I convinced a friend to drop her
> friend as a hosting solution, also because you could use phpmysqladmin
> (or
> whatever it's called) without a password (!).

"also" or just? - are you saying there's a serious flaw in MySQL or the
admin app, or perhaps in that particular installation?

> Anyway, uploading a phpbb database to a new host turned out not to be a
> piece of cake. I have no idea why uploading a mysql database with
> 100,000+
> records should take a lifetime and more. (The webbased thingies couldn't
> handle it,

timeout or some other issue?

? so I connected with the mysql client, hurray for the CLI).

heh - and open 'firewalls'

> 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),

assuming a db made up of several interlinked tables, it has to be that 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.

well, it's building all the indexes on the fly and that is an expensive
process.

Personally, I like the SQL Server method of storing each db in a separate
disk file that can be copied and attached to a new engine. Not that this
helps you in any way.
--
William Tasso

Save the drama
for your Mama.

[Back to original message]