Beno, I cannot believe I am a beginner and the "pro" developer Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> could not answer your question. I believe you are reading/issuing the command incorrectly. The "pro" developer Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> did not read your email properly.
use: cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber If I am incorrect, please advise. Someone please help to rid the world of the underscore and it's many mis-interpretations, john -----Original Message----- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 1:38 PM To: [EMAIL PROTECTED] Subject: HELP! Hosed Database! But I have a backup, if I just knew how to restore it! The instructions read: #mysqldump --opt database_name > database_name_File.txt To restore database: #cat database_name_File.txt | /path/to/mysql -u username -p database_name So, if my installation is at /apache/mysql and the database is /apache/mysql/lefeber and my backup is /apache/mysql/lefeber.txt then I should be able to issue this command: cat lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber Why does it tell me that /apache/mysql is a directory (duh) and break the pipe? BenO --------------------------------------------------------------------- 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
