mysql rescue - SOS!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

mysql rescue - SOS!

Post by pelegk2 »

i had a mess and by accident over writen the the 2 of the 3 DB files with the extensions :
MYI and frm
the situation now it that i have a table with mroe then 100000 lines (which end with the file extension : MYD),but when i make for example cont() on the rows i recive 504 then 100,000!!!!
the problem is beaucse i have ovveriden files!!!
how can i fiex it so all the rows will be seen!!!
this is by the way the table structure if it help :

Code: Select all

ordc_id int(6) unsigned NOT NULL auto_increment,
  order_num varchar(8) ,
  order_date int(11) unsigned ,
  must_date int(11) unsigned ,
  done_date int(11) unsigned ,
  client_id int(9) ,
  makat varchar(14) ,
  qnt float ,
  unit_id tinyint(3) ,
  color text ,
  user_name varchar(10) ,
  status varchar(20) ,
  basis char(1) ,
  row_id int(5) unsigned ,
  mahsan char(3) NOT NULL DEFAULT '0' ,
  makat_givun varchar(14) ,
  tsir char(3) ,
  for_who varchar(30) ,
  printCount double NOT NULL DEFAULT '0' ,
  insertTime int(11) unsigned NOT NULL DEFAULT '0' ,
  updateTime int(11) unsigned NOT NULL DEFAULT '0' ,
  PRIMARY KEY (ordc_id)
thnaks in advvance
peleg
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

that's a lot of shouting and not a whole lot of making sense.. :?
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

ok i explain again

Post by pelegk2 »

i have mysql installed on windows
and there are 3 files for each table :
MYI and frm and MYD
the MYD file is the lines of the DB itself!
and 2 others i am not sure what they do execlly ( i will be glad if some 1 explains what each 1 of them does)
the thing is that the 2 files : MYI and frm were deleted and i put instead 2 other files which messed up everything!!!
now when i make a select on the db it tells me it has only 504 rows instead of more then 100,000
SOS
help pleasde
Post Reply