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 OUR
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?
>
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
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 some
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
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 b
