Recreation of the table removed that error, but it seems that I still got corrupted tables.
<i>Table 'databasename.ezuser' doesn't exist</i>
Is there any location in the instalation files I can find the <i>CREATE TABLE 'tablename' </i> definiton for other tables as shown in André R. ' s reply ??
What will the syntax be for recreating the 'ezuser' table ?? If recrating the 'ezusers' table, how to recreate the admin user from mysql ?? Ezpublish is version 4.13/ Mysql
You can't recreate other tables like this. Well you can, but you'll lose data and make the whole site unstable as other tables might contain data that depends on the table you recreate. In the case of ezuser, it's the users of the system, without it, no one can login.
If you have to get data out of the database, you could try to rename the table, install a fresh eZ Publish install separately and copy the ezuser table over. Then anonymous (id=10) and admin (id=14) will normally work. But you'll probably just hit another table that is corrupted, and you will most likely not be able to do the same with that one.
This is the very reason why backups to external media are important.