Re: Relational query question

It better to LEFT join rather then NOT IN On Wed, Sep 30, 2015 at 6:00 PM, Mogens Melander wrote: > Maybe not the most optimal, but (probably) the most simple: > > SELECT * FROM fruit > where id not in (select fruit from purchase > where customer=1); > > 1, 'Apples' > 3, 'Oranges' > > > On 20

RE: installation problem of MySQL on OS Lion

Share error log file -Original Message- From: "Martin Mueller" Sent: ‎29-‎07-‎2015 21:05 To: "mysql@lists.mysql.com" Subject: installation problem of MySQL on OS Lion I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generate

Re: INTO OUTFILE ERROR...

Check permission of user 'teal1dwd_teal' DK Sent from Phone > On 19-Sep-2014, at 8:13 pm, Don Wieland wrote: > > Hi gang, > > Trying to generate a CSV file using mySQL and I keep getting this error > below. The target folder has full permissions to write (777). I am not > certain why this i

Re: 1045 Error accessing mysql db

check weather there any space in localhost 'localhost ' Also check permission for 'foo' user though command select * from mysql.user where 'foo'; On Thu, Aug 21, 2014 at 6:53 AM, Augori wrote: > After an operating system change (CentOS 5 to CentOS 6), my Python script > could no longer conn

Re: error 29, file not found (errcode: 13)

Sol :- Change file owner to mysql.mysql OR Change folder and file mode to 777 DK Sent from Phone > On 23-Jun-2014, at 8:22 pm, thufir wrote: > > Apparently this error is because MySQL can't read my home directory? Fair > enough, but I don't quite follow. Where would

Re: access problem for a particular table

Hi Run mysql_upgrade command at OS shell DK Sent from Phone > On 28-May-2014, at 1:40 pm, "Lentes, Bernd" > wrote: > > Hi, > > we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't > access one particular table. > Automysqlback 3.0 says: mysqldump: Got error: 1142: SE

Re: mysql Access denied error

Edward , use following way mysql -uroot -p -h{host ip } else give grant privileges to localhost On Mon, May 5, 2014 at 7:47 AM, EdwardKing wrote: > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,but it > fa

Re: database perfomance worries

Andy , increase innodb_log_file size to 400mb DK Sent from Phone On 03-Jul-2013, at 23:39, Rick James wrote: > Set innodb_buffer_pool_size to 70% of _available_ ram. That may be 11G on > your 16GB machine, unless you have a lot of other bulky stuff there. Do > _not_ make it so large that i

Re: space gone after MyISAM REPAIR TABLE

You can use "disable Key" before loading data & use "enable Key " after loading Command :- alter table {table. Name } disable key; Same enabling DK Sent from Phone On 27-Jun-2013, at 4:57, nixofortune wrote: > This is my table: > CREATE TABLE `ga_monthly_keyword_visits` ( > `site_id` int(1

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

Hi all Is there any better way for grade MySQL version without taking backup with mysqldump Or if there any tool for this R's DK On 16-Feb-2013, at 16:07, Reindl Harald wrote: > > > Am 16.02.2013 09:42, schrieb Manuel Arostegui: >> 2013/2/15 Reindl Harald >

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

w without > any dump and here are around 5000 tables > > Am 19.02.2013 22:12, schrieb Divesh Kamra: >> Is there any better way for grade MySQL version without taking backup with >> mysqldump >> >> Or if there any tool for this >> >> R's >&g

Re: MySQL Replication Error

Hi first check this thought application end or There is another way slave-skip-errors=1062 ---> in my.cnf and restart mysql On Sat, Dec 1, 2012 at 4:30 AM, Reindl Harald wrote: > > > Am 30.11.2012 23:52, schrieb Rick James: > > Possible causes: > > * Someone is writing to the Slave >

Re: replication problem

HI share detail Slave_IO_Running: Yes/No Slave_SQL_Running: Yes/No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: On Tue, Dec 4, 2012 at 5:59 AM, Rick James wrote: > SHOW SLAVE STATUS\G > SHOW MASTER STATUS; > What directory are the bi

Re: Basic SELECT help

Hi Is there is performance issue from this query on more then 5-10 million data On Fri, Nov 23, 2012 at 11:17 AM, Mogens Melander wrote: > Ok, to make up for my bad joke, here's the answer > to the original question. > > DROP TABLE IF EXISTS `test`.`atest`; > CREATE TABLE `test`.`atest` ( >

Re: Assistance with replication

Hi Machiel use following steps 1) make binary log into readable format through mysqlbinlog mysqlbinlog -u{user} -p{password} > log.log(this any text file) 2) read text file check next position just after position where replication is stuck 3) run the *change master* command on