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
