i never understand why people use datetime anyway.. unix timestamp is so
much easier to work with.
[EMAIL PROTECTED] wrote:
Hi,
just see the client connection timezone here :
http://dev.mysql.com/tech-resources/articles/4.1/time.html
you should certainly use --default-time-zone='-3:00'
Mathi
Hi,
just see the client connection timezone here :
http://dev.mysql.com/tech-resources/articles/4.1/time.html
you should certainly use --default-time-zone='-3:00'
Mathias
Selon Simon Garner <[EMAIL PROTECTED]>:
> On 21/06/2005 2:45 p.m., Scott Haneda wrote:
> > I need to run a BETWEEN select wh
First, remember when MySQL interacts with the filesystem it does so with
the privileges of the mysql user (or whatever user is running the
database). You'll have problems if that user doesn't have permissions in
that dir.
I'm not sure what OS GoDaddy runs, but if it's a flavor of Linux the
da
On 21/06/2005 2:45 p.m., Scott Haneda wrote:
I need to run a BETWEEN select where I put in a date rate, the time was at
one point irrelevant, but now the client is in a new time zone +3 hours
ahead, so
BETWEEN 2005010100 AND 20051201235959 is what I pass in now, which is
wrong, how can I a
I need to run a BETWEEN select where I put in a date rate, the time was at
one point irrelevant, but now the client is in a new time zone +3 hours
ahead, so
BETWEEN 2005010100 AND 20051201235959 is what I pass in now, which is
wrong, how can I add three hours to it and get the days and months
On Jun 20, 2005, at 5:37 PM, Kevin Burton wrote:
Kevin Burton wrote:
We're noticing a problem where if we were to write to the master
with multiple threads that our slave DB will fall behind.
BTW.. I should clarify.. when I mean "break" I really meant to say
that the slave replication w
Kevin Burton wrote:
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
BTW.. I should clarify.. when I mean "break" I really meant to say that
the slave replication will fall WAY behind because it can't replay
transactio
Kevin Burton <[EMAIL PROTECTED]> wrote on 06/20/2005 01:35:38 PM:
> We're noticing a problem where if we were to write to the master with
> multiple threads that our slave DB will fall behind.
> Note that we're trying to perform as many inserts as humanly possible
> and the load on the master is
In the last episode (Jun 20), William G.J. Halfond said:
> I'm not sure if this question is more appropriate for general
> discussion or the internals list.
>
> I want to create a tokenizer/lexer for MySQL's dialect of SQL to use
> in a JAVA application. I thought I could do this by creating a JA
Hello,
I'm not sure if this question is more appropriate for general discussion
or the internals list.
I want to create a tokenizer/lexer for MySQL's dialect of SQL to use in
a JAVA application. I thought I could do this by creating a JAVA
wrapper on the lexer code for MySQL. I looked thro
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
Note that we're trying to perform as many inserts as humanly possible
and the load on the master is 1.
My theory is that the master, since it can write to multiple tables
hi,
havant't you an automatic naming to ".htm" such as test.txt.htm rather than
test.txt ?
it's an upload problem. Can you access your file online ?
Mathias
Selon Brian Dunning <[EMAIL PROTECTED]>:
> I've got a GoDaddy virtual dedicated server and I'm trying to run a
> LOAD DATA INFILE, but I k
Hi,
SELECT @RES=data*2 AS intermediate_result,
@RES + 1 AS final_result
FROM table;
can do the trick.
Why not your method ? because it's v4.1
Mathias
Selon Tom Cunningham <[EMAIL PROTECTED]>:
> Here's something I've been curious about:
>
> Referring to one field from another
I just solved my own problem. For the benefit of others, I only
needed to set permissions to 755 for the directory containing my data
file. Works fine now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here's something I've been curious about:
Referring to one field from another field in a 'select' query:
SELECT data*2 AS intermediate_result,
intermediate_result + 1 AS final_result
FROM table;
I know that MySql 4.1 can't handle it, but:
(a) Is it part of standard SQL? (I hav
I've got a GoDaddy virtual dedicated server and I'm trying to run a
LOAD DATA INFILE, but I keep getting "Can't get stat of '/home/httpd/
vhosts/04planet.info/httpdocs/test.txt' (Errcode: 13)"
As you can see from that error message, I've uploaded my data file to
the httpdocs directory and tr
No, I have nothing better in my mind :(
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>asteddy wrote:
>> Thank you, but why has mysql made seminars wich must be seen with a non-free
>> software with a 14 days trial? Is there nothing else to see it?
>> Asteddy
>
>Asteddy,
>
>I would guess bec
Thank you, I had found another link to use it direcly on the web and I thought
it was the only possible mode.
Asteddy
>On 6/17/05, asteddy <[EMAIL PROTECTED]> wrote:
>> Hello,
>> I have found Mysql Performance Tuning Seminar available for download, but I
>> don't know how to see it.
>
>Use the
Is there a way to return a value that has been modified via regular
expressions? For example, let's say I have a bunch of phone numbers.
Some of them were entered in like "(123) 456-7890" and some where
entered in (123-456-7890". I would like to only pull out the numbers
from these fields. I've
Ah, Thanks for the info.. Unfortunately, I already started things out
using mysqldump -c so it just creates complete insert statements. I
would be a little difficult to change things now. I will either have to
consider changing the way the dump files are created and then use LOAD
DATA, or just
as Rhino said, that's what i suggested.
mathias
Selon [EMAIL PROTECTED]:
> Salut Denisa,
> peux-tu essayer d'installer la 4.1.12 depuis le msi (après suppression de ce
> qui
> a été installé, même le répertoire) à cette url :
>
>
http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.12a-win32.z
It really is best if we keep conversations like this on the list rather than
offline; if we use the list, EVERYONE on the list can help and can learn
from your problem.
In this case, I was only trying to suggest a better way to ask your question
so that more people could help. I don't know what i
On Thu, 2005-06-16 at 21:06, Richard Dale wrote:
> > So we have recently started stress testing Mysql on an Opteron dual
> CPU
> > machine running Ubuntu Hoary. We are using the 64-bit GCC
> > 4.0.24-standard binary from mysql. The stress test that I'm currently
> > running on it involves ins
On Thu, 2005-06-16 at 21:06, Richard Dale wrote:
> > So we have recently started stress testing Mysql on an Opteron dual
> CPU
> > machine running Ubuntu Hoary. We are using the 64-bit GCC
> > 4.0.24-standard binary from mysql. The stress test that I'm currently
> > running on it involves ins
Davy Durham <[EMAIL PROTECTED]> wrote on 06/17/2005 12:41:24 PM:
> Hi,
> I was wondering if there's a way to make mysql not care about (or
> ignore) columns in an insert statement that don't exist in the table.
> For example, I have a dump from a table with 10 columns, but the new
> table has one
> to flush tables, you're right :
>
> flush table TOTO <= flushes only toto
> flush table TOTO,TITI<= flushes only toto and titi
> flush tables <= flushes ALL
OK, that's good news.
> Have'nt you thought to a master-slave replication and
Salut,
Quel OS, quelle version ? Quel type d'install : compile or binary
Mathias
Selon [EMAIL PROTECTED]:
> Hello,
>
> I'm trying to install MySQL and I have an error file named E103; it has 0
> Ko. What do I have to do in this case?
>
> Denisa Eustasius
>
> PS: it's the first time I install MyS
Hi,
Is dswu17.btconnect.com subscribed to the list with an activated login ?
Mathias
Selon Pooly <[EMAIL PROTECTED]>:
> I try to send a message to this list with another account, but the
> message came back with an error :
>
> Your message was not delivered to:
> mysql@lists.mysql.com
> fo
> 1) Reading TFM (http://dev.mysql.com/doc/mysql/en/flush.html) it appears
> that I do not have to 'FLUSH TABLES WITH READ LOCK' for each individual
> database. This statement flushes and locks all simultaneously. Am I
> correct?
HI,
to flush tables, you're right :
flush table TOTO
Hello,
I'm trying to install MySQL and I have an error file named E103; it has 0
Ko. What do I have to do in this case?
Denisa Eustasius
PS: it's the first time I install MySQL and I'm not informatician!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Hi,
Our MySQL 4.1.10 environment runs on Solaris 8 and the data is stored on
a NetApp filer. The schemas contain a mix of MyISAM and InnoDB tables.
To make a backup we lock all tables in all databases (USE database;
FLUSH TABLES WITH READ LOCK), and then tell NetApp to make a snapshot.
We have a
I try to send a message to this list with another account, but the
message came back with an error :
Your message was not delivered to:
mysql@lists.mysql.com
for the following reason:
Diagnostic was Unable to transfer, -1
Information MTA 'lists.mysql.com' gives error message Mail from HELO
Hello.
Check your MySQL error log. Sever could die during the query.
See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
Michael <[EMAIL PROTECTED]> wrote:
> I'm using PHP with MySQL to save files uploaded by users (up to 50MB) to
> a database. I'm having problems getting MySQL to
Hello.
Upgrade your MySQL. This is a bug:
http://bugs.mysql.com/bug.php?id=8471
Vincent MATHIEU <[EMAIL PROTECTED]> wrote:
> With mysql-max-4.1.7-pc-linux-i686 :
>
> If I start the mysqld with --skip-name-resolve, the following errors are
> writed in mysqld.log :
>
> 050620 8
With mysql-max-4.1.7-pc-linux-i686 :
If I start the mysqld with --skip-name-resolve, the following errors are
writed in mysqld.log :
050620 8:30:27 [Warning] 'host' entry
'194.214.218.192/255.255.255.224|%' ignored in --skip-name-resolve mode.
050620 8:30:27 [Warning] 'host' entry
'194.214
35 matches
Mail list logo