-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, November 02, 2007 9:23 AM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: sporadic error 13 on windows
DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD'
(Errcode: 13) at
-Original Message-
From: Colin Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 17, 2007 9:08 PM
To: Kristen G. Thorson
Cc: mysql@lists.mysql.com
Subject: Re: Log Warnings Level
Kristen G. Thorson wrote:
Hi!
But all I really get from this reading is 0 turns it off
1 warnings plus aborted connections
warnings. I have not been able to find any additional information in my
search. Am I missing something, or is this all the documentation there
is on this?
Thanks,
Kristen G. Thorson
Programmer
(804) 553-1130, Ext. 204
www.AllegroConsultants.com
--
MySQL
-Original Message-
From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
Sent: Friday, October 20, 2006 10:00 AM
To: MySQL List
Subject: Reports
Hi everyone
do you know any good (free) application that make it easy to generate
(with charts) a very nice reports from mysql ?
This
-Original Message-
From: List [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 17, 2006 9:30 PM
To: mysql@lists.mysql.com
Subject: 'Not a valid MySQL result resource' error
Hello,
I'm running f.a.m.p, f =freebsd 4.7 and mysql is 3.23.52.
Anyway, I inherited a website from
battling this problem on several forums and mailing lists, I got
confused:
when store string that contains quotations (ie afan's php shop) in
mysql
does it have to be stored with backslashes (afan\'s \php\ shop) or
just
the way it is? my login's telling me the way it is. am I wrong?
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 09, 2006 11:43 AM
To: mysql@lists.mysql.com
Subject: Re: how to store quotes in mysql?
On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote:
[ stuff here ]
kgt
I'm confused
RAPPAZ Francois wrote:
Hi
I'm stuck with a sequence of sql commands to duplicate a record whithin the
same table (server is 3.23.58):
I have table t1 with data : char and id: auto_increment, int, unsigned, primary
key.
I would like to do the following
SET @template = 104;
DROP table IF
[EMAIL PROTECTED] wrote:
Hi,
I haven't admin'd MySQL in a couple of years, and I have forgotten and lot
(and probably never knew even more.)
I recently installed the current 4.1x MySQL release in Windows XP. I am
trying to track down problems, and can't seem to get an error log. I
expected to
Michael Williams wrote:
Thanks for the responses everyone. Just a quick FYI, I am using
Python as an intermediary to sync the DBs (I'm fine with using
whatever as long as it's Debian compatible). I suppose I should have
explained before, but I'm using the Python script to connect from a
Jeff wrote:
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_timestamp(now()),'[EMAIL PROTECTED]
[EMAIL
http://www.google.com/search?hl=enlr=q=real+estate+investment+trustbtnG=Search
REIT = real estate investment trust
Maybe the extra F is for fund? I didn't see any mention of REITF -
but I have seen the acronym REIT before.
kgt
Ed Curtis wrote:
Does anyone on the list know what REITF
I need to convert this query into one without a subquery:
SELECT
r.selector_forms_results_max_points AS points,
r.selector_forms_results_description AS description,
FROM selector_forms_results AS r
WHERE r.selector_forms_id = 1
AND r.selector_forms_results_max_points = (
SELECT
[EMAIL PROTECTED] wrote:
Kristen G. Thorson [EMAIL PROTECTED] wrote on 10/14/2005
09:15:21 AM:
I need to convert this query into one without a subquery:
SELECT
r.selector_forms_results_max_points AS points,
r.selector_forms_results_description AS description,
FROM
Hi all,
This may be a simple solution that I'm just not seeing. logrotate has
trouble with binlogs since the extension keeps changing, so instead of
actually rotating logs out, I just get a dir filled with
binlog.001.1
binlog.002.1
binlog.003.1
binlog.004.1
binlog.005.1
binlog.006.1
and on
Your syslog8.txt file has two problems:
1. The first field, log_date, is in m/d/ format. It will not be
converted by MySQL automatically. It needs to be in -mm-dd format.
For this reason, all records will have the default value of '-00-00'
for that field.
2. The primary key
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Double check that mysqld is running. I usually find out that it's not
when I get that error.
kgt
Elton Hughes wrote:
Hello All,
I am trying to install MySQL 4.1.12 on my Powermac G4. My OS is
10.4.1. I downloaded the
I think you might be confusing UPDATE and SELECT syntax. As far as I
ever knew, you couldn't specify a limit offset in an update statement.
I don't see in mysql update docs where it indicates offset is allowed.
kgt
David Legault wrote:
Hello,
I'm using the MySQL C API and I got the
Are your php scripts by any chance called phpWebSite? If so, you might
find more help here:
http://www.phpwsforums.com/
What you're getting is almost definitely a PHP script catching some kind
of error trying to connect to the database server. You should have a
file called configure.php or
Adam Lipscombe wrote:
I have MySql 4.1.12 installed on an XP box in C:\mysql.
I have the settings below in my C;\MySql\my.ini file:
I have the transaction-isolation set to READ-COMMITTED but the server seems
to ignore this.
When the server starts up the tx_isolation as reported by mysqladmin
I am moving some code that was developed against MySQL 4.1 to a server
with 3.23, and I have one query that uses a subquery. I'm having a bear
of a time wrapping my mind around how to convert this. The original
query is this:
SELECT page.page_id, page.page_keyword
FROM page
WHERE
!
kgt
[EMAIL PROTECTED] wrote:
Kristen G. Thorson [EMAIL PROTECTED] wrote on 05/17/2005
02:37:12 PM:
I am moving some code that was developed against MySQL 4.1 to a server
with 3.23, and I have one query that uses a subquery. I'm having a bear
of a time wrapping my mind around how
| 15 |
Shawn has already posted a working answer, so this is just me sharing
how proud I am that I figured it out well enough to know why it doesn't
work, which I guess is as good a learning tool as any!
Thanks,
kgt
Jan Pieter Kunst wrote:
2005/5/17, Kristen G. Thorson [EMAIL PROTECTED]:
I am
The folks at http://us4.php.net/mailing-lists.php can help you.
In PHP 5, MySQL is no longer enabled by default, nor is the MySQL
library bundled with PHP.
http://us4.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
kgt
CIKALA Frédéric ROSI/SIPROD wrote:
It seems like you got the
Hello all,
I have a problem on a development machine that somehow got every single
mysql program in the /usr/bin directory wiped out (which looks like it
was everthing but mysqld).
The server is actually up and running, and the datadir is intact, so it
looks like my data is okay. However, I
http://dev.mysql.com/doc/mysql/en/multiple-unix-servers.html
There may be some helpful notes there. How are you determining which
datadir mysqld is using when it's actually running? Are you logging in
with mysql or mysqladmin? Make sure that if you are doing so, that
you're actually logging
The line:
MySQL 4.0.18 running on localhost as [EMAIL PROTECTED]
refers to the hostname and user you log into *mysql* with. It does not tell you what user mysql is running under on the OS. The user and hostname that phpMyAdmin logs in under are changed in the phpMyAdmin config.inc.php file.
27 matches
Mail list logo