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

Reply via email to