ERROR 1006: Can"t create database "X". (errno: 13)

Hello

I am having difficulties:
I am working on Mac OSX 10.2.8 with mysql 4.
I needed to change the data directory of MySQL from
its original
place (where the application have to be and not the
databases because
there is not enought room) to an other volume of my
computer.
I made a symlink from data to data in the other volume
and not anymore
as it was to var in the same volume before. I copied
all files and
directories of var in this new directory -data-. I
changed with mysql
mysql all this file and directories (group and owner).
And I made :
create database X;
ERROR 1006: Can't create database 'X'. (errno: 13)

I hope what I explain is clear!

What did I forget ?
Do I have to put also var in this new other directory?
Do I have to reinstall completly MySQL because I
corrupted to much
this application?

I am lost.

Could anyone help me?

Thanks in advance

LN

____________________________________________________________ _____
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 1006: Can"t create database "X". (errno: 13)

N L writes:
> Hello
>
> I am having difficulties:
> I am working on Mac OSX 10.2.8 with mysql 4.
> I needed to change the data directory of MySQL from
> its original
> place (where the application have to be and not the
> databases because
> there is not enought room) to an other volume of my
> computer.
> I made a symlink from data to data in the other volume
> and not anymore
> as it was to var in the same volume before. I copied
> all files and
> directories of var in this new directory -data-. I
> changed with mysql
> mysql all this file and directories (group and owner).
> And I made :
> create database X;
> ERROR 1006: Can't create database 'X'. (errno: 13)
>
> I hope what I explain is clear!
>
> What did I forget ?
> Do I have to put also var in this new other directory?
> Do I have to reinstall completly MySQL because I
> corrupted to much
> this application?
>
> I am lost.
>
> Could anyone help me?
>
> Thanks in advance
>
> LN

Hi!

This list is dedicated to the fully repeatable test cases.

The above description is definitely not the fully repeatable bug
report.

It fails into installation / configuration problems.

For issues like above, write to mysql@lists.mysql.com.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: ERROR 1006: Can"t create database "X". (errno: 13)

Hi!

On Dec 11, N L wrote:
> Hello
>
> I am having difficulties:
> I am working on Mac OSX 10.2.8 with mysql 4.
> I needed to change the data directory of MySQL from
> its original
> place (where the application have to be and not the
> databases because
> there is not enought room) to an other volume of my
> computer.
> I made a symlink from data to data in the other volume
> and not anymore
> as it was to var in the same volume before. I copied
> all files and
> directories of var in this new directory -data-. I
> changed with mysql
> mysql all this file and directories (group and owner).
> And I made :
> create database X;
> ERROR 1006: Can't create database 'X'. (errno: 13)
>
> I hope what I explain is clear!

There is utility program that comes with MySQL - perror.

Trying "perror 13" you'll get:

Error code 13: Permission denied

check permissions of the datadir.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org