Updating DB

Loosenut · #1 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 · #2 04-04-2004, 05:01 AM

Did you put the db.sql file in your /mysql/bin directory?

Loosenut · #3 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 · #4 04-04-2004, 05:37 AM

But:

Quote:

Originally Posted by samandhi

Did you put the db.sql file in your /mysql/bin directory?

Loosenut · #5 04-04-2004, 05:45 AM

samandhi · #6 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 · #7 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 · #8 04-04-2004, 07:31 AM

Error 1136 : column count doesnt match...........

DrizztBanrae · #9 04-06-2004, 04:05 AM

I'm getting the same error...any help on this?

govtcheeze · #10 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.