cant create character

[kasting]

when i log into my server and create character it says name rejected

in world.exe says

Logged in: FirstLogin LS#59302: kastingxx
Error in GetCharSelectInfo query 'SELECT name,profile,zonename FROM character_ W
HERE account_id=1 order by name' #1016: Can't open file: 'character_.MYD'. (errn
o: 145)
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Abcd race:12 class:5
Error in ReserveName query 'INSERT into character_ SET account_id=1, name='Abcd'
, profile=NULL' #1016: Can't open file: 'character_.MYD'. (errno: 145)

any way to fix this?

[Derision]

I googled for that error and read a few threads. You could try a repair of the character_ table, e.g.:

C:\>mysql -u root 57dr1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.12-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> repair table character_ ;
+------------------+--------+----------+----------+
| Table            | Op     | Msg_type | Msg_text |
+------------------+--------+----------+----------+
| 57dr1.character_ | repair | status   | OK       |
+------------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql>

[kasting]

o ok ty it works now