> 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
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
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:
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
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
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
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
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
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)
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
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
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
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
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
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
15 matches
Mail list logo