The normal way to do it is to pipe it to the mysql command line client which will make it enter batch mode and run the .sql file. The basic syntax will look something like:
mysql -p database < file.sql This should work in windows or in any unix environment. This is also assuming the file is in SQL statement format, like mysqldump gives, and not in a tab-delimited file or anything similar to that. Hope that helps you out. Harrison ----- Original Message ----- From: "Bensin Joseph" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 19, 2002 6:04 PM Subject: FW: Resorting entire Database > > > Hello Everyone. > > I backed up my entire db to data.sql file and now I want to restore and I > don't know the right procedure could someone help. > > > > --------------------------------------------------------------------- > 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
