Re: error 13

2012-10-16 Thread Lixun Peng
Hi, What's the dir permissions? For example, if we have a file in /a/b/file, dir a is 644, even though file is 777, we can't access file, too. On Wed, Oct 17, 2012 at 10:31 AM, kalin ka...@el.net wrote: hi all.. this hasn't happened before... i'm in as root on the command line cleint.

Re: Error message I am getting today. All help appreciated.

2012-10-16 Thread Lixun Peng
Hi, What query is running? Is web server and DB server in the same server? Have something in error.log of MySQL? On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com ad...@canadianinvestors.com wrote: Hi, I run www.canadianinvestors.com and am getting this error message. Warning:

Re: error 13

2012-10-16 Thread Lixun Peng
? if not, google the docs for 'local infile' yes. my laptop. On 2012-10-16 10:45 PM, Lixun Peng pengli...@gmail.com wrote: Hi, What's the dir permissions? For example, if we have a file in /a/b/file, dir a is 644, even though file is 777, we can't access file, too. On Wed, Oct 17

Re: Can I measure the use of index?

2012-10-15 Thread Lixun Peng
Hi, If you are using Percona Server, you can use this query: SELECT DISTINCT s.table_schema, s.table_name, s.index_name FROM information_schema.statistics `s` LEFT JOIN information_schema.index_statistics indxs ON ( s.table_schema =