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
