Since I did the backup with a |, it appended. I had to go through the file and remove the older instances of the backups and then it worked ok.
Thanks for the help! You all saved me. Scott -----Original Message----- From: D.K.Dubey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 9:14 AM To: Hathaway, Scott L Subject: Re: database restore - please help Hi Scott, One more simple way..u should have the mysql back ..copy the dir from \mysql\data (Old dir ) having name of the database. Copy to the new \mysql\data (current). Or delete the dir having name as database name cut that dir and place somewhere else for safe. Now run the script using given command. If still problem then open the backup.txt and delete that code having name of table for which showing error then run the query. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court, DLF phase IV Gurgaon, India Ph No :- 6392896/7 (O) --------------------------------------------------------------------- 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