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, <[EMAIL PROTECTED]>
> 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)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php