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

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 MySQL

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. MySQL

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

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

2006-05-15 Thread sheeri kritzer
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 updating old files

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 -- For technical support

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

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

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 the file

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