i'm using Mysql ver. 3.23.49... Ritu
On Fri, 10 May 2002, Jeremy Zawodny wrote: > 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 > > > --------------------------------------------------------------------- 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