MySQLDump and Restore

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

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

RE: MySQLDump and Restore

: 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

Binary data mysqldump and restore.

Hi all... !! First, can you CC to [EMAIL PROTECTED], as im not on the mailing list. I have a few tables which are storing a few MB of binary data (like jpegs). I can dump the db fine using mysqldump, but on doing a mysql ... dumpfile i get many errors, as it seems mysql isnt accepting the

FW: Binary data mysqldump and restore.

Just for those people who have the same problem: -Original Message- From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:13 To: Bert VdB Subject: Re: Binary data mysqldump and restore. That did it thanks! MWP Hi, Have you tried making a dump

Re: Binary data mysqldump and restore.

If I remember correctly from the manual, you can dump your data generating the SQL statements (this is what you are doing) and your file will have a bunch of INSERTS. Your problem is that those inserts will have something like SET YourBinaryField = 'a-bunch-of-characters'. The problem is that