[mb-devel] Full DB import error

[Elliot Chance]

Well, the musicbrainz_db works on mysql winxp. However... it's totally
impractical. MySQL goes unbelievably slow, before its even loaded the
majority of the data into the tables. It seems that the daemon can't handle
databases much bigger than 1GB on winxp.

And when I did a simple search of the album table, it took 39 seconds to
search 391K albums.

But the script I made to create the tables and load the data in works. So I
will test it on fedora core 5 tomorrow

On 7/18/06, Steve Wyles <steve at inhouse.co.uk> wrote:
>
> On Tue, 18 Jul 2006, Elliot Chance wrote:
>
> > I don't know the versions, but I am using the unmodified virtual server
> > downloaded from the mb site.
>
> Ah! I think the albummeta table has changed since that was created.
>
> There is an extra puids column in that table now. That would be the
> reason!
>
> Compare your CreateTablesSql.pl with the one at
>
> http://bugs.musicbrainz.org/browser/mb_server/trunk/admin/sql/CreateTables.sql
>
> add the puid stuff in the correct places (not only in albummeta), drop the
> database and rerun the import creating the db at the sametime.
>
> Steve
>
> _______________________________________________
> MusicBrainz-devel mailing list
> MusicBrainz-devel at lists.musicbrainz.org
> http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-devel
>



-- 
Cheerfully,
Elliot
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.musicbrainz.org/pipermail/musicbrainz-devel/attachments/20060718/123a13d3/attachment.htm