PDA

View Full Version : Updating DB


Loosenut
04-04-2004, 03:07 AM
OK, i downloaded the file and then sourced them.. but when i sourced DB.sql .. i keep getting errors.

AM i doing it wrong?

samandhi
04-04-2004, 05:01 AM
Did you put the db.sql file in your /mysql/bin directory?

Loosenut
04-04-2004, 05:33 AM
When i source it, it begins then it starts saying Error 1113(or sumthing like that) balh blah blah blah

samandhi
04-04-2004, 05:37 AM
But:
Did you put the db.sql file in your /mysql/bin directory?

Loosenut
04-04-2004, 05:45 AM
yes

samandhi
04-04-2004, 06:57 AM
Im not sure of why you would get errors with this.. Ill try and look into it after a bit, and get back to you on it..:)

Loosenut
04-04-2004, 07:13 AM
I think it's because i have 2 DB's trying to source them both makes it Overwrite and then at one point it says the same error x infinity

Loosenut
04-04-2004, 07:31 AM
Error 1136 : column count doesnt match...........

DrizztBanrae
04-06-2004, 04:05 AM
I'm getting the same error...any help on this?

govtcheeze
04-06-2004, 04:14 AM
The error means the table definitions are different, and will result in an empty table. You should not source db.sql if you want to use MW.

Duplicate entry error on key errors are fine...its just a warning letting you know the index already exists in the database, and it will ignore the INSERT statement.