Re: Can't read dir of '.' (errno: 13)

2011-01-18 Thread Pintér Tibor
> mysql> show databases ; > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > mysql> show databases; > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > mysql> $ perror 13 OS error code 13: Permission denied t -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: optimizing query

2011-01-18 Thread Steve Meyers
On 1/18/11 10:22 AM, Simon Wilkinson wrote: SELECT articles.* FROM articles INNER JOIN newsletters ON articles.newsletter_id = newsletters.id INNER JOIN users ON users.id = newsletters.user_id WHERE users.id =12 AND MONTH(articles.created_at) = '12' AND DAY(articles.created_at) = '5' ORDER BY YEA

Re: Can't read dir of '.' (errno: 13)

2011-01-18 Thread Adarsh Sharma
Hi , After some research I want a useful link that describes my problem. Here is the link : http://bugs.mysql.com/bug.php?id=15851 I don't think that this is a permission problem as I cross-check it. But I am not able to remove it. Thanks & Regards Adarsh Sharma Adarsh Sharma wrote:

Query is not using Index

2011-01-18 Thread Yogesh Kore
Hi, I am firing following query SELECT 'Sales' as transaction_type, CONCAT('$', SUM(CASE DATE(px_orders.sales_orders.order_completed_date) WHEN CURDATE() THEN px_orders.sales_order_products.paid_amount ELSE 0 END)) AS today, CONCAT('$', SUM(CASE WEEK(px_orders.sales_orders.order_c

AES_DECRYPT - Returens Blob[empty]

2011-01-18 Thread Vikram A
Hi, MySQL (version 5.1.45 , windows based) AES_DECRYPT () function is not working properly, If I removed Order by clause from the following query it works Fine. If I add order by it resulting blob[empty] value. >> select S.semyear as semester, S.part as part, S.code as code, S.subject as

Can't read dir of '.' (errno: 13)

2011-01-18 Thread Adarsh Sharma
Dear all, I am facing the issue mentioned below while issuing show databases command. root@s7-dt-bse:~# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.1.41-3ubuntu12.8 (Ubuntu) Type 'help;' or '\h' for h

Re: optimizing query

2011-01-18 Thread Mihail Manolov
I concur. In addition to suggested index I would add a new column in articles table called body_length, which is going to be updated every time the body column is updated. Add that column to the composite index mentioned below. This should speed up the query a lot. Cheers, Mihail On Jan 18, 20

Re: Large table

2011-01-18 Thread Michael Dykman
The VIEW is pretty much forced to behave this way.. it's really just a run-time SELECT which is amended with your additional query parameters.. what you want is a MERGE table http://dev.mysql.com/doc/refman/5.1/en/merge-storage-engine.html This allow your collection of identically structured My

Re: optimizing query

2011-01-18 Thread Michael Dykman
Hi Simon, once you apply functions to a field, an index on that field is pretty much useless. For this particular query, I would be tempted to create additional fields to store the values of MONTH(articles.created_at) and DAY(articles.created_at). Create an index on (month_created, day_created)

Re: Large table

2011-01-18 Thread Sairam Krishnamurthy
All, I have another problem with the partition. Once I create a partition, the first table contains 700 million rows and I started adding new values to the second table. And I have a View with the following definition: CREATE VIEW view_name AS SELECT * FROM table_1 UNION SELECT * from table_2; N

optimizing query

2011-01-18 Thread Simon Wilkinson
Hi, I am trying to optimize the following query: SELECT articles.* FROM articles INNER JOIN newsletters ON articles.newsletter_id = newsletters.id INNER JOIN users ON users.id = newsletters.user_id WHERE users.id =12 AND MONTH(articles.created_at) = '12' AND DAY(articles.created_at) = '5' ORDER B

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

2011-01-18 Thread Johan De Meersman
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla wrote: > Make sure the following things: > > > - /tmp folder is having 1777 permissions > - mysql folder is having the ownership from which it is running. Refer > /etc/my.cnf > - Make sure you have space on your MySQL partition > Also, make

Re: mysqldump except one table

2011-01-18 Thread jayabharath
you can use "--ignore-table" option for this, mysqldump -u -p dbname --ignore-table=dbname.tablename > xyz.sql you can use this option multiple times to ignore multiple tables. Rgds, Jay On Tue, Jan 18, 2011 at 6:18 PM, Adarsh Sharma wrote: > Dear all, > > > I am researching about diffe

Re: mysqldump except one table

2011-01-18 Thread a . smith
Check the manual? Its here under ignore-table http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Quoting Adarsh Sharma : Dear all, I am researching about different parameters provided by the *mysqldump* utility. It provides a method to dump databases with all tables. My problem is I w

mysqldump except one table

2011-01-18 Thread Adarsh Sharma
Dear all, I am researching about different parameters provided by the *mysqldump* utility. It provides a method to dump databases with all tables. My problem is I want to dump a database having 30 tables except one table i.e i have to dump only 29 tables. Is this possible ? Please guide m