Ofer Inbar wrote:
Baron Schwartz <[EMAIL PROTECTED]> wrote:
What version of MySQL are you running on each machine?
Sorry, I should've included this information. Both of them are
running 5.0.24, installed from exactly the same .rpm file. I wanted
to avoid any issues related to different MySQL
Baron Schwartz <[EMAIL PROTECTED]> wrote:
> What version of MySQL are you running on each machine?
Sorry, I should've included this information. Both of them are
running 5.0.24, installed from exactly the same .rpm file. I wanted
to avoid any issues related to different MySQL versions during thi
Hi,
Ofer Inbar wrote:
I'm transitioning from one mysql server to another, in production use,
by setting the new server up as a slave, so that when it's time to
switch, we'll have very little downtime. Then we can turn off
replication and the new slave will become the new production server.
I s
I'm transitioning from one mysql server to another, in production use,
by setting the new server up as a slave, so that when it's time to
switch, we'll have very little downtime. Then we can turn off
replication and the new slave will become the new production server.
I set up a replication slave
Hi Daevid,
Daevid Vincent wrote:
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Daevid Vincent wrote:
I'm having trouble figuring out the logic/query I want.
I know that all those "OR"s are not right.
I'm doing this in PHP and mySQL (of course),
so if it can't be
> -Original Message-
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
>
> Daevid Vincent wrote:
> > I'm having trouble figuring out the logic/query I want.
> > I know that all those "OR"s are not right.
> > I'm doing this in PHP and mySQL (of course),
> > so if it can't be done with a si
Baron Schwartz wrote:
Hi,
Afan Pasalic wrote:
Baron Schwartz wrote:
Hi Afan,
Afan Pasalic wrote:
hi,
if I have column order_id(int(4)) null do I have to index it too.
I'm going to use it ONLY for sorting records.
It depends a lot on how much data is in the table, etc etc. An
index will
Hi,
Afan Pasalic wrote:
Baron Schwartz wrote:
Hi Afan,
Afan Pasalic wrote:
hi,
if I have column order_id(int(4)) null do I have to index it too. I'm
going to use it ONLY for sorting records.
It depends a lot on how much data is in the table, etc etc. An index
will make sorting more effi
Baron Schwartz wrote:
Hi Afan,
Afan Pasalic wrote:
hi,
if I have column order_id(int(4)) null do I have to index it too. I'm
going to use it ONLY for sorting records.
It depends a lot on how much data is in the table, etc etc. An index
will make sorting more efficient in the general case
Hi Afan,
Afan Pasalic wrote:
hi,
if I have column order_id(int(4)) null do I have to index it too. I'm
going to use it ONLY for sorting records.
It depends a lot on how much data is in the table, etc etc. An index will make sorting
more efficient in the general case when you have a decent a
Try something like this. If there are multiple punctuation values you
want to ignore you can nest multiple REPLACE functions.
mysql> create table names (name varchar(20));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into names values
('Osbourn'),("O'shea"),("O'Malley"),('Olathe'),('Ottawa
hi,
if I have column order_id(int(4)) null do I have to index it too. I'm
going to use it ONLY for sorting records.
thanks.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have many tables like the table Person:below, in mysql database.
person_id, first_name,last_name, mi, gb_first_name, gb_last_name,
b5_first_name, b5_last_name, gender, dob
where different columns storing strings in different encodings.
All the strings/fields etc. need to be in the *same* e
Hi,
Jake Peavy wrote:
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Jake Peavy wrote:
> On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>>
>> Mark Leith wrote:
>> > Baron Schwartz wrote:
>> >> I will test again on my servers now that I have upgraded to 5.0.38.
>> >> One questi
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
Jake Peavy wrote:
> On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>>
>> Mark Leith wrote:
>> > Baron Schwartz wrote:
>> >> I will test again on my servers now that I have upgraded to 5.0.38.
>> >> One question for people for whom e
> Baron Schwartz wrote:
>> Hi Joseph,
>>
>> Joseph Koenig wrote:
>>> Hi,
>>>
>>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I
>>> moved the
>>> data directory of MySQL. I updated everything that SELinux complained
>>> about,
>>> etc., and have a functional install of MySQL.
This really isn't what he's talking about - rather than storing data as
rows and tables, you store as objects and methods.
MySQL does not support this; you can get this sort of functionality
using something like Hibernate (an Object-Relational-Mapping tool),
which is free but has a learning curve.
We have come across an interesting anomoly in MySQL behaviour in the
course of our investigations. It seems that when A table is equiped
with both BEFORE INSERT and BEFORE DELETE triggers and a REPLACE
statement is used against that table, the INSERT trigger is fired
first and the DELETE trigger
Are all of your fields using the UTF8 character set? I think that's
necessary.
We use UTF8 and have stored Chinese characters successfully using UTF8 with
a PHP web application. (At least, they look right to me - I don't know
Chinese at all.)
Regards,
Jerry Schwartz
Global Information Incorporat
I have many tables like the table Person:below, in mysql database.
person_id, first_name,last_name, mi, gb_first_name, gb_last_name,
b5_first_name, b5_last_name, gender, dob
where different columns storing strings in different encodings. At anytime, a
web user can switch the language and the ap
> Hi,
>
> CA Lists wrote:
>>> Hi Joseph,
>>>
>>> Joseph Koenig wrote:
Hi,
I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
data directory of MySQL. I updated everything that SELinux complained
about,
etc., and have a functional install of
Baron Schwartz wrote:
Hi Joseph,
Joseph Koenig wrote:
Hi,
I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I
moved the
data directory of MySQL. I updated everything that SELinux complained
about,
etc., and have a functional install of MySQL. It's actually been up and
running
Hi,
CA Lists wrote:
Hi Joseph,
Joseph Koenig wrote:
Hi,
I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
data directory of MySQL. I updated everything that SELinux complained about,
etc., and have a functional install of MySQL. It's actually been up and
running with
> Hi Joseph,
>
> Joseph Koenig wrote:
>> Hi,
>>
>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
>> data directory of MySQL. I updated everything that SELinux complained about,
>> etc., and have a functional install of MySQL. It's actually been up and
>> running wit
Baron Schwartz wrote:
I think we've found the bug. I just did a bunch of tests and I'm 99%
sure not only does expire_logs_days not work if there are slaves
attached, neither does PURGE MASTER LOGS. When I read my email this
morning, Nagios alerted me the master server was over the expected
d
Hi Joseph,
Joseph Koenig wrote:
Hi,
I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
data directory of MySQL. I updated everything that SELinux complained about,
etc., and have a functional install of MySQL. It's actually been up and
running with no issues for months.
Hi,
Jake Peavy wrote:
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Mark Leith wrote:
> Baron Schwartz wrote:
>> I will test again on my servers now that I have upgraded to 5.0.38.
>> One question for people for whom expire_logs_days DOES work: do you
>> have any slaves connected to the
-- Forwarded message --
From: Jake Peavy <[EMAIL PROTECTED]>
Date: May 4, 2007 7:41 AM
Subject: Re: expire_logs_days
To: Baron Schwartz <[EMAIL PROTECTED]>
On 5/4/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Mark Leith wrote:
> Baron Schwartz wrote:
>> I will test again on my s
If you serialize the object, you can store it in the data base as a blob.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: sam rumaizan [mailto:[EMAIL PROTECTED]
> Sent: Friday
Mark Leith wrote:
Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for whom expire_logs_days DOES work: do you
have any slaves connected to the server?
I did not within my test. I could easily add that if need be however..
L
Thank You so much. I will have to try this later today. I have never done
a port forward in iptables before. I knew that I could, but just never had
a need or tried so it slipped my mind about this.
Again, Thank You.
Steve
On linux, one could do a port forward:
EXTIF=eth0 # Or wha
Hi Daevid,
Daevid Vincent wrote:
I'm having trouble figuring out the logic/query I want.
I know that all those "OR"s are not right.
I'm doing this in PHP and mySQL (of course),
so if it can't be done with a single query, I can split it up.
Here's the challenge, given a text field search box,
Baron Schwartz wrote:
I will test again on my servers now that I have upgraded to 5.0.38.
One question for people for whom expire_logs_days DOES work: do you
have any slaves connected to the server?
I did not within my test. I could easily add that if need be however..
Let me know if your
You can store any object as blob, but that's not a good idea (unless object
is atomic in terms of your application).
If you want to refer to your data in object-oriented manner, you can use one
of the ORM pattern implementations on the client sise.
As for a separate data type, no, MySQL doesn't
Is there such thing call Object-Oriented database for mysql? Basically can I
store an item as an object in myql?
-
Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
On Fri, May 4, 2007 10:21, Daevid Vincent wrote:
> I'm having trouble figuring out the logic/query I want.
> I know that all those "OR"s are not right.
> I'm doing this in PHP and mySQL (of course),
> so if it can't be done with a single query, I can split it up.
>
> Here's the challenge, given a
I'm having trouble figuring out the logic/query I want.
I know that all those "OR"s are not right.
I'm doing this in PHP and mySQL (of course),
so if it can't be done with a single query, I can split it up.
Here's the challenge, given a text field search box, someone enters:
Sony 20" TV
37 matches
Mail list logo
