forums › forums › SQLyog › Using SQLyog › Rights to create files in the datadir?!
- This topic is empty.
-
AuthorPosts
-
-
March 3, 2003 at 9:31 am #7732NeshiMember
Hello!
I have a problem with the my.ini setup options for using the innodb tables.
I found that in the innodb manual:
“Check that the MySQL server has the rights to create files in datadir”
Where can I check if the Server has those rights?!
Thank you!!!
-
March 3, 2003 at 1:03 pm #13839CalEvansMember
If you are using a Linux server type
Code:ls -ld /the/directory/namethis will result in something like this:
Code:newton backups # ls -ld /home/backups/
drwxr-xr-x 30 backup users 4096 Mar 1 13:42 /home/backups/the letters at the front of the second line tell you your permissions.
d= directory
1st rwx = user permissions. The user backup in this case has permission to read/write and execute (since this is a dir the x means that you have permission to look into the dir)
2nd rwx = group permissions. the group users has permission to read and look into the dir.
3rd rwx = everyone else. Everyone else has permission to read and look into the dir.
If you are using this one a windows box, right click on the dir and go to permissions.
HTH,
=C=
-
March 3, 2003 at 1:10 pm #13840NeshiMember
okay, thank you so much for your reply!
I am using windows!
What kind of information should i get from the permission box?
-
March 3, 2003 at 1:16 pm #13841NeshiMember
more information: it seems as if its working sometimes! i found an iblogfile in my datadir (well, it shouldn't be there as I created a directory for the iblogs).
But the my.ini is not working with the values and options I found in the manual…
-
March 3, 2003 at 1:46 pm #13842CalEvansMember
ok, that's a different issue.
Since you are using the windows server, check the MySQL control center to see what settings MySQL thinks it's using. If they are different from your my.ini settings than I'm betting that your my.ini is in the wrong place.
=C=
-
March 3, 2003 at 1:50 pm #13843NeshiMember
MySQL Control Center???
Do you mean the Winmysqladmin?
-
March 3, 2003 at 3:37 pm #13844CalEvansMember
sounds right. I only have 1 windows machine running mysql and I don't use it much. (Actually it's my laptop and it's usually booted into Linux, not windows) but if I remember correctly, it's the little stop-light icon in the system tray. I believe it will show you your my.ini. Make sure it's got the right one. The one with your changes in it.
=C=
-
March 5, 2003 at 1:33 pm #13845NeshiMember
Well, everything right in there!
-
-
AuthorPosts
- You must be logged in to reply to this topic.