Hi,
Le 12/12/2014 11:51, Johan De Meersman a écrit :
- Original Message -
From: "yoku ts."
Subject: Re: command is not allowed with this MySQL version
Christophe has already told,
The used MySQL version is 5.5.40 from Debian Wheezy package.
No, that's the new versi
for instance)
can be used to get rid of this error, but can't really find the right
configuration.
Is there any way to do this ?
Thanks and regards.
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Le 19/09/2014 18:00, Christophe a écrit :
Hi there,
Le 19/09/2014 17:19, Don Wieland a écrit :
grant all privileges
on teal1dwd_teal.*
to 'teal1dwd_teal'@'localhost'
identified by 'my_user_pw';
I get this error:
#1044 - Access denied for user
base
'teal1dwd_teal'
I think you are trying to access the DB with the 'teal1dwd' user, but
your grant applies to 'teal1dwd_teal'.
Hope this helps ;).
Regards,
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
'7' for French keyboard layout ;)
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi there,
Le 23/05/2014 21:06, Roland RoLaNd a écrit :
> [...]
Ouch
This post is somewhat ... unreadable !
Please format !
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
think operation is successful ;) .
Thanks Shawn !
Regards,
Christophe.
Le 23/03/2014 18:49, Christophe a écrit :
> Hi Shawn, and thanks for this concise anwser ;) .
>
> Le 22/03/2014 05:35, shawn l.green a écrit :
>>
>> The system is operating exactly as designed. The ib
Hi all,
Le 20/03/2014 13:20, Christophe a écrit :
> Hi Morgan, Harald, and all,
>
> Thanks for the answers.
>
> While reading your answers, I realize one more time this problem does
> not seem so obvious ... That's why I asked ;) .
>
> Beyond the specific case I
easing the Size of the InnoDB
> Tablespace"
>
It's just what I wanted to avoid :( ... but thanks for the link ;).
As a Workaround, I think I will run a second MySQL instance during task,
and make a binary copy of files after making sure they are good.
Best thanks and R
e does not exist".
Is there anyway to handle this case ?
Regards .
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
while handling WHERE clauses.
I don't have access to the application for now, but will try EXPLAIN as
soon as I can .
Regards,
Christophe.
Le 19/03/2014 17:12, Morgan Tocker a écrit :
> Hi Harald,
>
>> you can call me Harald
>
> My apologies!
>
>> the question
into DATE_SUB(NOW(), INTERVAL 24 HOUR) INTO @yesterday ;
>
> SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN
> ('PENDING', 'ACCEPTED') AND SubscribeDate < @yesterday);
>
Indeed ! it can be a significant performance improvement ;).
Thanks for this .
there any performance impact on query processing, about the order of
WHERE clauses ?
Regards,
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
k I need more physical memory ?
Bests,
Christophe.
----
Christophe Dumonet
Centre de Ressources Informatiques
Institut Francais de Mecanique Avancee (IFMA)
Campus des Cezeaux
BP 265
63175 AUBIERE Cedex
Tel : +33 - 4.73.28.80.64
Fa
_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 16M
includedir /etc/mysql/conf.d/
Any help would be appreciate !!
Bests
--
--------
Christophe Dumonet
Centre de Ressour
Some good advice, applying to both mailing lists and businesses:
Always reply-to-all, unless there is a good reason not to.
My 2 cents.
Rob Wultsch schreef:
I was previously on a list where the reply-to was setup as it is on the
mysql list, with the originator receiving a response rather than
CREATE TABLE `tags` (`tagid` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY
KEY, `location` VARCHAR(255) NOT NULL DEFAULT '') ENGINE=INNODB;
CREATE TABLE `dimension_type` (`id` ..., `type` VARCHAR(255) NOT NULL
DEFAULT '') ENGINE=INNODB;
CREATE TABLE `tags_shape_dimensions` (`tag` INT(11) UNSIGNED, `dim
Ofcourse, the number of queries is just the value of Questions.
Christophe Gregoir wrote:
I have to admit, Google doesn't provide much information.
Let's take a closer look and see if we can't figure out ourselves what
that value means.
Here is the output of `mysqladmi
load.
Question answered ?
grtz
C.R.Vegelin wrote:
Thanks Christophe,
Question rephrased: how do you explain 0.05 q/s = 20 s/q
with an immediate response ?
Cor
- Original Message - From: "Christophe Gregoir"
<[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL
C.R.Vegelin wrote:
...
How should I interpret "Queries per second avg" ?
How about as 'queries per second on average' :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey Mike,
Sounds like you would be better of with an ENUM of integers, e.g.
ENUM(-1,1,2,3) where -1 stands for to be started, 1 for started and so on.
To answer your question:
ORDER BY `status` = 'to be started', `status` = 'started', `status` =
'finished', `status` = 'canceled'
Mike van Hoo
Hiep Nguyen wrote:
i believe "date" is a reserved word for mysql. don't use reserved word
for the column name. it's confused.
Using reserved words may be confusing, but it is fine as long as you put
them between backticks, as I'm sure the OP is aware of.
On Tue, 20 Mar 2007, Peter wrot
Drew Jenkins wrote:
- Original Message
From: Borokov Smith <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 6:21:59 PM
Subject: Re: Can't Bind to Port
netstat -nlp | grep 3306
Option p requires a protocol. What pro
ed to direct ISAM calls. Do some of you have
experience of HANDLER usage ?
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run reports in a MySQL DB through sql queries and I use a statement like "
... invd between current_date - 7 and current_date - 1 ..." It always
worked.
I just noticed that this week's report was wrong. Indeed : c
Hi,
i've got the same kind of problem but not in a dump, in a restore. I
tried to restore it in a MyIsam type table but i have the same error.
Could other server variables interfer in this ? For example, i see
that my long_query_time is set to '10' ...
--
Christophe Charron
PRO
measure their usage?
3. Can there be some other explanation why MySQL is not pulling 100% of
at least one system resource?
Thanks a million,
Christophe Meslin
27; at line 1
mysql> select version();
++
| version() |
++
| 4.0.3-beta-max |
++
mysql> create table testTable (name varchar(10), age smallint default -1);
Query OK, 0 rows affected (0.01 sec)
Does somebody have the same problem ?
Hi.
Upgrading to 4.1.1 from 4.1.0 seems to solve my problem. There is no more
(at the moment) curious privileges problems. Everything seem OK.
Thanks to MySQL.
N.B.: Please se the history of the problem bellow.
Christophe.
On Tue, 2 Dec 2003, Sergei Golubchik wrote:
> Hi!
>
>
db from db;
+-+--++
| user| host | db |
+-+--++
| ccsql | %| cctandem |
| ccsql | %| cctandemOnline |
| ccsql | %| cctest |
| archive | %| dbancien |
| archive | %| dbcourant
Hello,
I'm using MySQL 4.0.15 standard - InnoDB and I got a deadlock. I don't
see why !
How Can I find the reason ? It seems to occurs on delete statments.
Regards,
Christophe
Here is my InnoDB status :
=
Per second averages calculated from t
er.
So my goal is to desinstall v4.0.13, and re-install v4.0.14.
But my current issue is "how do I stop the mysqld process?"
Even if stopping from Task Manager is not the best approach, do I have
another option?
Please help.
Christophe Poirier
on the process for MySQL in the processes
tab of Task Manager and select End Process.
--- Christophe Poirier <[EMAIL PROTECTED]> wrote:
> I am working on a Windows 2000 server.
> The version 4.0.13 was installed at the end of June
> because we are looking
> at using MySQL.
>
I did find out :-)
I had to edit the mysqld in /etc/rc.d/init.d
It's can be done on a linux partition without problem.
;-)
Jean Christophe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can
make it to a ext3 !)
Thank's
;-)
Jean Christophe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
0-00-00 00:00:00',
`idarchive` bigint(20) NOT NULL default '0',
`jamaiseffacer` char(1) NOT NULL default '',
PRIMARY KEY (`iddatephoto`)
) TYPE=InnoDB
1 row in set (0.00 sec)
Thanks in advance for your he
I use the binary from :
http://www.entropy.ch/software/macosx/
Christophe
On Wed, Nov 27, 2002 at 12:35:45PM -0800, Chris Herold wrote:
> i'm trying to install MySQL 3.23.53 on OS X.
>
> It seemed pretty easy as i followed the directions on the devshed
> website, but when
Hello All,
I have done quite a bit of searching but have not been able to find any
MySQL 3.23.x Binary packages for AIX 4.2.1 (RS6000) any help in locating one
would be very much appreciated.
Thank you,
Christophe Banal
27;select * from ouble_test').
Any idea or experience to share.
Thanks in advance,
Christophe.
***
Christophe DIARRA
Institut de Physique Nucleaire
15, Rue Georges Clemenceau
Bat 102 - S2I
91406 ORSAY Cedex
Tel: (33) 1 69 15 65 60
Fax: (33) 1 69 15 45 03
Is it then correct that VARCHAR(255) and TINYTEXT are strictly
equivalent?
If no, where is the difference?
Thanks,
Christophe
NOTE: I understand now the "sql,query" stuff. Strange idea.
--
Christophe Barbé <[EMAIL PROTECTED]>
GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67
the mailing list.
Christophe
Le mar 08/10/2002 à 12:06, Brent Baisley a écrit :
> VARCHAR basically sets a maximum length for the field and only stores
> the data that is entered into it, thus saving on space. The CHAR type
> has a fixed length, so if you set CHAR(100), 100 character
HAR
which use only one byte to store an empty comment.
Christophe
> christophe barbe wrote:
>
> >What are the disadvantages of using VARCHAR instead of CHAR.
> >Is it going to be considerably slower?
> >
> >
> It really depends on your table, but if you
te another table to store the comments only when defined by
the user?
Thanks,
Christophe
--
Christophe Barbé <[EMAIL PROTECTED]>
GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E
Imagination is more important than knowledge.
Albert Eins
-Message d'origine-
De : Tonu Samuel [mailto:[EMAIL PROTECTED]]
Envoye : mercredi 12 juin 2002 10:51
A : Christophe BRAM
Cc : [EMAIL PROTECTED]
Objet : Re: Foreign key integrity pb ?
On Wed, 12 Jun 2002, Christophe BRAM wrote:
> I'm using MySQL Max 4.0.1
>
>
I'm using MySQL Max 4.0.1
CREATE TABLE TableTwo
(
Id int NOT NULL auto_increment,
FK_TableOne int NOT NULL REFERENCES TableOne(Id),
PRIMARY KEY (Id)
) TYPE=InnoDB;
--> How can this work without having beforehand created the table "TableOne"
???
Hello,
I had written last week because I tried to send a mail to
[EMAIL PROTECTED] about MySQL transactions without success.
[EMAIL PROTECTED] answered me, but I can't send a mail to him.
Using "set autocommit=0;" doesn't fix the problem...
My problem was :
We have 2 threads using sql instruct
have only found
master-slave relationship. We think this master-slaves relationship doesn't
exactly fit our needs.
Please could you explain us what is the best solution to use for this
architecture.
Thank you for your support.
_____
Christophe DEMANGE
Project Ma
ke distribution.
Could you help me ?
Christophe Dirlik
Answer to : [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi,
I'd like to run a mysqlclient on a homemade communication hardware
running pSOS operating system.
Has somebody already ported the mysqlclient to pSOS ?
If not, what should I begin with, and how difficult would it be ?
Thanks
Chris
lp me
Christophe
(gdb) x/3s buf
0xbfffabc8: "SELECT ag_id,call_ref,rfgi FROM voies_ag,voies WHERE
dac_id=0 AND voies_ag.voie=voies.voie \t\t\t\tAND voies_ag.etat=1 AND
DATE_ADD(voies_ag.date_etat,INTERVAL 40 SECOND)...
0xbfffad58: '0' , "' AND voies_ag.renvoi=0"
(gdb
.
--
Christophe Suire <[EMAIL PROTECTED]>
"Software is like sex, it's better when it's Free !"
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
51 matches
Mail list logo