Actually, here is my case.
There is a script owned by user A running daily.
script---
rm -rf /tmp/report.csv
mysql -umysql -pabc table -e "SELECT * into outfile '/tmp/report.csv'
fields terminated by ',' lines terminated by '\n' FROM table;"
In the first run, a file with the following p
On Tuesday 28 February 2006 23:41, Joshua Kugler wrote:
> You can't do that. The mysql server runs as user mysql, so it cannot
> create files owned by another user. If you run the mysql server as root
> (don't!), you might be able to do that, but I do not believe mysql has a
> facility for changi
You can't do that. The mysql server runs as user mysql, so it cannot create
files owned by another user. If you run the mysql server as root (don't!),
you might be able to do that, but I do not believe mysql has a facility for
changing the owner of a file. You are better off running a script
Thanks!
But I want to change the default setting of the file permission and
ownership. (i.e. the file will be created with permission and
ownerhsip according to my setting).
On 3/1/06, CodeHeads <[EMAIL PROTECTED]> wrote:
> On Tuesday 28 February 2006 22:55, unplug wrote:
> > Hi,
> > When I use a
On Tuesday 28 February 2006 22:55, unplug wrote:
> Hi,
> When I use a query "SELECT * into outfile '/tmp/report.csv' fields
> terminated by ',' lines terminated by '\n' FROM table;", it will
> create a file with the following permission and owner.
>
> -rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 r
Hi,
When I use a query "SELECT * into outfile '/tmp/report.csv' fields
terminated by ',' lines terminated by '\n' FROM table;", it will
create a file with the following permission and owner.
-rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30 report.csv
How can I change the default permission or the ow
On 2/26/06, Arnel Pastrana <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I was installing drupal on my webserver with mysql after i followed
> instructions on how to configure and setup drupal i cant't access the
> root password of my mysql. my password won't work all.
>
> Any idea how to change my
Hi everyone,
I was installing drupal on my webserver with mysql after i followed
instructions on how to configure and setup drupal i cant't access the
root password of my mysql. my password won't work all.
Any idea how to change my password of root? or is is passible that my
mysql is curr
Interested in MySQL? Live in peninsula/south bay? This MySQL Meetup is
for you!
Join us for the March MySQL Meetup on March 13th at 7pm in Santa Clara!
The topic for this month is Storage Engines In-Depth! I'll cover the
details of both MyISAM and InnoDB, how each works, its strengths and
wea
>Thanks!
>With regard to the ClOBs or Text fields, is that CLOB support?
>Or support for Text columns that hold up to 60,000 bytes of TEXT
data?
In MySQL they're BLOBs not CLOBs, see
http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html.
PB
http://www.artfulsoftware.com
No vi
- Original Message -
From: "Shaun Adams" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 28, 2006 5:19 PM
Subject: Cleaning Bin-Log Files
Does anyone know of a method or script that will automatically delete
bin-log files after x days? I've got a few customers, all utilizing a
mast
>6752 exit(1);
>6753}
>6754my_bind_addr = (ulong)
> ((in_addr*)ent->h_addr_list[0])->s_addr;
>6755 }
>6756 break;
>
>
> > And with other DBs, I can set 'sql.example.com' to resolve to N
> > IPs (N=4 in this example):
> >
> > 10.0.0.10
> > 1
Does anyone know of a method or script that will automatically delete
bin-log files after x days? I've got a few customers, all utilizing a
master and slave server... my problem is that the harddrives often get
filled to capacity if they go unchecked over a few months. Most of this is
attributed
Hi James,
Sort of. If I run the command manually, it does.
But my script uses su to run the server as an unprivileged user.
What happens if you:
su -m mysql -c 'sh -c "/usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql
--pid-file=/va
I have a SELECT query that looks similar to the following:
SELECT
FirstName,
LastName
FROM
myTable
WHERE
LastName IN ('PRICE', 'SMITH');
What I want to do is create a stored procedure for this SELECT query
similar to the following:
C
Cor,
>I need to put all available monthly Values from Updates
>to 1 Data record where MyKey and Year are equal.
IOW you want to save the results of the business end of a crosstab
(pivot table) query. The
crosstab analysis will require a full query. MySQL has an INSERT ...
SELECT command,
b
>Thanks!
>With regard to the ClOBs or Text fields, is that CLOB support?
>Or support for Text columns that hold up to 60,000 bytes of TEXT
data?
In MySQL they're 'BLOB's not 'CLOB's, see
http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html.
PB
http://www.artfulsoftware.com
---
Kishore,
> We use Vbulletin for our message boards, and I have a
query which
>takes approximately 1.2 - 1.5 seconds to execute, on a table
('thread')
>having around 130,000 rows, it is as follows
>SELECT threadid
>FROM thread
>LEFT JOIN deletionlog
>ON ( thread.threadid = deletionlog
Thanks!
With regard to the ClOBs or Text fields, is that CLOB support? Or support
for Text columns that hold up to 60,000 bytes of TEXT data?
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: J A <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Some general qu
Hi All,
We use Vbulletin for our message boards, and I have a query which
takes approximately 1.2 - 1.5 seconds to execute, on a table ('thread')
having around 130,000 rows, it is as follows
SELECT threadid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON ( thread.threadid =
>Does MySQL support the following:
>- Support for DDL commands and dynamic SQL inside stored
procedures?
Yes.
>- EXECUTE STATEMENT in Stored Procedures. (may be same question
as above)
Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE,
DELETE, DO, INSERT, REPLACE, SELECT, SET,
> I was asked to scope out the following features, and am not the person to
be
> implementing them.
> Hence the manuals weren't particularly helpful.
> I'm looking for definitive references one way or the other for the
following
> questions.
> SOS!
>
> Does MySQL support the following:
> - Suppo
I was asked to scope out the following features, and am not the person to be
implementing them.
Hence the manuals weren't particularly helpful.
I'm looking for definitive references one way or the other for the following
questions.
SOS!
Does MySQL support the following:
- Support for DDL comma
Please read the document.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
does the user that you're using has the enough privileges to connect from
192.xxx.xxx.xxx ???
> Is your mysql server listening just on localhost (127.0.0.1)?
>
> That is differnet than 192.xxx.xxx.xxx
>
>
>
>
>
>> -Original Message-
>> From: Xiaobo Chen [mailto:[EMAIL PROTECTED]
>> Sent:
Is your mysql server listening just on localhost (127.0.0.1)?
That is differnet than 192.xxx.xxx.xxx
> -Original Message-
> From: Xiaobo Chen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 28, 2006 11:27 AM
> To: Amaia Anabitarte
> Cc: mysql@lists.mysql.com
> Subject: Re: jdbc:
Not sure yet. Could it be that you're behind the router? And you might
need to redirect the traffic to the model to the IP of your PC and you're
PC's IP should be set static so that next time when you reboot, it won't
change.
Xiaobo
> Hi,
>
> I have a problem connecting to MySQL. I could connect
Thanks for the answer.
Now let me get this right, are you suggesting using prepared statements from
the C# code? Since I have seen some examples of prepared statements used in
stored procedures too.
I understand stored procedures are not best tool in all situations. But what
if while inserting r
Let's try to characterize the load and sizing. If the posts are mostly
text.
100 forums X 100,000 posts X 2,000 bytes per post = 20GB large but not
huge
We have people reading the posts. Even speed readers will take minutes
to read the new posts. Maybe 1 in 10 - 100 readers will do a new post. A
p
I'm in a process of transitioning from dynamic queries that were generated
in C# code to using Stored Procedures. Although i haven't done any analysis
of time difference between the two. But i do have few reasons to move to
stored procedures:
1) I work on a security application and i heard of S
Hello fellow listers,
I recently upgraded via RPMs from 4.1 to 5.0.18 on a RH9.0 (glibc2.3, kernel
2.4.20) machine.
Now I have problems starting the mysqld automatically. When it is invoked, the
error
"Couldn't find MySQLmanager or server" is emitted. Here is a short history of
my actions
On 2/24/06, Mark <[EMAIL PROTECTED]> 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
>
Well, no, DB
Chris,
See if this works for you:
SELECT
' ' as 'Call'
, concat(FName, ' ', LName) as Name
, ' ' as 'Mar-6'
, ' ' as 'Mar-13'
, ' ' as 'Mar-20'
, ' ' as 'Mar-27'
FROM
table
ORDER BY
LName, FName
Notice that there is a single blank space being ret
Thank you very much, I will have a look at it.
-Original Message-
From: leo huang [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 28, 2006 3:47 AM
To: Taiyo
Cc: mysql@lists.mysql.com
Subject: Re: mySQL 5 and CPu at 99.99%
hi, Taiyo
>| innodb_buffer_pool_size | 8388608
>| key_bu
- Original Message -
From: "2wsxdr5" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 28, 2006 3:43 AM
Subject: returning empty columns
This is probably going to sound like an odd request, but is there a way to
return empty columns in Mysql. For example a roll call sheet I want to d
Hi,
I have a problem connecting to MySQL. I could connect to the database with
this sentence:
jdbc:mysql://localhost:3306/db
but not with this sentence, with the same IP that the localhost:
jdbc:mysql://192.xxx.xxx.xxx:3306/db
What's wrong?
Thanks for all,
Amaia
--
MySQL General Mailing
Hi!
I already wrote a wrapper for unixodbc... Now I would like to skip odbc
and connect to mysql directly... AFAIK that is done using libmysql, right?
I looked at the www.mysql.com buzzword-bloat for 15 seconds before I
decided to subscribe here and just ask instead (I'm one of those
too-long-didn
Hi List,
Please help me with the following problem in MySQL 5.0.15.
I have 2 MyISAM tables like:
- table Updates with fields myKey, Year, Month, Value
where Month has the values 1 .. 12
- table Data with fields myKey, Year, Jan, Feb, ... Dec
I need to put all available monthly Values from U
hi, Taiyo
>| innodb_buffer_pool_size | 8388608
>| key_buffer_size | 8388600
Try to increase the innodb_buffer_pool_size if you use the innodb storage or
key_buffer_size if MyISAM storage is used or both.
You can get more information about innodb_buffer_pool_size and
key_bu
This is probably going to sound like an odd request, but is there a way
to return empty columns in Mysql. For example a roll call sheet I want
to do a select of names from my table and then add a column for each of
the next 12 weeks. I tried this.
SELECT `Call`, concat(FName, ' ', LName
Still a mystery about your missing InnoDB database files
Rithish.
I seem to remember there is an option that will allow you to
store InnoDB files in their own seperate directory safely,
and not in the /var/lib/mysql default directory.
One of the many things I like about MyISAM tables is that
41 matches
Mail list logo
