Re: How Can I Auto Delete my Binary Files?

2008-07-10 Thread Eric Bergen
Shaun, Purge master logs is available in 4.0 it just doesn't have the "before" key word. It should be trivial to write a script that decides which log file to purge based on the mtime. -Eric On Thu, Jul 10, 2008 at 12:15 PM, Shaun Adams <[EMAIL PROTECTED]> wrote: > I'm running a RHEL 4.1 and MyS

How Can I Auto Delete my Binary Files?

2008-07-10 Thread Shaun Adams
I'm running a RHEL 4.1 and MySQL 4.0.26 so a lot or the more recent commands available in 5.0.x aren't available to me. Does anyone know of any scripts or anything I can use to delete files that arent being used or run by my slave servers? It's pretty safe to say that I can delete log files o

What about binary files? [was: Re: transfer huge mysql db]

2008-01-29 Thread Erik Giberti
All, InnoDB and MyISAM tables are platform independent, is there a reason why transferring the actual binary files from one system (or mount point) is not advised? From like OS to like OS, this seems like it should be okay and you'll only get into trouble with Float/Double.

Re: need help in updating old binary files to database slave

2006-05-15 Thread sheeri kritzer
is because it's at the end of the logfile -- check out the position, and then check out the length of the file. -Sheeri On 5/15/06, balaraju mandala <[EMAIL PROTECTED]> wrote: Hi Comunity, I need some help from you. In replication i want to update old binary files, but server is not upda

need help in updating old binary files to database slave

2006-05-15 Thread balaraju mandala
Hi Comunity, I need some help from you. In replication i want to update old binary files, but server is not updating old files. It is updatin only current using binarylog only. The scenario is, my master is updating log-5 file(say) and slave is reading data from it, and updating itself to

Re: Saving Binary Files to mysql

2003-10-24 Thread Egor Egorov
Timotius Alfa <[EMAIL PROTECTED]> wrote: > > How to save binary files to mysql ? I want to save *.exe whole in a binary files, > after that I want to save it to mysql. thanks > You can store binary data in the BLOB columns: http://www.mysql.com/doc/en/BLOB.html

Saving Binary Files to mysql

2003-10-23 Thread Timotius Alfa
How to save binary files to mysql ? I want to save *.exe whole in a binary files, after that I want to save it to mysql. thanks - Do you Yahoo!? The New Yahoo! Shopping - with improved product search

RE: Binary files..

2001-12-29 Thread Roger Baklund
* Gurhan Ozen > Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql > tables? If yes, can you point me to any direction? Yes, it is possible, see the url below. In general it is recomended to keep the binary files in the OS file system, and only store the path to th

Binary files..

2001-12-29 Thread Gurhan Ozen
Hi, Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql tables? If yes, can you point me to any direction? Thank you very much. Gurhan - Before posting, please check: http://www.mysql.com

Inserting binary files to blob columns

2001-03-11 Thread Erling Paulsen
How can I, from the mysql-client command line, insert a local binary fil (i.e. an image) into a blob column in a table - using a standard insert query? For reference: Tablename = "pictures", Columnname(type mediumblob)="picture",Localfile="/tmp/test.gif" - Erling Paulsen -