Mysql Question

Bayman · #1 03-15-2002, 06:49 PM

Ok, with the new upgrade.sql, I've been having a little trouble getting it into my eq database. I'm a complete fool when it comes to mysql, so I need a little help getting this thing working.

1) I tried manually adding the parts of upgrade.sql to the main db.sql, scrapping the eq databse and adding it that way, but I there is a lot of beeping involved and it generally doesn't work. I can't get passed the character selection screen, it gives me the "loss of connection" error.

2) Next, I loaded the db.sql normally, and then did "source upgrade.sql" but that doesn't seem to do it either. The thing beeps and spits out errors like crazy, and I can't stand the noise long enough to wait the thing through.

Any help or admonishments are much oppreciated.

-Bayman

PaulieWalnutz · #2 03-16-2002, 01:42 AM

First all you have to do is source upgrade.sql

Be patient because it will overwrite alot of files. Thats normal.
If you not patient enough to wait ti through then your not gunna see the changes.

ibleet · #3 03-16-2002, 06:03 AM

Paulie is absolutely right!

1 Just source the upgrade.sql (run mysql.exe, type "use eq", type "source upgrade.sql", make sure the upgrade.sql is in the mysql/bin directory first.

2 TURN OFF THE SOUND

3 Go get a snack / take a break / etc.

4 DONE!

Bayman · #4 03-16-2002, 08:36 PM

Heh, yah thanks guys. Found out the command to disable the sound in Mysql, made it a lot easier.

-Bayman