WordPress.org

Forums

[resolved] Can't create/write to file './my_DB/wp_categories.frm' (Errcode: 13) (9 posts)

  1. gbeck
    Member
    Posted 8 years ago #

    Hello:

    BACKGROUND:

    I'm moving to a new server. I'm attempting to insert my wordpress blog DB into an empty DB using this command

    mysql -u my_username -p my_DB < my_DB-2006-10-12.sql

    When I attempt this happens

    ERROR 1 (HY000) at line 23: Can't create/write to file './my_DB/wp_categories.frm' (Errcode: 13)

    SPECS:
    platform: linux
    preview version of mysql: 5.1
    new version (migrating to new server): 4.1

  2. whooami
    Member
    Posted 8 years ago #

    thats something ONLY your host can address. you MUST contact them.

  3. gbeck
    Member
    Posted 8 years ago #

    Hello:

    I am the host. I have root.

  4. whooami
    Member
    Posted 8 years ago #

    oke then.. check the permissions on your mysql data directories.
    mysql uses plain old text files to store data -- it needs writable permissions for whatever user its running as.

    http://forums.mysql.com/read.php?20,78674,78791#msg-78791

  5. gbeck
    Member
    Posted 8 years ago #

    Hello:

    Thanks.

    Yes, I must be missing some directory, somewhere?

    The directory I specified in my.cnf is /tmp and is shows up in mysql as /tmp.

    There must be some other directory, somewhere that it is also trying to write to.

  6. gbeck
    Member
    Posted 8 years ago #

    Hello:

    I read your link

    http://forums.mysql.com/read.php?20,78674,78791#msg-78791

    I wonder where the setting are that I could read that would tell me exactly where and what directories are my mysql data directories?

  7. Kafkaesqui

    Posted 8 years ago #

    I believe questions on setting up MySQL server would best be asked (and answered) in the MySQL forums.

  8. gbeck
    Member
    Posted 8 years ago #

    Just for anyone else reading this....

    I had to open the permission in the my_DB directory in

    /var/lib/mysql/my_DB/

    and it worked.

    Thanks.

  9. whooami
    Member
    Posted 8 years ago #

    youre welcome, glad you found the directory

Topic Closed

This topic has been closed to new replies.

About this Topic