On Fri, Apr 4, 2008 at 6:30 AM, Shanmugam, Dhandapani
[EMAIL PROTECTED] wrote:
Hi,
Hi,
Any idea wat replicate-rewrite-db does with example..
It takes statements for one database, and rewrites them into another.
An example of the syntax would be this line in the my.cnf file of your
slave:
Hi,
On 3/19/08 3:51 PM, Brown, Charles [EMAIL PROTECTED] wrote:
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the cnf file
Ack, listen to Nanni not me. Join order doesn't matter, now that I tested
some more :).
Off to drink more coffee,
Dan
On 3/6/08 8:45 AM, Dan Rogart [EMAIL PROTECTED] wrote:
Hi,
On 3/6/08 8:33 AM, roger.maynard [EMAIL PROTECTED] wrote:
I got 4 tables:
Table A
| ID
Hi,
On 3/6/08 8:33 AM, roger.maynard [EMAIL PROTECTED] wrote:
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
| ID | Description3 |
Table D
| ID | Description4 |
ALL Ids ARE COMMON Values and NONE
On 3/6/08 12:09 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Thu, 6 Mar 2008, Dan Rogart [EMAIL PROTECTED] wrote:
On 3/6/08 8:33 AM, roger.maynard [EMAIL PROTECTED] wrote:
I got 4 tables:
Table A
| ID | Description1 |
Table B
| ID | Description2 |
Table C
Hi,
On 3/5/08 5:58 AM, Thufir [EMAIL PROTECTED] wrote:
On Tue, 04 Mar 2008 08:44:47 -0500, Dan Rogart wrote:
You can have a file called .my.cnf in your home directory that stores
it.
Ah, thanks. I don't have a .my.cnf file in my home directory, but I do
have something in /etc which
You can have a file called .my.cnf in your home directory that stores it.
This page outlines it pretty well:
http://www.modwest.com/help/kb6-242.html
In your case, you would just want to use the password = 'foo' part of it.
-Dan
On 3/4/08 4:10 AM, Thufir [EMAIL PROTECTED] wrote:
I
You should definitely consider getting rid of them, otherwise people can log
in to MySQL from any host with no credentials.
They are created during installation by the mysql_install_db script.
This tells you how to remove them:
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
-Dan
consider dropping or assigning passwords to.
Hope that helps,
Dan
On 3/4/08 9:57 AM, Hiep Nguyen [EMAIL PROTECTED] wrote:
On Tue, 4 Mar 2008, Dan Rogart wrote:
You should definitely consider getting rid of them, otherwise people can log
in to MySQL from any host with no credentials
Hi,
On 2/21/08 11:41 AM, Mike Spreitzer [EMAIL PROTECTED] wrote:
I have a table with millions of rows. I am not sure exactly how many rows
it has, I get a different answer every time I ask! What's going on here?
This DB is used only by me, and only by explicit commands --- I have no
You might want to check out Baron Schwartz's maatkit:
http://maatkit.sourceforge.net/
It has scripts which let you take dumps and do restores using multiple
threads. It might help speed things up for you.
-Dan
On 2/15/08 1:55 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi:
I am
Have you tried starting mysqld with innodb_force_recovery = x ? (where x =
values defined below)
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
That might get you past the corruption that's killing startup.
-Dan
On 2/13/08 12:32 PM, Bryan Cantwell [EMAIL PROTECTED] wrote:
No
a dynamically-linked binary, or force LinuxThreads
to be used with the LD_ASSUME_KERNEL environment variable. Please consult
the documentation for your distribution on how to do that.
Number of processes running now: 0
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13
On 11/14/07 4:01 PM, Mike Johnson [EMAIL PROTECTED] wrote:
Correction to a couple of replies I've seen -- a slave server can have
more than one master, but not to the same database. That is, Slave reads
Database1 and Database3 from Master1 and also reads Database2 from
Master2.
You may
OPTIMIZE TABLE should reclaim that space, but be aware that it could
take a while to run (locking your table all the while) since it just
maps to an ALTER TABLE statement which creates a new copy of the table.
Depends on how big your tables are.
Doc:
So, just to clarify: optimize table just defragments the index?
Apologies, I misinterpreted the documentation then.
Thanks,
Dan
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 10, 2007 3:05 PM
To: Tiago Cruz
Cc: Eric Frazier; Dan Rogart
Frank-
I've had the exact same issue crop up in our prod servers - it was very
frustrating, as it was intermittent and would affect some of our slaves,
but not all.
We had a lot of back and forth with MySQL support without really being
able to consistently pin down or reproduce the issue.
17 matches
Mail list logo