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
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
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
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
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
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
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
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
* 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
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
10 matches
Mail list logo