Re: Tuning mysql

2012-02-06 Thread Reindl Harald
Am 07.02.2012 00:55, schrieb Grant: > I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should > change any settings. I'm using mysql with a website on the same > server so I have skip-networking, and I increased key_buffer and > innodb_buffer_pool_size from 16M to 256M. Everythin

Re: Delete from another table on update.

2012-02-06 Thread Hal�sz S�ndor
2012/02/06 11:33 -0400, Paul Halliday Is it possible to wrap a DELETE statement in an ON DUPLICATE KEY UPDATE? Something like: ON DUPLICATE KEY UPDATE host="b1" (DELETE FROM another_table WHERE host="b1") ? No; see http://dev.mysql.com/doc/refman/5.5/en/insert.html Such things

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Frédéric Descamps
Larry, You are welcome. If you want to create the selinux policy from your audit.log, you can check the instruction from this post: http://www.lefred.be/?q=node/129 Cheers, On Mon, 2012-02-06 at 14:54 -0700, Larry Martell wrote: > 2012/2/6 Frédéric Descamps : > > Hi, > > > > check your audit.lo

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
2012/2/6 Frédéric Descamps : > Hi, > > check your audit.log if you have selinux enabled Ah, thanks for mentioning this. I didn't even think of that. Sure enough, if I disabled selinux, it worked. Now I have to figure out why it's failing under selinux. In the audit log I see these messages when I

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Frédéric Descamps
Hi, check your audit.log if you have selinux enabled On Sat, 2012-02-04 at 17:57 -0700, Larry Martell wrote: > Just installed mysql on centos 6.2. When I try to start it with service I get: > > #service mysqld start > MySQL Daemon failed to start. > Starting mysqld:

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Michael Dykman
On Mon, Feb 6, 2012 at 3:34 PM, Larry Martell wrote: > On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL) > wrote: >> On 2/4/2012 19:57, Larry Martell wrote: >>> >>> Just installed mysql on centos 6.2. When I try to start it with service I >>> get: >>> >>> #service mysqld start >>> MySQL Daemon

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 1:26 PM, Shawn Green (MySQL) wrote: > On 2/4/2012 19:57, Larry Martell wrote: >> >> Just installed mysql on centos 6.2. When I try to start it with service I >> get: >> >> #service mysqld start >> MySQL Daemon failed to start. >> Starting mysqld:                            

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Shawn Green (MySQL)
On 2/4/2012 19:57, Larry Martell wrote: Just installed mysql on centos 6.2. When I try to start it with service I get: #service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] Nothing at all is written to the error log. But if I st

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-06 Thread Shawn Green (MySQL)
Hello Stan, On 2/3/2012 20:06, Stan Iverson wrote: On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersmanwrote: - Original Message - From: "Stan Iverson" I have a Mac and a Linux server and I need to read the table schema for a database dump from MSSQL. Possible? How? Heeh. If you're t

Re: how to changing default '-' character in Datetime in MySQL?

2012-02-06 Thread Hal�sz S�ndor
2012/02/05 21:56 -0800, Peter Brawley On 2/5/2012 9:21 PM, Michael Dykman wrote: >You are right. It seems to have fallen into disuse since I used it last. AFAIK it has never been used. One use occurred to me, and I was thinking of this, to set "date_format" in the configuratio

Delete from another table on update.

2012-02-06 Thread Paul Halliday
Is it possible to wrap a DELETE statement in an ON DUPLICATE KEY UPDATE? Something like: ON DUPLICATE KEY UPDATE host="b1" (DELETE FROM another_table WHERE host="b1") ? Thanks. -- Paul Halliday http://www.squertproject.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 7:42 AM, Chris Tate-Davies wrote: > On 06/02/12 14:34, Reindl Harald wrote: >> >> >> Am 06.02.2012 15:28, schrieb Chris Tate-Davies: >>> >>> On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies   wrote: > > Have yo

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies
On 06/02/12 14:34, Reindl Harald wrote: Am 06.02.2012 15:28, schrieb Chris Tate-Davies: On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies wrote: Have you tried: mysql --verbose -u -p To output more information When would I use that? If I try to

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 7:34 AM, Reindl Harald wrote: > > > Am 06.02.2012 15:28, schrieb Chris Tate-Davies: >> On 06/02/12 13:33, Larry Martell wrote: >>> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >>>  wrote: Have you tried: mysql --verbose -u  -p To output more in

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 7:28 AM, Chris Tate-Davies wrote: > On 06/02/12 13:33, Larry Martell wrote: >> >> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >>  wrote: >>> >>> Have you tried: >>> >>> mysql --verbose -u  -p >>> >>> To output more information >> >> When would I use that? If I try to

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Reindl Harald
Am 06.02.2012 15:28, schrieb Chris Tate-Davies: > On 06/02/12 13:33, Larry Martell wrote: >> On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies >> wrote: >>> Have you tried: >>> >>> mysql --verbose -u -p >>> >>> To output more information >> When would I use that? If I try to start it with 'ser

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies
On 06/02/12 13:33, Larry Martell wrote: On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies wrote: Have you tried: mysql --verbose -u -p To output more information When would I use that? If I try to start it with 'service mysqld start' it fails to start. From terminal command... just try

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Larry Martell
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies wrote: > Have you tried: > > mysql --verbose -u -p > > To output more information When would I use that? If I try to start it with 'service mysqld start' it fails to start. > > On 05/02/12 00:57, Larry Martell wrote: >> >> Just installed mysql

Re: mysql won't start with service, but starts with mysqld_safe

2012-02-06 Thread Chris Tate-Davies
Have you tried: mysql --verbose -u -p To output more information On 05/02/12 00:57, Larry Martell wrote: Just installed mysql on centos 6.2. When I try to start it with service I get: #service mysqld start MySQL Daemon failed to start. Starting mysqld: