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... Thanks... Regards, Ritu --------------------------------------------------------------------- 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