EQEmulator Forums - MYSQL problem

ok i am kinda new to mysql and have a few questions about how to maintatin my db
first is there a command i can run to check a db for errors?
an i able to remove whatever.sql after i have sourced it?
do i always have to start out with \u eq; when useing the dos command?
i have used eqmeu-adim4.9 and mysql-front, mysql front seem a bit buggy but it seemed to get the job done...i used it to source myraDB.sql into the eq db and this was after adding db.sql and the latest dumpeditems.sql <oddly the myraDB.sql 12meg file took a whole 38 hours to finish> also i have a small 0.5.2-update.sql, but i don't recall sourcing this one, anyway after i rebooted everything i started world.exe and also loaded 4 zone files, everyting checked out so i connected to the server, worked just fine, had some "ghost NPC" and a few guards stacked on top of each other, i even sellected one and used the #spawndbfix or whatever that command was and the guy disappeared so i was happy, whatever...
not sure if anyone else could connect cause it was like 4 in the morning, but before adding myraDB several ppl logged in and without npc spawns and spell the game seemed to play great, so i am almost sure that others could have logged, if not so late..
also after i added myradb, i tried adding Myraitems.sql and got errors in the 1st line so i cancelled it, so i left the server running and left my character connected and when to work, come home the player is still standing there so i reboot both computers and try again now i seem to be getting errors in mysql, i am unable to properly connected to the eq databace with eqemu-admin and mysql-front always close to the same error: mysql-front states
"SQL execution error # 1030. Responce from the database: Got error 127 from table handler" thats when i try to click on accounts in the eq tree, when i try to connect to to my server i get

Code:

World server listening on: 65.60.130.162:9000

Connected to LoginServer: eqlogin3.eqemulator.net:5997

63490 New TCP connection: 127.0.0.1:1091

63540 New TCP connection: 127.0.0.1:1092

New zoneserver: #1 127.0.0.1:1092

New zoneserver: #2 127.0.0.1:1091

63600 New TCP connection: 127.0.0.1:1093

New zoneserver: #3 127.0.0.1:1093

Zoneserver SetConnectInfo: 127.0.0.1:1093: 65.60.130.162:7998

Zoneserver SetConnectInfo: 127.0.0.1:1091: 65.60.130.162:7999

Zoneserver SetConnectInfo: 127.0.0.1:1092: 65.60.130.162:7997

64420 New TCP connection: 127.0.0.1:1096

New zoneserver: #4 127.0.0.1:1096

Zoneserver SetConnectInfo: 127.0.0.1:1096: 65.60.130.162:7996

567760 New client from ip: 65.60.227.31 port: 1375

Logged in: FirstLogin LS#41010: dank

Logged in: FirstLogin LS#41010: dank

Error in GetCharSelectInfo query 'SELECT name,profile,zonename FROM character_ W

HERE account_id=2 order by name' #1016: Can't open file: 'character_.MYI'. (errn

o: 145)

Received unknown opcode: 0x02db size:0 bytes

Received unknown opcode: 0x00f0 size:0 bytes

Client disconnected

Removing client from ip:65.60.227.31 port:1375

i ran testeverquest.exe this morning jan. 14th and there seems to have been a pretty major update so i might have screwed myself in another way :!: