Just a thought, (I'm certainly no wondows guy) but perhaps your
setting for the TMP directory would be respected if you used the DOS
format path with the backslash..
tmpdir=C:\temp
vs.
tmpdir=C:/temp
tried it, still:
DBD::mysql::st execute failed: Can't create/write to file '#sql_152c_0.MYD'
Regarding this issue, I have found that by rebooting the computer,
these problems have gone away (for now). I have a feeling that
this was a subtle permission/ownership problem. Some of the
databases were installed by direct file copy. although this method
has worked well for me on slackware and re
I am running
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standard Edition
I have a database dig perl script with basically does a lot of
SELECT [somefield] as tt FROM table;
When i run it i get:
DBD::mysql::st execute failed: Can't crea
Hi,
I have a website running on Linux based cluster server. We don't have
access to logs, nor we have ssh access.
I want monitor mysql server usage of my site for the purpose of
optimizing my site scripts.
Pls suggest php based application.
--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT C
you need to group the result sets by date, look at the manual link below:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
Richard Reina wrote:
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 "2007-09-01" 1153.85 108.26
1323 "2007-09-01"
Hi Richard,
Richard Reina wrote:
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 "2007-09-01" 1153.85 108.26
1323 "2007-09-01" 461.54 83.08
1289 "2007-09-01" 1153.85 94.41
1234 "2007-09-15" 1153.85 108.26
1323 "2007-09-15" 491.94 87.18
1289
there should be no space between function name and () i.e. it should be
group_concat(hosts.name)
(unless you have the sql mode IGNORE_SPACE set)
Andrey Dmitriev wrote:
I knew I’ve seen this error before ☺
Thanks a lot.
-andrey
From: Peter Brawley [
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 "2007-09-01" 1153.85 108.26
1323 "2007-09-01" 461.54 83.08
1289 "2007-09-01" 1153.85 94.41
1234 "2007-09-15" 1153.85 108.26
1323 "2007-09-15" 491.94 87.18
1289 "2007-09-15" 1153.8594.41
I ca
Hi,
Master to slave replication.
If a database is created in master and in slave config file if i needs to add
the 2nd database name to replicate, without restarting the instance in slave it
is not possible.
Cheers
John_mysql
- Original Message
From: Oriol Capsada <[EMAIL PROTECTED
Hi
Check whether u have enabled the safe_updates in the config file.
- Original Message
From: Mulyadi <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, October 31, 2007 3:22:59 PM
Subject: disconection
- Original Message -
From: Ravi Shanmugam <[EMAIL PROTECTED]>
mysql@lists.mysql.com
- Original Message -
From: Sebastian Mendel <[EMAIL PROTECTED]>
To: Richard <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, October 31, 2007 3:11 PM
Subject: Re: Inserting a value in an autoincrement list?
> Richard schrieb:
> > I want to have a list of titles to which I c
- Original Message -
From: Ravi Shanmugam <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 31, 2007 3:32 PM
Subject: Problem with upgrade command in mysql.
Hi,
I have a script which updates a mysql table. When I run this script the
update in not happening.
But if I stop mysql and start
Hi,
I have a script which updates a mysql table. When I run this script the
update in not happening.
But if I stop mysql and start in safe mode as follows
mysqld_safe --skip-grant-tables --user=root &
then the update script is running properly.
Why it is not happening in the non safe mode.
Richard schrieb:
> I want to have a list of titles to which I can add new ones either at
> the end of the list or in a chosen position so I can choose what order
> they show up in.
>
> The first solution that I thought of was to add one to all of the
> position values heigher than the position I w
14 matches
Mail list logo
