Corrupt database, how can I replace it?

[SameSegFaultDifferentDay]

Think I had a bad sector on my drive:

looks like the MYI for hydro_whos_online is corrupt?

any clues how I can replace it?

Many thanks.

1016 Can't open file: 'hydro_whos_online.MYI' (errno: 145)
in:
[delete from hydro_whos_online where time_last_click < '1161431208']

Seggie

[Ajeh]

Try doing a repair on the database via phpMyAdmin ...

If that does not work the table can be rebuilt with:

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
  customer_id int(11) default NULL,
  full_name varchar(64) NOT NULL default '',
  session_id varchar(128) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  time_entry varchar(14) NOT NULL default '',
  time_last_click varchar(14) NOT NULL default '',
  last_page_url varchar(255) NOT NULL default '',
  host_address text NOT NULL,
  user_agent varchar(255) NOT NULL default '',
  KEY idx_ip_address_zen (ip_address),
  KEY idx_session_id_zen (session_id),
  KEY idx_customer_id_zen (customer_id),
  KEY idx_time_entry_zen (time_entry),
  KEY idx_time_last_click_zen (time_last_click),
  KEY idx_last_page_url_zen (last_page_url)
) TYPE=MyISAM; 

NOTE: if using database prefixes you would need to alter the table name from:
whos_online

to be:
yourprefix_whos_online

in two places before running that in the SQL box ...

[SameSegFaultDifferentDay]

Thanks Ajeh, that worked great.

Really appreciate your help sir,

now I just need figure out how to upgrade to latest version ;)

peace and thanks.

Seggie

[confusedIam]

Hi,
I am posting here as maybe I have a like database problem. When going to the store front (it isn't live, though) I get the following: (also the admin areas seem to be working except the catalog section which throws a lot of info at me but I am weak on Greek :-) )

-------
1016 Can't open file: 'products.MYI'. (errno: 145)
in:
[select distinct m.manufacturers_id as id, m.manufacturers_name as name from products p, products_to_categories p2c, manufacturers m where p.products_status = 1 and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '0' order by m.manufacturers_name]
----------

I have no knowledge of doing stuff in tables in mySql but if I know that this is most likely a database crash I can inquire of my server to take a look at that.

Also, anyone recommend any book on learning how to do things to the database as suggested above in a step-by-step fashion from where you do this and how not to screw it up? :-)

Thanks,
Rand

[confusedIam]

Hello, again.
Just wanted to say it must have been a database crash, the server people 'rebuilt' or 'repaired' it and all seems okay now. I also inquired of them of any book about mySql and/or phpMyadmin panel that might help me do this stuff myself.
Thanks,
Rand