List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:June 5 2001 11:58pm
Subject:Re: restore table?
View as plain text  
Thank you very much for the reply.  I'll give it a try.

Richard

Jeremy Zawodny wrote:
> 
> On Mon, Jun 04, 2001 at 04:50:03PM -0700, Richard Reina wrote:
> 
> > I accidently overote a table in my database. I need to restore an
> > individual table from a backup that I made on tape drive with dump.
> > How can I restore just the individual table with restore -i.
> 
> Restore the <table>.{frm,MYI,MYD} files and copy them into MySQL's
> data directory.
> 
> To be safe, copy the files in place after you shutdown MySQL. Then
> start it back up and make sure the data you expect is there.
> 
> There are other ways which you can read about in the MySQL manual, of
> course. :-)
> 
> Jeremy
> --
> Jeremy D. Zawodny, <jzawodn@stripped>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878    Fax: (408) 349-5454    Cell: (408) 439-9951
> 
> MySQL 3.23.29: up 11 days, processed 68,909,279 queries (71/sec. avg)
Thread
restore table?Richard Reina5 Jun
  • Re: restore table?Jeremy Zawodny5 Jun
  • Re: restore table?Richard Reina5 Jun
  • install mysqlHeather Wagamon6 Jun