Re: BLOB backup - Jim Tyrrell - com.mysql.lists.java

13 messages in com.mysql.lists.javaRe: BLOB backup

From	Sent On	Attachments
Jim Tyrrell	12 Apr 2003 06:53
Christopher Taylor	13 Apr 2003 04:06
Jim Tyrrell	13 Apr 2003 06:53
Christopher Taylor	13 Apr 2003 21:13
Jim Tyrrell	14 Apr 2003 14:11
Tim Endres	14 Apr 2003 17:54
Pål Arne Hoff	15 Apr 2003 03:04
Jim Tyrrell	16 Apr 2003 16:08
Brian Tarbox	16 Apr 2003 20:06
Keith Hatton	17 Apr 2003 00:49
Brian Tarbox	17 Apr 2003 04:47
Keith Hatton	17 Apr 2003 04:54
Jeremy Zawodny	17 Apr 2003 10:44

Subject:	Re: BLOB backup
From:	Jim Tyrrell (jimt...@yahoo.com)
Date:	04/14/2003 02:11:18 PM
List:	com.mysql.lists.java

Chris,

My DB is about 3 GB and when it gets to the Blob table it seems to hang. Does anyone else have some thoughts.

--- Christopher Taylor <csta...@nanshu.com> wrote:

Hi Jim,

Our database is about 10MB (mostly consisting of PNG images), and all I need to do is:

mysqldump database-name > database-name.dump

Comes back in about a minute.

We're using MySQL 4.X.

----- Original Message ----- From: "Jim Tyrrell" <jimt...@yahoo.com> To: "Christopher Taylor" <csta...@nanshu.com>; <ja...@lists.mysql.com> Sent: Sunday, April 13, 2003 10:53 PM Subject: Re: BLOB backup

It seems to hang for a long time. Do I need to wait for a long time? I saw something in the docs about flushing, but I was not sure what I should do? Each blob is anywhere from 40K to 9000K .

What command line options are you using? Please leave off passwords ;) and also let me know how big your blobs are, MySQL version, and what kind of blob data. I have only jpeg in mine.

Thank You Jim Tyrrell

--- Christopher Taylor <csta...@nanshu.com>

wrote:

BLOB backup with mysqldump works fine for me.

What problems are you encountering?

-Chris

----- Original Message ----- From: "Jim Tyrrell" <jimt...@yahoo.com> To: <ja...@lists.mysql.com> Sent: Saturday, April 12, 2003 10:53 PM Subject: BLOB backup

Everyone,

I know this is not a java quesion but it does follow on to my blob questions of a few months ago.

must

say that storing the images in MySQL instead

the

old file system based thing I had is awesome.

have

over 10000 images avg about 300K and it works great.

However I am trying to get backups of that

binary

data

and it appears that mysqldump does not do

that.

Do I

need to get the innodb backup utility? Is there another backup way in mysql besides mysqldump?

On a side note where did the searching go for newsgroups @ mysql.com?

Thank You Jim Tyrrell

__________________________________________________

Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com

-- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe:

http://lists.mysql.com/java?unsub=csta...@nanshu.com

-- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: