Or use mysqlimport... Typ 'mysqlimport --help' for further assistance. There are more usefull tools in the bin directory of your mysql installation.
HTH, Arjan. -----Original Message----- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 09:03 AM To: Jim Cc: mysql@lists.mysql.com Subject: Re: MySQLDump and Restore Hello Jim, mysql -u root -p ROOTPASSWD < dump.sql Thanks, Abdul. On Fri, 2006-04-21 at 17:02 +1000, Jim wrote: > Hi All, > > > > Am using mySQLDump to backup db as follows > > mysqldump --databases OURDB -uroot -pROOTPASSWRD > dump.sql > > > > How can I restore OURDB from dump.sql? > > > > Thanks > > Jim > > > > > ________________________________________ This email has been Scanned for Viruses! www.newbreak.com ======================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]