Thank you VERY much for your help Derision. That worked perfectly luckily my character_backup table was intact. I ended up restoring about 20 characters with it
As for how it happened. I am not sure. I do keep backups but perhaps I need to re-look at how I do that. I do my backups with a programme called Auto Backup For MySQL. Which normally seems to work. As it allows me to back up daily automatically.
I did try to restore the Character_ table from an older backup. But it was still corrupt.
More than probably my fault. I must have messed something up today. When backing up.
Once again thank you very much for the fast response and for the solution it worked flawless.
One thing this has gotten my attention now. I need to look at a better way to backup the data.