On Sat, 2006-02-25 at 10:49 +0800, Mark wrote:
> Can anyone tell me if it is possible to send an email from outlook to a DB so
> it updates a record. I have a php tipping script hosted with a mysql DB but
> would like users to email their tips instead of loggin on the site.
>
> Mark
Wouldn't b
Hi. I'm using MySQL 5.0.18, and I'm trying to use LOAD DATA INFILE into tables
that have BIT(8) columns. No matter
what format I use, the result is not what I expect (see example below.) Anyone
know how to properly format the data for loading into a BIT column? Thanks!
$ cat /tmp/bit_test.txt
0
Hi Mark,
You will need to setup a processing script on your mailer that will do
that for you. Your ISP maybe able to set this up for you. Most mailers
use the aliases file for that. A quick google found this as an example,
yes it is talking to Oracle but the principles are exactly the same.
http:
Scott,
I think Shawn nailed it with
SELECT
p.id, p.prod_name,
SUM(IF(o.id IS NULL,0,oi.quantity)) AS Qty
FROM products AS p
INNER JOIN order_items AS oi ON (p.id = oi.product_id)
INNER JOIN orders as o ON (oi.order_id = o.id)
AND o.status NOT IN ('cancelled', 'pending', 'ghost')
AND
Can anyone tell me if it is possible to send an email from outlook to a DB so
it updates a record. I have a php tipping script hosted with a mysql DB but
would like users to email their tips instead of loggin on the site.
Mark
Greetings,
I have a problem I hope someone can help with:
A simple application consist of:
ADOConnect, ADODataSet, ADOQuery, DataSource1 (on a data
form)
The Grid and DBNavigator are on Form1
Conected to MySQL table.
When I add a record, by change of record (Next, New, whatever) or
clicking 'po
Hi,
I'm just looking for any experiences that people might want to offer on this
subject. My project is in the process of selecting hardware to build out
our system, and we are considering getting a few of the new Sun Fire T1000's
to run mysql on.
We are expecting that the project will have a st
CodeHeads wrote:
On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote:
#chown mysql:mysql /var/mysql-data
#chmod 770 /var/mysql-data
Try this, assuming the files are in there for the database.
$chown -R mysql:mysql /var/mysql-data/*
$chmod -R 770 /var/mysql-data/*
Hope that h
I appreciate your attempt to get me to RTM, but I think you'll find the
[EMAIL PROTECTED] syntax is correct. It works if I list a specific privilege to
revoke.
The problem is that ALL is itself a specific privilege. You can
grant/revoke using it but it doesn't replace all the other specific
pri
Twinkletoes <[EMAIL PROTECTED]> wrote on 02/24/2006 04:18:18 PM:
>
> I'm using MySQL 4.1 (I think... a late 4 anyway) on a Gentoo box. It's
only
> a semi-live situation and no need for security just yet.
>
> After messing with privileges a bit, I decided to revoke whatever
privileges
> are al
I'm using MySQL 4.1 (I think... a late 4 anyway) on a Gentoo box. It's only
a semi-live situation and no need for security just yet.
After messing with privileges a bit, I decided to revoke whatever privileges
are already applied and specifically grant only the ones I need (using a
shell script)
On Mon, 2005-12-26 at 09:27 +0800, Chenzhou Cui wrote:
Hi,
Sorry for long delay with reply.
I guess it is similar to
http://bugs.mysql.com/bug.php?id=17229
The problem is basically confirmed and we're now working to find
solution
> Dear Peter,
>
> Thanks very much for your concern. Answers
On Friday 24 February 2006 09:14, Martijn Tonies wrote:
> And we're handing out the presents...
>
> A 5-year celebration of our developer tool Database Workbench.
>
> The MySQL module was added recently, so are the MS SQL
> Server and Oracle modules.
>
> >From this Monday until next Friday, it's a
And we're handing out the presents...
A 5-year celebration of our developer tool Database Workbench.
The MySQL module was added recently, so are the MS SQL
Server and Oracle modules.
>From this Monday until next Friday, it's a 75% discount!
Check here:
http://www.upscene.com/index.htm?dbw_party
On Fri, 2006-02-24 at 10:02 -0600, John Trammell wrote:
> > On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> > > So far i've been able to store ip addresses as strings like
> > you would
> > > type them in DOS, for ex, '192.168.0.1'. This serves me
> > great since my
> > > applicati
Forgive me if this is a linux and/or system/os-specific question.
I am supporting a MySQL 4.0.x replication setup (2 slaves) that
handle ~10K qps and ~5000 persistent connections each.
It's obvious to me that system interrupts and context-switching
will be high with 2000+ mysqld procs, but gene
> On Wed, 2006-02-22 at 16:49 -0600, Ariel Sánchez Mora wrote:
> > So far i've been able to store ip addresses as strings like
> you would
> > type them in DOS, for ex, '192.168.0.1'. This serves me
> great since my
> > application uses IP addresses as strings in all cases. I've done
> > queries
Yes it's 32 bit System (Double XEON - Intel(R) Xeon(TM) CPU 3.00GHz)
Any solutions for this Joce?
[EMAIL PROTECTED] wrote:
Hi,
If it's a 32 bits machine, I don't think you can adress more than 2 GB for
1 MySQL process.
Jocelyn
Make sense,
Kayra, this is my.cnf for my mysql
-
Make sense,
Kayra, this is my.cnf for my mysql
cut here ---
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
#thread_stack=128KB
#set-variable = table-type=innodb
default-table-type = innodb
port
[client]
port= 3306
socket = /var/lib/mysql/mysql.sock
# The MySQL server
[mysqld]
#thread_stack=128KB
#set-variable = table-type=innodb
default-table-type = innodb
port = 3306
socket = /var/lib/mysql/mysql.sock
max_connections= 910
max_connect_
It can be both Linux kernel setting and MySQL configuration issue.
It can be a kernel issue since:
- Although you have 4G on your machine your kernel may set to let only
2G to a user space process. You may need to upgrade your kernel to a
'hugemem' kernel which gives you either 3/1 or 4/4 (you nee
Can you tell us about your config parameters?
Probably you must set up your max_connections, max_user_connections
http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
Ady Wicaksono escribió:
I have MySQL 5 installed on My Machine,
But it could handle only max about 350 concurren
I have MySQL 5 installed on My Machine,
But it could handle only max about 350 concurrent mysql connection
Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always
got Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for
a
On Friday 24 February 2006 12:33, Erich Beyrent wrote:
> My question is whether or not it is good design to have each user have
> his or her own set of tables. Would it not make sense to have all user
> posts in a single table, referenced by a BlogID? This table could
> easily grow to be a few m
I am currently evaluating the multi-user version of the popular blogging
software, Wordpress. One of the things I am not so sure about is its
schema.
To support multiple users, Wordpress creates about ten tables per user.
I have, at worst case, 4000 users who may be using this software, and
Rithish,
from the .err log we see that mysqld was shut down for 12 hours on Feb 19th.
What did the sysadmins do during that time?
There are two plausible explanations:
1) they edited datadir in my.cnf to point to a different location (
/var/lib/mysql),
or
2) they removed ibdata1 and ib_lo
Hi,
this is the solution I use:
/usr/local/bin/mysqlhotcopy -p mypass --allowold
'mydb./~(expirations|rtt)$/' /var/backups/mysqlbackup/$1
I guess this one is also possible:
/usr/local/bin/mysqlhotcopy -p mypass --allowold
'mydb./~^(expirations|rtt)$/' /var/backups/mysqlbackup/$1
Kind reg
Good stuff Peter, can you tell us your solution so folks can benefit
from your efforts?
(I expect the regex has to be POSIX style such as:
mydb./'~(expirations|rtt)'/ right?)
Imran Chaudhry
--
http://www.ImranChaudhry.info
MySQL Database Management & Design Services
--
MySQL General Mailing Lis
Peter Brawley wrote:
/>Now this query is run over two tables and the ab_members table contains
>around 302 rows. Around 1/3 of these will be where cup=kids. However,
>when this query is run it returns 20,700 results /
That's because your ...
FROM ab_leader_board ablb, ab_members abm
calls for
29 matches
Mail list logo
