Hello DBAs,
Though this is not exactly a mysql problem, but I think this list may
be helpful for my question.
I have dumped a mysql data file, and scp it to another host.
The current host is ubuntu-8.04, the remote host is ubuntu-9.10.
As you can see below:
The current host:
$ md5sum
I have been using the M-M replication over years.
But we only write to one node at any time.
When this node is unusable, we write to another node.
On Wed, Aug 3, 2011 at 1:10 PM, Angela liu yyll2...@yahoo.com wrote:
Hi, Folks:
Does mysql support master to master replication, or master to
You need to group by event_text, not obj_text:
select source_id ,event_text,count(*) from event_loc
group by source_id,event_text;
Date: Tue, 8 Feb 2011 16:31:39 +0530
From: adarsh.sha...@orkash.com
To: mysql@lists.mysql.com
Subject: Group By Problem
Dear all,
I stuck around one
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
So, a problem popped up today that has caused us no end of hair-pulling, and
it
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=hexi...@gmail.com
--
Thanks Best regards,
Xiong HE
Hi Gavin,
I am interested in the things you made for the optimization. Can you share
with us such things?
Thanks a lot,
--
Banyan He
Network System Security Infrastructure
Mail: ban...@rootong.com
Blog: http://www.rootong.com/blog
LinkedIn: http://www.linkedin.com/in/banyanhe
Website: http
of a cpu.
Any reply is appreciated,thanks.
--
Banyan He
MailWeb Security
Mobile: +86 13641777622
MSN: [EMAIL PROTECTED]
Skype: banyan.he
Email: [EMAIL PROTECTED]
AntiSpam Test: [EMAIL PROTECTED]
AntiVirus Test: [EMAIL PROTECTED]
Wemaster Mail: [EMAIL PROTECTED]
Website: http
also listens to
the physical address of the host.
I see that MySQL listen only to 127.0.0.1:3306 and therefore every
connection via the physical interface is reset.
What can I do?
Regards
Franz
--
Banyan He
MailWeb Security
Mobile: +86 13641777622
MSN: [EMAIL PROTECTED]
Skype: banyan.he
advices will be appreciated.
Regards,
--
---
Banyan He
IronPort Customer Support
MSN: [EMAIL PROTECTED]
Skype: banyan.he
Email: [EMAIL PROTECTED]
http://www.rootong.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
He* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Hi Guys,
I encounter an issue once I backup the database.
mysqldump -u admin -phost --databases message_tracker z:
sqlbackup.sql
mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost'
to database
Yes, the server shows me that. I cannot execute the grant command.
This is a serious restriction software works with mysql.
Ananda Kumar wrote:
You mean to say, you cannot execute the GRANT command.
regards
anandkl
On 7/19/07, *Banyan He* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote
software
environments, is the better solution. In this case, it clearly is not.
regards,
boro
Banyan He schreef:
Yes, the server shows me that. I cannot execute the grant command.
This is a serious restriction software works with mysql.
Ananda Kumar wrote:
You mean to say, you cannot execute
thx Ananda. I will try.
Cheers,
Ananda Kumar wrote:
Hi Banyan,
Permission can vary from database to database.
Please ask your dba to grant you the permission and then try the
mysqldump
On 7/19/07, Banyan He [EMAIL PROTECTED] wrote:
The question is in this server, I cannot backup
the
mysqldump
On 7/19/07, Banyan He [EMAIL PROTECTED] wrote:
The question is in this server, I cannot backup the database by issuing
mysqldump. On another server, I can. I am sure nobody changes the
settings. That's confusing to me.
ant command because you don't have permission to do so
Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 18, 2007 9:37 PM
To: He, Ming Xin PSE NKG; mysql@lists.mysql.com
Subject: Re: Problem on millions of records in one table?
It all depends on how complicated your data and searches are. I've got
tables that add 2-3
Hi, Pipes
Is it reliable to use MySQL 5.1 in a commercial product now since it is
still a beta version?
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 18, 2007 10:04 PM
To: Brent Baisley
Cc: He, Ming Xin PSE NKG; mysql@lists.mysql.com
Subject: Re
Hi,all
The number of the records in one table increase constantly. As
evaluated, the amount would increase to at least 30 millions within one
year. So we worry about whether mysql could handle such a big amount of
records with good performance. Or need we some other solutions to avoid
this
by hiring date,
and figure out where Joe falls in that list. (i.e. which
record number
is he?)
If 'Joe' is a unique name LOL...
SELECT 1 + COUNT(*)
FROM employees
WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue;
PB
James Tu wrote:
Is there some quick way to do
I assume someone send the copy of the message. So that we get the
duplications.
Since we all reply to all the mail senders.
- Original Message -
From: Jacques Brignon [EMAIL PROTECTED]
To: 'Banyan He' [EMAIL PROTECTED]; 'LP' [EMAIL PROTECTED]; 'MySQL
List' mysql@lists.mysql.com
Sent
From: He, Gang
Sent: Wednesday, April 12, 2006 8:43 PM
To: '[EMAIL PROTECTED]'
Subject: Mysql C API character set
Hi,
I install MySQL server 4.1.12 in Redhat Linux in Japanese environment (
env LANG=ja_JP.UTF-8 ),
I setup MySQL server utf8
Hi,
I have a question with regards to Load data infile...
I have a .txt file containging only path names e.g C:\temp in the
bodytext. this file is imported into the DB using load data infile.
However, when i do a select * on that table which i've just imported,
the result looks like this:
Hello,
What is the sql command which is the same as command
show tables ? Other database stores all tables in a
system table, is there one in mysql ?
Thanks,
Tom
__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos More
Hello,
I m using WinXP / Office XP and need odbc support to create a circular
letter.
I have installed mysql, etc. all works fine.
But I cant get Word to work with odbc drivers. They seem to work, they
get connection
To my database but word says something like this :
couldn't obtain table lists
Professional JSP, by Wrox Press Ltd, is a quite good book.
Matt
- Original Message -
From: Robert Alexander [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 2:48 PM
Subject: Info on using MySQL with Java
Hi all,
I'm looking for some pointers towards some good
24 matches
Mail list logo