Re: MySQLDump and Restore

2006-04-21 Thread Mohammed Abdul Azeem
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]



RE: MySQLDump and Restore

2006-04-21 Thread Arjan Hulshoff
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]