EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Tutorials/Howto's (https://www.eqemulator.org/forums/forumdisplay.php?f=619)
-   -   Updating DB (https://www.eqemulator.org/forums/showthread.php?t=12829)

Loosenut 04-04-2004 03:07 AM

Updating DB
 
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:
Quote:

Originally Posted by samandhi
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.


All times are GMT -4. The time now is 01:23 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.