Alas, I mothballed my old RS/6000 AIX machine a few years ago. It was
getting quite old and only ran AIX 4.3
I had toyed with the idea of getting a more modern machine from ebay
but to be honest, I haven't had much time recently.
On 9 Sep 2011, at 08:22, Peter Gershkovich wrote:
I notice
It is some time since i used AIX but maybe this help.
So far i know has IBM moved to gnu-tools if not do it,
it will ease the pain. I assume that you have gcc etc running.
after downloading the latest version of mysql source.
1. unpack
2. ./configure
if it complains try to fix it
/* hope for the be
nuary 06, 2010 11:43 AM
To: mysql@lists.mysql.com
Subject: RE: Binary Logging
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2
Yes, your settings will be fine. If you were already supporting
slaves which might remain dis-connected for extended periods of time,
you would have to take that into account when setting the purge
interval.
You don't need current binary logs for future slaves. You new slave
will start with a sn
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
>From the MySQL command line, will this be ok?
Steve.
-Original Message--
> hehe, well said and sorry for the top-posting.
> I can only agree, both methods have their merits! :)
>
> Alec
Seems I started quite a debate ;)
I wanted to thank you all again for your opinion and for planting a new seed
of doubt on which direction I'll go ;)
I setup the db as proposed earlier
Kevin Hunter wrote:
Grrr. All you lazy top-posters! ;) It seems to me that a case can
be legitimately made for both methods of handling BLOBs. On the one
hand, where speed and/or efficiency (on many different levels) are the
top priorities, it'd be good to keep the DB as trim as possible.
On 07 Mar 2007 at 3:57p -0500, Alexander Lind wrote:
imagine a large system where pdf-files are accessed by clients a lot.
say 1 pdf file is access per second on average.
also say that your database is on a machine separate from the
webserver(s) (as is common).
do you really think its a good
I've built systems than stream tons of data via this method, at times
into some impressive requests per second. Also I've exposed files stored
in this manner via a ftp interface with servers able to deliver near wire
speed data in and out of the db storage.
When your into a load balanced environ
imagine a large system where pdf-files are accessed by clients a lot.
say 1 pdf file is access per second on average.
also say that your database is on a machine separate from the
webserver(s) (as is common).
do you really think its a good idea to pump the pdf data from the db
each time it ne
I have to disagree with most, I would store the entire file in the
database, metadata and all. Better security, if you have a backend
database, it's much harder to get the data than pdf's sitting in a
directory on the webserver. Plus if you ever want to scale to a
multi-webserver environment, th
Here's a great article on how to store pdf/whatever binary as blob chunks:
http://www.dreamwerx.net/phpforum/?id=1
On Wed, 7 Mar 2007, Jay Pipes wrote:
> Ed wrote:
> > Hi All,
> > I'm trying to figure out how to put a pdf file into a blob field.
> >
> > I guess a pdf file is a binnary file an
On Wednesday 07 March 2007 21:26, Alexander Lind wrote:
> I would put the pdf as a regular file on the hd, and store the path to
> it in the db.
> Meta data could be things like the size of the pdf, author, owner,
> number of pages etc.
>
> Storing binary data from pdf:s or images or any other comm
Ed wrote:
> On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
>> Is there a specific reason you want to store this in a database? Why
>> not use the local (or networked) file system and simply store the
>> metadata about the PDF in the database?
>>
>> Cheers,
>>
>> Jay
>
> Hi Jay,
> Could you ex
i think he means you store only the name of the document
and the directory location of where it is located.
-Original Message-
>From: Ed <[EMAIL PROTECTED]>
>Sent: Mar 7, 2007 3:15 PM
>To: mysql@lists.mysql.com
>Subject: Re: binary into blob
>
>On Wednesday
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common binary
format is generally not a good idea.
Alec
Ed wrote
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
> Is there a specific reason you want to store this in a database? Why
> not use the local (or networked) file system and simply store the
> metadata about the PDF in the database?
>
> Cheers,
>
> Jay
Hi Jay,
Could you explain what you mean by me
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
> Ed wrote:
> > I guess a pdf file is a binnary file and it will contain characters that
> > will mess things up, so my question is:
> >
Hi, sorry for the late answer. The reason, until I come up with a better one,
is that I'm doing my own basic
Ed wrote:
Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file and it will contain characters that will
mess things up, so my question is:
can it be done? Or better, how can it be done? ;)
Any pointers to documentation are a bonus!
It's my understanding that a PK in MySQL is basically the same as a
unique index -- for MyISAM tables at least. For InnoDB it's a bit
different with InnoDB storing rows within the PK index (and inserting
a hidden PK if none is provided).
In short: I don't think you'll see any better perfo
On Wed, Nov 08, Jon Frisby wrote:
> On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
>
> >
> > Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
> >
> > Performance issues? In mysql, in general?
> >
> > Yes, in the context of the application, there is a very good
> > reason for doing
I'm curious to know why simply having a UNIQUE constraint on the
column is inadequate...
-JF
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, th
>
> http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html
>
> It has some good examples.
got it thanks...
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
kalin mintchev wrote:
hi all...
i found this on the mysql dev manual site:
"MySQL 4 and later string comparisons, including DISTINCT, aren't case
sensitive unless the field is declared as BINARY or you use BINARY in your
comparison."
so here i tried it but no good. any ideas?! the field is not
In answer to my own question:
Why don't the binary logs write?
The '%-bin.index' file left over from previous version (4.1.9) had to be
deleted after the conversion to 5.1.6.
By deleting this file, the binary logs started to recreate.
I hope this is useful to somebody :)
Ben
Ben Clewett
Hi James,
If you want to configure a relay replication server, i.e. make the
replication to pass data from slave to another slave as A->B->C you need to
start B with --log-bin and --log-slave-updates.So check that
log-slave-updates has been included in your my.cnf file.
You can read mor
Hello.
If documentation isn't clear, you may want to report a bug at:
http://bugs.mysql.com
Jerry Bonner <[EMAIL PROTECTED]> wrote:
> I realize that.
>
> The documentation states that username and timestamp,
> by default, are logged to "(update log, binary update log, and s
I realize that.
The documentation states that username and timestamp,
by default, are logged to "(update log, binary update log, and slow queries
log, whatever log has been activated)". But apparently it isn't.
I was hoping that there was a way to get that information in the binary
log, but
Hello.
I think these lines from sql/mysqld.cc from 4.1.13 distribution shows
that --log-long-format doesn't affect the behavior of MySQL:
{"log-long-format", '0',
"Log some extra information to update log. Please note that this
option is deprecated; see --log-short-format option.",
0, 0,
On Saturday, March 05, 2005 1:46 PM [GMT+1=CET],
Gleb Paharenko <[EMAIL PROTECTED]> wrote:
Hello.
The problem I think is in indexes. After dropping the unique key
the query gives the correct result. I've reported a bug:
http://bugs.mysql.com/bug.php?id=8976
You may add your comments there.
I have
Hello.
The problem I think is in indexes. After dropping the unique key
the query gives the correct result. I've reported a bug:
http://bugs.mysql.com/bug.php?id=8976
You may add your comments there.
"Artem Kuchin" <[EMAIL PROTECTED]> wrote:
> MySQL: 4.1.8a
> OS: FreeBSD 5.3
At 2:52 -0800 11/26/04, Chenri J wrote:
What is 'binary' in column type stand for?
is it describe how the data is stored (in biner value)?
what do we want use it for?
- encryption ?
- space efficiency ?
- fast index ?
- or ?
I've searched the mysql manual but didn't find any clue about it
thank
> What is 'binary' in column type stand for?
> is it describe how the data is stored (in biner value)?
> what do we want use it for?
> - encryption ?
> - space efficiency ?
> - fast index ?
> - or ?
AFAIK it's used for determining the behaviour while comparing values
(operators, sorting, etc.)
Chenri J <[EMAIL PROTECTED]> wrote on 26/11/2004 10:52:51:
> What is 'binary' in column type stand for?
> is it describe how the data is stored (in biner value)?
> what do we want use it for?
> - encryption ?
> - space efficiency ?
> - fast index ?
> - or ?
>
>
> I've searched the mysql manu
Many Thanks to Dobromir Velev,
And for those without PERL but with PHP (or prefer PHP) here is a quick and
dirty port to PHP
REMEMBER TO MAKE A BACKUP OF YOUR FILES BEFORE TESTING OR USING THIS
SCRIPT
IT IS RECOMMENDED YOU TEST THIS SCRIPT IN A NON PRODUCTION ENVIRONMENT
FIRST **
Here it is
#!/usr/bin/perl
use strict;
use DBI;
my $db_host="localhost";
my $db_user="username";
my $db_pass="password";
my $db_name="database";
my $mail_prog = '/usr/lib/sendmail';
my $email='[EMAIL PROTECTED]';
my $from_email='[EMAIL PROTECTED]';
sub mysql_die{
if ($_[0]){ print $_[0]."
Hi,
There is a thing I forgot to mention in my previous email - if you are
replicating your database please follow the steps described in
http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html
or you might end with missing data on your slave servers. A binary log should
not be deleted unless
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 10 June 2004 08:03 am, Josh Trutwin wrote:
> Would you be willing to share your perl script? Perhaps offlist if you are
> concerned about everyone seeing it?
I would like to see it as well.. If at all possible
- --
How
On Thu, 10 Jun 2004 15:55:31 +0300
Dobromir Velev <[EMAIL PROTECTED]> wrote:
> I've made a simple perl script that uses the
>
> show master logs
>
> and
>
> purge master logs to 'mysql.???'
>
> queries to remove all but the last seven logs and it works perfectly
> for me.
Would you be willi
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly for me.
Check http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html for details.
--
Dobromir Velev
[EMAIL PROTECTED]
ht
S?ren Neigaard <[EMAIL PROTECTED]> wrote:
> I have a MySQL (mysql-standard-4.0.17-pc-linux-i686) running as master =
> where I have attached a slave to for replication. The problem now is =
> that on the master there is a LOT of mysql-bin.XXX files, and they each =
> take 1GB diskplace.
>
> Are t
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the --binlog-do-db option along with it. Databases not named with
--bi
At 18:55 -0600 3/25/04, Moritz von Schweinitz wrote:
hi again!
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the --bi
On Mon, Jan 05, 2004 at 09:12:24AM +1300, Sam Vilain wrote:
> No-one out there doing step-by-step replay of binary logs ?
mysqlbinlog
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 162 days, proce
George Mathew <[EMAIL PROTECTED]> wrote:
> Seems to be the binary log saves all INSERT statements, even if it is
> a duplicate error.
Only successfully executed INSERTs are written to the binary logs.
> How could I restore my table using mysqlbinlog if there
> are duplicates in the log file.
Wha
files as they are reading them
in so as not to violate any constraints?
David
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]>
To: "David Griffiths" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 13, 2004 5:46 PM
Subject:
ROTECTED]>
To: "David Griffiths" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 13, 2004 5:46 PM
Subject: Re: Binary Logs and Transactions (with InnoDB and MyISAM)
> Hi David,
>
> David Griffiths wrote:
>
> >From reading the docs, a
Hi David,
David Griffiths wrote:
From reading the docs, a binary log is an efficient representation of all
data-modifying SQL that is run on the master database. I was unable to
figure out what happens if a slave is interrupted while in the middle of
processing a binary log.
When a binary log is
I would greatly appreciate your notes if you are willing to post them. I'm currently
preparing for the core exam.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No-one out there doing step-by-step replay of binary logs ?
On Tue, 30 Dec 2003 17:52, Sam Vilain wrote;
> Hi there,
>
> Is there a utility out there to do transaction-at-a-time view and/or
> replay with MySQL's binary log ? Primarily for audit / debug
> purposes.
>
> I'm only in
Has anyone done this before? I can't be the only one that likes custom
paths/directories! :)
[EMAIL PROTECTED]
"Thanks to the remote control I have the attention span of a gerbil!"
"There are 10 types of people in the world. Those who understand binary,
and those who don't."
- Origi
On Thu, Jul 03, 2003 at 10:49:59PM +0200, awarsd wrote:
> Hi,
>
> I think MySQL uses binary tree, but my question is that what happens when we
> delete record. Does the binary regenerate itself??
MySQL handles tree (re-)balancing when necessary.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MyS
Mysql uses a btree+
-->-Original Message-
-->From: awarsd [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 03, 2003 1:50 PM
-->To: [EMAIL PROTECTED]
-->Subject: Binary tree
-->
-->Hi,
-->
-->I think MySQL uses binary tree, but my question is that what happens
when
-->we
-->delete record.
On Wed, Jun 11, 2003 at 03:30:01PM -0500, Sam Jumper wrote:
> Is it possible to have more than one binary log per master or is it
> possible to start more than one thread to execute queries?
>
> I have 2 computers in a master and slave configuration. The slave is
> running without error but it
In order to help, could you post some info about both servers config (cpu
speed, disk speed and OS as well as network capacity) - That would really
help people understand the problem and find the bottleneck...
Cheers,
A
-Original Message-
From: Sam Jumper [mailto:[EMAIL PROTECTED]
Sent:
file.
Is this what you meant.
Thanks
sam
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "sam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 2:40 PM
Subject: Re: binary log not recording 4.0.9
> Y
s.
I appreciate any help you can offer,
Sam Pizzuto
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "sam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 9:20 AM
Subject: Re: binary log not recording 4
If your application is opening one database, and then updating
medic.sometable, the update will not be recorded in the bin file.
sam wrote:
I am trying to use replication with 4.0.9.
Changes to the datbase are not being recorded in
the bin file on the master for a DB called Medic
when present
Mike,
Thank you very much for responding to my question. Haven't been able to
find much out there. Your article, to which you referred in your response,
was something I have already used to get me as far as I had gotten. I'd
found it in my search for an answer. I found the connection string and
Hi Kevin;
You may want to look at the online article I wrote at
http://www.dynamergy.com/mike/articles/blobaccessvb.html which covers use of
the stream object in detail. While written for VB, it should be easy enough
to convert to ASP.
Mike Hillyer
-Original Message-
From: Kevin Wix
At 16:21 -0500 12/11/02, David Nedved wrote:
Hi All,
I have two qestions about the binary log files that I couldn't find the
answer to.
1.) how do you force a log switch other than startup / shutdown?
FLUSH LOGS
2.) when the number gets to 999 does it keep going with more digits,
wrap aroun
On Sun, 8 Sep 2002, David Lurie wrote:
> Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on
> my system after installation.
>
> Both configure and mysql_install_db fail due to missing dynamic link libraries
> /usr/lib/libdl.so.1 and libnsl.so.1. The system does have lib
Ilyas try this site, Marc has great instructions on setting everything up
and all the downloads you need...
http://www.entropy.ch/software/macosx/mysql/
--
* Stephen Rosenberg
* http://www.lifug.org
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
On 9/6/02 5:36 PM, "Ilyas Keser" <[EMAIL PROTECTED]
On Fri, Aug 30, 2002 at 10:24:13PM -0700, Jefferson Cowart wrote:
> I just downloaded 3.23.52 from the mysql servers and the version of
> mysqlbinlog in there doesn't have the -d option you are talking about.
Yeah, looks like it's in 4.0.2 and later. I may have the patch still
floating around if
At 22:24 -0700 8/30/02, Jefferson Cowart wrote:
>I just downloaded 3.23.52 from the mysql servers and the version of
>mysqlbinlog in there doesn't have the -d option you are talking about.
It appears to have been added in 4.0.2.
--
.html
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 17:04
> To: Jefferson Cowart
> Cc: [EMAIL PROTECTED]
> Subject: Re: Binary Update Logs
>
>
> On Fri, Aug 30, 2002 at 04:39:08PM -0700, Jefferson Cowart
; From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 17:04
> To: Jefferson Cowart
> Cc: [EMAIL PROTECTED]
> Subject: Re: Binary Update Logs
>
>
> On Fri, Aug 30, 2002 at 04:39:08PM -0700, Jefferson Cowart wrote:
> >
> > Is there a way
On Fri, Aug 30, 2002 at 04:39:08PM -0700, Jefferson Cowart wrote:
>
> Is there a way to parse the binary update logs and get separate
> binary files for each database? I am hosting mysql databases for
> people and I want to be able to give each of them binary logs but
> only want updates for their
On Wed, 2002-08-21 at 15:20, Lenz Grimmer wrote:
> That's correct. We build our Alpha binary with the Compaq C/C++ compiler on a
> Compaq DS-20, which has an EV6 processor. So far, we only used the compile
> option "-fast", which by default optimizes for the platform it is currently
> running
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
On Wednesday 21 August 2002 20:17, Timothy Olden wrote:
> I have been using MySQL version 3.23.33 on my Alpha box for quite a
> while now. A month or two ago I tried to update to mysql-max-4.0.1 only
> to learn that the binary was built o
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
Maybe you have my.cnf file in your computer. That can be under
/etc or you home directory. In that file there may be text like this.
# Try number of CPU's*2 for thread_concurrency
set-variable= thread_concurrency=8
set-variable= myisam_sort_buffer_size=64M
log-bin
server-id = 1
You
On 30 May 2002, at 8:58, Dan Vande More wrote:
> If I do in the fs then there is tons of overhead because of new
> folders, each client having thier own folder(and subfolders) etc.
> And then htaccess'ing the dir's independently along with the
> overhead of keeping track of the htaccess files.
T
on?=
From: [EMAIL PROTECTED]
MIME-Version: 1.0
Cc:
Return-Path: [EMAIL PROTECTED]
Originating-IP: 213.89.182.213
X-Priority: 3
X-Mailer: DCS.net Webmail ver. 0.1
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Why not use the best part from both !!!
u
On Mon, May 27, 2002 at 10:31:06AM -0700, jim hopp wrote:
> Greetings,
>
> We plan to use the binary update log plus backups to enable us to
> restore databases and then re-apply updates when necessary. It
> appears to me that the binary update log contains updates to all
> databases on the mysq
Ritu,
Thursday, May 23, 2002, 5:04:29 PM, you wrote:
RS> REALFROM: Ritu Singla <[EMAIL PROTECTED]>
RS> HOUR: 2002052320
RS> hello,
RS> i'm trying to install mysql-max...using binaryver 3.23.49
RS> i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB
RS> table options:
are you null terminating the string?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: "Sameer Maggon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 7:51 AM
Subject: Binary Data mysql_real_escape_
> Hi,
> Please see the code given below::
>
>
OTECTED]]
Sent: Wednesday, March 27, 2002 1:05 AM
To: adam nelson
Cc: [EMAIL PROTECTED]
Subject: Re: binary expansion?
adam nelson queried:
> iPersonType is a list in the form of 1,2,4,8,16,32,64
>
> so, let's suppose that szPersonType for 8 is lawyer and szPerson type
> for 2 is re
adam nelson queried:
> iPersonType is a list in the form of 1,2,4,8,16,32,64
>
> so, let's suppose that szPersonType for 8 is lawyer and szPerson type
> for 2 is redhead
>
> a value of iPersonType of 10 would mean redhead lawyer.
>
> I'd like a query that looks for lawyers (ie. iPerson type is an
On Tuesday 26 March 2002 3:30 pm, adam nelson wrote:
> It's been a while since I've done this, does anybody remember:
>
>
> If I have 2 tables:
>
> tblPerson (
> iPersonID int
> szPersonDesc varchar
> iPersonType int
> )
>
> tblPersonType (
> iPersonType int
> szPersonType varchar
> )
>
> iPersonT
From: adam nelson <[EMAIL PROTECTED]>
> It's been a while since I've done this, does anybody remember:
> I'd like a query that looks for lawyers...
Have you thought about using an unsigned int and doing bitwise math?
---
Rodney Broom
Programmer: Desert.Net
sql
--
* Carl Troein
> CREATE TABLE t1 (txt varchar(10) default NULL);
> INSERT INTO t1 VALUES ('aaa');
> INSERT INTO t1 VALUES (NULL);
> SELECT BINARY txt AS t FROM t1 GROUP BY t;
FYI:
I tried this on my win2000 3.23.30-gamma server, it crashed.
If I remove "BINARY" or "GROUP BY t", it does not crash
* 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
in
It works the way you want with this data when your query is written:
SELECT nev FROM hosoktest WHERE nev = ('pokember' OR 'Pokember');
Regards,
Doug
On Thu, 27 Dec 2001 01:33:57 +0100, Barnabas BONA wrote:
>If I execute the following select:
> SELECT nev FROM hosoktest WHER
Just my two cents: have you tried the following?
SELECT nev FROM hosoktest WHERE (nev = 'Pokember') OR (nev = \
'pokember');
Bogdan
Barnabas BONA wrote:
> If I execute the following select:
>SELECT nev FROM hosoktest WHERE nev = 'pokember' OR nev = \
>
On Fri, 14 Dec 2001, Ian Collins wrote:
>
> I am having difficulties with entering binary data from a c program.
> I have passed the string through mysql_real_escape_string.
Post the C data then. However read on.
>
> . . .
>
> drop table if exists junk5;
>
> create table junk5
> (
> id int no
Mark,
That does look like a bug, or at least a much-needed feature. I've
verified that this still doesn't work with the latest 4.0 code.
On Thu, 2001-11-01 at 11:54, Mark Jenison wrote:
> Hi all,
>
> I created a table with the key defined as binary(15), then inserted a
> record like this:
>
>
On Wed, Sep 19, 2001 at 09:37:29AM -0700, Cameron Watters -- List Subscriptions wrote:
> Just a quick question regarding how (if at all) MySQL's binary update log
> consumes resrouces as it records modifications to various tables in the
> database.
>
> Are there any potential performance issues o
Michael T. Babcock writes:
> I've been reapplying transactions to my aforementioned screwed up database.
> It seems however, that the binary transaction log doesn't quite work
> properly
> with user variables (with MySQL 3.23.38). I have this entry from the log:
>
> insert into Projects (ParentI
On Thu, Jul 12, 2001 at 01:51:29AM +0200, Werner Stuerenburg wrote:
>
> Im my understanding, you are storing images. AFAIK, images should
> not be stored in the db but in the filesystem.
There's nothing wrong with doing it, as long as you understand what
you're doing. After all, images are (from
Im my understanding, you are storing images. AFAIK, images should
not be stored in the db but in the filesystem. You store only the
filename and other data (time etc.) in the db. There are some
remarks on this at php.net and other places, as this question is
posed often.
Sie schrieben am Mittwoch
TECTED]]
>Sent: den 30 maj 2001 03:28
>To: David Lidström; MYSQL LIST
>Subject: Re: Binary
>
>
>At 9:16 AM +0200 5/29/01, David Lidström wrote:
>> Is there some kind of pattern in fields containing
>> binary data - so you can be sure that is really IS
>> bin
s
> listed, and the field is containing a file I'd like
> to know this somehow... If possible!!
>
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: den 30 maj 2001 03:28
> To: David Lidström; MYSQL LIST
> Subject: Re: Binary
>
&g
ent: den 30 maj 2001 03:28
To: David Lidström; MYSQL LIST
Subject: Re: Binary
At 9:16 AM +0200 5/29/01, David Lidström wrote:
> Is there some kind of pattern in fields containing
> binary data - so you can be sure that is really IS
> binary!?
> I.e. if I in my database have a BLOB
At 9:16 AM +0200 5/29/01, David Lidström wrote:
> Is there some kind of pattern in fields containing
> binary data - so you can be sure that is really IS
> binary!?
> I.e. if I in my database have a BLOB-field and
> sometimes write a string, and sometimes a file?!
Given that a file can cont
Hi,
See 'BLOB' column type in the manual.
David Lidström wrote:
>
> Is there some kind of pattern in fields containing
> binary data - so you can be sure that is really IS
> binary!?
> I.e. if I in my database have a BLOB-field and
> sometimes write a string, and sometimes a file?!
>
>
Valentin Todorov (SEA) writes:
> Hi,
>
> I ported to MySQL a database that has BINARY(n) columns. MySQL
> silently changed them to VARCHAR(n) BINARY.
>
> And now the ResultSetMetaData.getColumnType() returns type 12=VARCHAR.
>
> Can I in some way access the attribute BINARY?!
>
>
> Valentin
>
> "d" == drew <[EMAIL PROTECTED]> writes:
d>Just wondering if anyone could help me out here? I have recently
d> downloaded the binary distribution of mysql for FreeBSD (mysql-
d> 3.23.32-unknown-freebsdelf4.2-i386.tar.gz). Now my problem is
d> probably an easy fix but here goes. Wh
'varchar(16) binary' works in 3.22 and tinyblob works in 3.23.
by work I mean I can insert hexidecimal numbers into the field.
I am basically treating it as an integer field. I can store 16 byte
numbers in the field and in the case of varchar(16) binary on mysql 3.22
I could store a 32 character
This works... however it does not fix my problem.
I did a little more research...
Instead of varchar(M) BINARY I can do a tinyblob.
This allows me to do the inserts and selects that I previously
mentioned.
Also the documentation says that you can consider blob as a varchar
binary.
So My qu
1 - 100 of 111 matches
Mail list logo
