Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Rights to create files in the datadir?!

forums › forums › SQLyog › Using SQLyog › Rights to create files in the datadir?!

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • March 3, 2003 at 9:31 am #7732
      Neshi
      Member

      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 #13839
      CalEvans
      Member

      If you are using a Linux server type

      Code:
      ls -ld /the/directory/name

      this 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 #13840
      Neshi
      Member

      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 #13841
      Neshi
      Member

      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 #13842
      CalEvans
      Member

      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 #13843
      Neshi
      Member

      MySQL Control Center???

      Do you mean the Winmysqladmin?

    • March 3, 2003 at 3:37 pm #13844
      CalEvans
      Member

      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 #13845
      Neshi
      Member

      Well, everything right in there!

  • Author
    Posts
Viewing 7 reply threads
  • You must be logged in to reply to this topic.