Posted 5 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
thats something ONLY your host can address. you MUST contact them.
Posted 5 years ago #
Hello:
I am the host. I have root.
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.
Posted 5 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.
Posted 5 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?
Posted 5 years ago #
I believe questions on setting up MySQL server would best be asked (and answered) in the MySQL forums.
Posted 5 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.
youre welcome, glad you found the directory
This topic has been closed to new replies.
