PROTECTED] dan [EMAIL PROTECTED]
Maklumat lanjut sila layari http://amagro.blogspot.com
Terima Kasih diatas kesudian anda membaca email ini.
Sudi-sudikan lah forward email ini kepada kenalan yang berminat.
Harap bertemu anda di Melaka
Hi,
What's in the bin-logs? (mysqlbinlog log)
cheers,
Doug
Original Message:
-
From: David Giragosian [EMAIL PROTECTED]
Date: Wed, 17 Sep 2008 12:38:01 -0500
To: mysql@lists.mysql.com
Subject: Show Master Status
Hurricane Ike has caused our replication set-up to misbehave
padding them with leading zeroes to five characters?
If you have padded them so that the first five characters are always the
country code, then you can simply do
SELECT
-Original Message-
From: Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2008 2:27 AM
To: mysql@lists.mysql.com
database: 'opnser'. Query: 'insert into acc
(method,from_tag,to_tag,callid,sip_code,sip_reason,time,ani,did,dnis )
values
('BYE','3405618788-778336','516B0D10-1448','[EMAIL PROTECTED]
hnl.aloha.net','200','OK','2007-12-02
21:14:23','8088646143','818084473408','14378288809164968574')'
Skip counter: 0
and
update I execute myself updating the data
Why do it?
I'm use MySQL 4.1.20 and MyISAM tables
Thanks,
Pablo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi list,
I am going to change the type of table to InnoDB
Thank!!
Pablo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
インストールできるはずなのですが
インストールはできてもrootでのアクセスができません。
mysqlというユーザではアクセスできますが、rootのパスワードを
リセットしようとすると権限エラーが出ます。
何かこのような場合のヒントをいただけませんでしょうか。
お手数をおかけいたしますがどうぞよろしくお願いいたします。
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
インストールできるはずなのですが
インストールはできてもrootでのアクセスができません。
mysqlというユーザではアクセスできますが、rootのパスワードを
リセットしようとすると権限エラーが出ます。
何かこのような場合のヒントをいただけませんでしょうか。
お手数をおかけいたしますがどうぞよろしくお願いいたします。
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
try
CREATE INDEX geo_idx ON users(entity_id, user_type);
Filip
Alex Arul napsal(a):
and also an index on users.entity_id (will help the join) should solve your
problem.
Thanks
Alex
On 1/24/07, Brent Baisley [EMAIL PROTECTED] wrote:
You should create indexes on the fields you search
optimised solution
Thanks a lot
- Original Message
From: Tim Lucia [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, November 11, 2006 3:56:49 PM
Subject: RE: MAX() and GROUP BY question
How about
select ID, X, Y, Z from USERS order by ID desc limit 1
Tim
-Original Message
Thanks a lot for any suggestions
Yannis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of forwarded message ---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
List-Unsubscribe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to the
current timestamp.
Does anybody know how can I make a timestamp field be not null?
Lots of thanks to you all.
Prueba el Nuevo Correo Terra; Seguro, Rápido, Fiable.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
timeout has expired or not
and so act accordingly.
I guess I can use some sort of integer in order to represent it as a unix
timestamp, but I would prefer to use a timestamp.
Any suggestions?
Kind regards
Mensaje original
De: [EMAIL PROTECTED]
Recibido: 10/04/2006 11:51
Para: [EMAIL
Hi!
Can I return a record set from a stored procedure/function in mysql?
Kind regards
Prueba el Nuevo Correo Terra; Seguro, Rápido, Fiable.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5.x on
Opteron machine with FreeBSD 6.0-STABLE.
Ganbold
Thanks
JK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-in? If not, what other approaches could I use, triggers ...?
Kinf regards.
Prueba el Nuevo Correo Terra; Seguro, Rápido, Fiable.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a way i can convert the strings converted from old password to
passwords one.So that it become compatible to the passwords one.
--
Abhishek jain
Original Message:
-
From: Ryan Stille [EMAIL PROTECTED]
Date: Wed, 18 Jan 2006 08:03:14 -0600
To: [EMAIL PROTECTED]
Subject: RE
://lists.mysql.com/[EMAIL PROTECTED]
.
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* only entry no. 13 will be shown.
If I search for *AFAN* only entry no. 14 will be shown.
?!?
Thanks.
-afan
Jasper Bryant-Greene wrote:
[EMAIL PROTECTED] wrote:
but I'm getting case insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Your two statements contradict
insensitive search?!? it's not the same I enter
afan or Afan or AFAN!??
Any ideas?
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 03 de Noviembre de 2005 03:55 p.m.
Para: MySQL List
Asunto: report from two tables
Hi,
I have two table for orders and I have to create a Report with list of
orders from both tables for specific day.
I made Reports for each table
Thanks Shawn.
See comments:
[EMAIL PROTECTED] wrote:
Sorry I didn't get back to you earlier today. I have had a busy day.
Comments embedded...
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 10/20/2005 04:35:30 PM:
Could you please tell me should this work?
CREATE TABLE categories
solution, administrator has to turn on/off on
sale. I need to automate this by start and end dates for sale.
Any ideas?
Thanks for any help.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you hae to apply two 'methods' to one
product?
PB
-
[EMAIL PROTECTED] wrote:
Could you please tell me should this work?
CREATE TABLE categories (
cat_id INTEGER(8) UNSIGNED NOT NULL AUTO_INCREMENT,
cat_name VARCHAR(45) NULL,
cat_description TEXT NULL,
cat_parent INTEGER(4) UNSIGNED
List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No. It doesn't work. First, I found one error: there are two columns for
same thing in ac_products ac_products_product_id and product_id.
Second, ac_extended_prices table doesn't fit with multiple solutions
:(
[EMAIL PROTECTED] wrote:
Thanks guys for really detailed answers.
After your
) UNSIGNED NULL,
c_id INTEGER(6) UNSIGNED NULL,
PRIMARY KEY(pc_id),
INDEX pc_index(p_id, c_id),
);
Or, there is better solution?
Thanks!
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table doesn't have any other association.
It doesn't matter who, when, why added a prodcut to particular category.
Thanks Shawn.
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 10/18/2005 01:50:20 PM:
Hi to all!
I have tables products and categories
CREATE TABLE
) NOT NULL,
product_type ENUM('regular','sale') NOT NULL DEFAULT 'regular',
PRIMARY KEY(price_id),
INDEX ac_prices_index1(price)
);
How close am I?
:)
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 10/18/2005 01:50:20 PM:
Hi to all!
I have tables products
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
What could possibly be preventing the system from changing the GRANT of myUser?
Is the mysql.db table part of the granting?
thanks in advance for your help.
laurie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
is querying the db for every exception-type-table,
which I'd prefer not doing.
TIA,
Stijn Verholen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://dev.mysql.com/doc/mysql/en/charset.html
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
I'm trying to import a db dump made on ver. 4.0, on a new 4.1 vers=
ion.
All accented characters (french, spanish) are replaced by a '?'=0D
=
What it's the right way to import it ?
Thanks
-charset.html
mathias
Selon [EMAIL PROTECTED]:
Salut,
i don't see what doesn't work ! Where characters are replaced by ?, since
you
say that insert,select and import work fine ? is it in the export ?
see http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html for migration
e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+--+---+
3 rows in set (0.00 sec)
have you tried some inserts to see if it is an import problem, or just the
client display ?
Mathias
Selon [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hi,
I
en Français');
then :
select toto from table;
can you read it correctly ? And if the same row is imported, is there any
difference ?
A bientôt
Mathias
Selon [EMAIL PROTECTED] [EMAIL PROTECTED]:
Salut,
je vois que tu es français, j'aimerai bien continuer en français mais il
vaut
archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I created a mysqldump with --quote-names option, but I get this
error:C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test5.txtERROR 1005 at
line 54: Can't create table '.\db2\shift.frm' (errno:
150)C:\xampp\xampp\mysql\bingt;Line 54 is the CREATE TABLE... line of the
following bit of SQL from
of mysqldump?
Later ones may not be bkwds compat.
Can any-one help?
Andrew H
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net
I am having to operating MySQL 4.0.18, I had heared that I could copy a db
folder out of the mysql/data folder to the same folder on a different machine
running its own local host server and that server would have a copy of the
database. HOWEVER, o some occasions this seemed to work Ok, and on
Yes I had thought I should use tools to copy, but I have had problems with
mysqldump. I successfully created a dump file, but when I execute this file on
an empty database I got:
C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test1.txtERROR 1064 at line
54: You have an error in your SQL
I backup a db using mysqldump, but when I come to execute the sql file on an
empty db I get this
C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test3.txtERROR 1005 at line
54: Can't create table '.\db2\shift.frm' (errno: 150)
C:\xampp\xampp\mysql\bingt;
I have tried to fix the foreign key
MySql vers 4.0.20
A table noticeboard has three test entries.
A unix time from date(U) is stored in the field published of type,
bigint20.
I am not able to workout how to select the year. Assuming that the
value from date(U) can be treated as a unixtime value, my latest
unsuccessful effort
When I opened the message send by:
[EMAIL PROTECTED]
subject: Boolean searches
a pop up box appeared stating
Connect to 70.84.29.164
Web host manager
Username mymachine/administrator
password:
Has anybody encountered this problem when you cliked on his email
Should we FLAME that guy?
In the mean
Yes I received the same email about being a spammer.
Somebody on the list told me that our email headers get rewritten and
sometimes you get this email about being a spammer.
Laurie
At 02:29 PM 4/8/2005, Keith Ivey wrote:
[EMAIL PROTECTED] wrote:
This is what I call WAY OVER REACTING
the rollback problem?)
The latter consumes less disk space, performance wise is better.
Do you see any other drawback / advantage?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with their
4.1.7 MySQL).
Regards.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
message suggests a firewall somewhere between the
two machines, I would guess it's most likely running on your host and you
don't know it.
Lachlan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 2:18 AM
To: Victor Pendleton
Cc
:
ERROR 2003: Can't connect to MySQL server on 'linuxready' (111)
Maybe is it possible that I have to configure some attribute in my.cnf?
thanks in advance
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(first: excuse for my english)
On Monday 19 July 2004 15:03, Victor Pendleton wrote:
Can you telnet port 3306 on linuxready from the remote machine?
nop.. :/ .. i cant do telnet to linuxready 3306 ¡
-
[EMAIL PROTECTED] $ telnet linuxready 3306
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to FIVE TIMES FASTER!
Only $14.95/ month -visit www.netzero.com to sign up today!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
know if i have a unsolutionable problem.. or
something like that..
i only wanted to comment this.. :D
thanks
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. We have a dedicated XServe running MySQL and we
use another XServe whose primary function is filesharing to also act as
a replication slave. Each night a system cron script stops MySQL, backs
up the slave XServe, and then restarts MySQL
On Jun 24, 2004, at 7:01 AM, [EMAIL PROTECTED] wrote
keys.
and then i think:
how is it possible that i cant do backup, and recover it, of my innodb tables?
thanks for the suggestions
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1.
:).. but dont worry i write the sentences by hand.
thx
d2clon
On Thursday 24 June 2004 11:44, Egor Egorov wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
i have read multiple websites and posts.. and this mail list archive
but i have not found
MySQL, backs
up the slave XServe, and then restarts MySQL
On Jun 24, 2004, at 7:01 AM, [EMAIL PROTECTED] wrote:
thx thx :D
thats work right.
the only problem is that mysqldump dont write the 'set
FOREIGN_KEY_CHECKS'
sentences until version 4.1.1:
To make it easier to reload dump
trick?
Thanks, rinke
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
There's got ot be something else wrong. I've got the exact same problem and
I have done a chmod 666 on the directory I am trying to write to with no
luck. I am running v4.0.15
/T
on 6/1/04 7:06, Egor Egorov at [EMAIL PROTECTED] wrote:
John Mistler [EMAIL PROTECTED] wrote:
Would there be any
' (Errcode: 13)
I¹ve granted full rights to anyone who accesses /Users/user/temp. Any ideas
as to what I can do to fix this?
VR/Tim
Best IT
cell: 504-231-1084
fax: 206-338-6162
[EMAIL PROTECTED]
http://www.best-it.biz
.
(i suppose that mysql command line client is non-interactive when it
runs with the -e parameter)
rudolf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:http://lists.mysql.com/[EMAIL PROTECTED]
List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:http://lists.mysql.com/[EMAIL PROTECTED]
mail2web - Check your email from the web at
http://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
user
but i can not create and modify databases
it gives an error access denied for user [EMAIL PROTECTED]
i do not know how to recover root privileges
please help me
mail2web - Check your email from the web at
http
doesn't change while multiple calls:
SELECT * FROM banners GROUP BY user_id ORDER BY RAND();
Can anyone help me?
Thanks in advance,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
...
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:http://lists.mysql.com/[EMAIL PROTECTED]
/known issues)
hope this helps
brian
[EMAIL PROTECTED] wrote:
OK. Thanks. Late now, and laptop is off. Client is the mysql.exe
program.
I have to copy the mysql.exe to the laptop (or cd to the server machine
and execute from it. Leave the space out.
Right now, just fooling around from the server
connect.
But, I don't have the 4.1.1 client. Where is it? There is no
'...client' in the bin directory.
Thanks,
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 4:15 PM
To: N. Chris Frost
Cc: [EMAIL PROTECTED]
Subject: Re: Can't
server).
When I move to the shared directory on the PC and try to execute mysql,
I get the error.
Thanks for an assistance.
N. Chris Frost
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://mail2web.com/ .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
For some time we've been running MySQL (from 4.0.1 to 4.0.17) on Redhat (v. 7.2
9.0). We use our linux server for one thing: MySQL server.
We are far from linux experts, so Redhat made sense, particularly the ease of
installation and the bugfixes via up2date. Now that Redhat is
Thanks a lot for your kind and amusing explanation!
I will have a look at MySQL thread layer AND of course wait for kernel
2.6..
Chris Nolan wrote:
On Thu, 2004-01-08 at 21:10, [EMAIL PROTECTED] wrote:
Andy Bakun wrote:
On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote:
Hi
\x00\x00\x00\x00\x00(?\x0f?3\x02\rwww.bbc.co.uk\x05utf-8Q
Anybody knows what is going on?
Thanks,
-Jalil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks
Fabio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/[EMAIL PROTECTED]
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://lists.mysql.com/[EMAIL PROTECTED]
List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 255 matches
Mail list logo