On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote: > Hi!! > > I used BACKUP TABLE command to take the backup of a > table...but when i say > RESTORE TABLE, i get the following :: > > > mysql> restore table rs from '/tmp'; > +-------+---------+----------+--------------------------+ > | Table | Op | Msg_type | Msg_text > | > +-------+---------+----------+--------------------------+ > | rs | restore | error | Failed copying .frm > file | > +-------+---------+----------+--------------------------+ > 1 row in set (0.00 sec) > > The output after BACKUP TABLE was :: > mysql> backup table abc to '/tmp'; > +----------+--------+----------+----------+ > | Table | Op | Msg_type | Msg_text | > +----------+--------+----------+----------+ > | ritu.abc | backup | status | OK | > +----------+--------+----------+----------+ > 1 row in set (0.00 sec) > > > Pls. tell me where i went wrong....i locked the table > before backup...
What version of MySQL are you using? I've reproduced the bug in 3.23.47, but found that it works just fine in 4.0.2. You might check the change logs to see if it was fixed in a release after the one you're using. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 92 days, processed 2,398,838,413 queries (301/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
