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
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
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:
>>>
>>
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
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
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
are the users you should 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
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
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 unde
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 n
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
; This can result in crashes on some distributions due to LT/NPTL conflicts.
> You should either build 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 t
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:
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.
>
>
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
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: http://dev.mysql.com/doc/refman/4.1/en/optimiz
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.
Ultima
17 matches
Mail list logo