have u checked if u have that file in ur mysql directory ?
lets say that u don't have that missing file :
- if u have a backup of ur character_ table, do this :
use eq;
drop table character_;
source yourbackup.sql
it will recreate all the necessary files.
- if u don't have any backup, first, copy all the character_.* files into a diff directory, u ll need them later.
log into mysql :
use eq;
drop table character_;
CREATE TABLE character_ ( id int(11) NOT NULL auto_increment, account_id int(11) NOT NULL default '0', name varchar(64) NOT NULL default '', profile blob, guild int(11) default '0', guildrank tinyint(2) unsigned default '5', x float NOT NULL default '0', y float NOT NULL default '0', z float NOT NULL default '0', zonename varchar(30) NOT NULL default '', zoneid smallint(5) not null default '0', alt_adv blob, PRIMARY KEY (id), UNIQUE KEY name (name), KEY account_id (account_id)) TYPE=MyISAM;
this will recreate a clean character_ table. Now, copy the character_.* files u saved earlier in ur mysql/var dir, and ur problem should be fixed... i hope )
Muuss
|