#musicbrainz

chefkoch is now known as chefkoch_AW

HI - have a question in regards to restoring Musicbrainz db to postgres db--anyone around?

shoot

hey!

cool

so trying to import the db int a postgres/linux box

k

are you sure you're using the right svn branch?

20071024 ?

1014, sorry

for mb server or dump?

mb_server

that is the right branch that will import the current data dumps.

I fully run ./admin/InitDB.pl - and it runs through - takes time on each of the files - creates all dbs tables just fine - yet still no data in the tables after finishing...

other bnraches will fail.

k let me check what svn im using

what is your exact command line?

svn checkout http://svn.musicbrainz.org/mb_server/trunk mb_server

./InitDb.pl --createdb --import <file>

that's rong

yes - but w/o the --createdb since i create it before

./admin/InitDb.pl --echo --import mbdump*.tar.bz2

is what i run

will the svn command work the same?

yeah, just a different url.

make sure to get that out into a seperate dir

is there a reason why you create the db beforehand?

initdb does that

I'd drop the DBs and then let initdb do everything.

Senilix_W7 is now known as Senilix

so it should login using the DBDefs.pm settings?

and create it

no, dont

i just create it before just so dont have to worry about postgres junk and making it

but i can drop it and go for it without creating

good, that will save you hassle

so no need to do with createdb?

correct

ok good - thought i was ok - it was creating tables ok and going through - just no data being inserting

rebuilding server files now to run...

question - does the InitDb move the files to /tmp ?

that was likely the wrong svn branch issue

it unzips them to temp

can I specify the tmp location?

yes

./InitDb.pl --help

ahh --tmp-dir=/

thanks

quick qustion though - is that from the dir you run initdb.pl from?

I usually run it from the admin dir

ya but that dir would be from where you run the script, not root of server?

yes

k so just to confirm

./InitDb.pl --echo --import --tmp-dir=/tmp mbdump*.tar.bz2

im runnig that from within /admin and then i have a /tmp dir within /admin/ that will be used for tmp - i also am using the new branch

./InitDb.pl --echo --import --tmp-dir=tmp mbdump*.tar.bz2

otherwise it would use /tmp not ./tmp

./admin/InitDb.pl --echo --import --tmp-dir=tmp mbdump*.tar.bz2 Unknown option: tmp-dir

needed -- --

crap still i dont think is putting anything into db - no errors either

hey ruaok around?

got up to here

drop table trm;

Wed Nov 12 17:55:13 2008 : load trm trm 12404661 100% 116243 106.71 sec Error loading tmp/MBImport-1cpxoLeH/mbdump/trm: Error loading data at /backup/httpd/musicbrainz/mb_server/admin/MBImport.pl line 304. $sql->Rollback called without $sql->Begin at /backup/httpd/musicbrainz/mb_server/admin/MBImport.pl line 315 Failed to import dataset. Wed Nov 12 17:57:10 2008 : InitDb.pl failed

svn info Path: . URL: http://svn.musicbrainz.org/mb_server/branches/R... Repository Root: http://svn.musicbrainz.org Repository UUID: b0b80210-5d09-0410-99dd-b4bd03f891c0 Revision: 10688 Node Kind: directory Schedule: normal Last Changed Author: murdos Last Changed Rev: 10521 Last Changed Date: 2008-10-21 14:23:03 -0700 (Tue, 21 Oct 2008)

anyone around?

Hey all, I have a question about automated querying of the musicbrainz database. I am writing a plugin that queries the server for information about selected tracks. Sometimes I need to retrieve 4 or 5 albums in order to disambiguate similarly named albums. I know you request that we limit our queries to once per second, but I wasn't sure if this was just talking about sustained queries greater than one per second, or was saying that small batch

puffyz: it doesn't look like you're executing this from the right branch.

do this:

2. Fix up DBDefs.pm as needed.

3. cd $(topsrc)/admin

./InitDb.pl --createdb --import <files>

drop the old DBs first.

just do that and nothing else.

thats what i did last time

did you see my svn info

how much

space will the database take on the postgres side

svn info Path: . URL: http://svn.musicbrainz.org/mb_server/branches/R... Repository Root: http://svn.musicbrainz.org Repository UUID: b0b80210-5d09-0410-99dd-b4bd03f891c0 Revision: 10688 Node Kind: directory Schedule: normal Last Changed Author: murdos Last Changed Rev: 10521 Last Changed Date: 2008-10-21 14:23:03 -0700 (Tue, 21 Oct 2008)

quit

last.fm.fail

ruok around?

Amblin is now known as Guest95510

so sick of my songs by Brak coming up as Space Ghost

Amblin is now known as Guest81816

teleguise is on drugs, wtf would I be counting birds for ? wtf :P

aw FINALLy sunrise

Yaaaaaaaaaaaaarwn.

hangy_ has joined #MusicBrainz

\ø/

I finally found the right incantation to fix the garbles chars on the ajax functions.

oooh?

what was it?

the perl JSON module was changed from version 1 to 2.

we decided to migrate, but didn't realize that this would be affected.

ah right

yep, both cases work fine now.

ok, fix is live on test.

unfortunately I've got more bugs for you :P

hopefully not ones which are so awkward though

hmm...

#4081 ?