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' >

Re: INTO OUTFILE ERROR...

Check permission of user 'teal1dwd_teal' DK Sent from Phone On 19-Sep-2014, at 8:13 pm, Don Wieland d...@pointmade.net 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

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 aug...@gmail.com wrote: After an operating system change (CentOS 5 to CentOS 6), my Python script could

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 hawat.thu...@gmail.com wrote: Apparently this error is because MySQL can't read my home directory? Fair enough, but I don't quite

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 bernd.len...@helmholtz-muenchen.de 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:

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 zhan...@neusoft.com 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

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 rja...@yahoo-inc.com 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

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 nixofort...@gmail.com wrote: This is my table: CREATE TABLE `ga_monthly_keyword_visits` (

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

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 DK On 16-Feb-2013, at 16:07, Reindl Harald h.rei...@thelounge.net wrote: Am 16.02.2013

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 h.rei...@thelounge.net wrote: Am 16.02.2013 09:42, schrieb Manuel Arostegui: 2013/2/15 Reindl Harald

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 rja...@yahoo-inc.com wrote: SHOW SLAVE STATUS\G SHOW MASTER STATUS; What

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 h.rei...@thelounge.netwrote: Am 30.11.2012 23:52, schrieb Rick James: Possible causes: * Someone is writing

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 mog...@fumlersoft.dkwrote: Ok, to make up for my bad joke, here's the answer to the original question. DROP TABLE IF EXISTS `test`.`atest`; CREATE TABLE

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