Error 13 Hy000 At Line
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have error 13 hy000 at line 1 can t get stat of Meta Discuss the workings and policies of this site About Us
Error 1114 Hy000 At Line The Table Is Full
Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us mysql error 13 hy000 can t get stat of Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their
Error 13 Hy000 Can T Get Stat Of Errcode 13
database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL import csv file ERROR 13 (HY000): Can't get stat of /path/file.csv (Errcode: 2) up vote error 13 hy000 can t get stat of errcode 2 6 down vote favorite 6 I am an absolute beginner to MySQL (5.5.34) / Linux (Ubuntu 12.04 LTS)` I have created a simple database with one table. When trying to import data into it via a 'data_test.csv file an error message 13 appears. Exert from Terminal follows: mysql> source /home/g/stockrecdb/load_test.sql; Database changed ERROR 13 (HY000): Can't get stat of '/home/stockrecdb/data_test.csv' (Errcode: 2) mysql> Note: if using LOCAL in LOAD DATA LOCAL INFILE an error appears: ERROR 1148 (42000): The used command is not allowed with this MySQL version mysql errors csv-file share|improve this question edited Jan 2 '14 at 5:50 asked Jan 2 '14 at 5:17 Guillermo 33114 add a comment| 2 Answers 2 active oldest votes up vote 14 down vote accepted I hope you are using LOAD DATA INFILE. Try to use LOAD DATA LOCAL INFILE instead of LOAD DATA INFILE. Other issue might be this, please visit the following links : MySQL LOAD DATA. When you login in MySQL do like below, abdul@xmpp3:~/Desktop/Jiva$ mysql -uroot -p --local-infile
Donovan Hsieh Email Updates: Status: Can't repeat Impact on me: None Category:MySQL Server: General Severity:S2 (Serious) Version:5.1.22-0 OS:Linux (Redhat EL4) Assigned to: View Add Comment Files Developer Edit Submission View Progress Log
Mysql Error Code 13 Permission Denied
Contributions [17 Oct 2007 17:06] Donovan Hsieh Description: -bash-3.00$ ll /tmp/test.txt -rwxrwxrwx 1 mysql
Error Code: 1148. The Used Command Is Not Allowed With This Mysql Version
mysql 10180 Oct 17 09:37 /tmp/test.txt -bash-3.00$ mysql dars -uroot Reading table information for completion of table and column names You error 1148 (42000): the used command is not allowed with this mysql version can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.1.22-rc-community MySQL Community Edition http://dba.stackexchange.com/questions/55960/mysql-import-csv-file-error-13-hy000-cant-get-stat-of-path-file-csv-errcod (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> load data infile '/tmp/test.txt' into table core_dars fields terminated by ','; ERROR 13 (HY000): Can't get stat of '/tmp/test.txt' (Errcode: 13) How to repeat: -bash-3.00$ ll /tmp/test.txt -rwxrwxrwx 1 mysql mysql 10180 Oct 17 09:37 /tmp/test.txt -bash-3.00$ mysql dars -uroot Reading table information for completion of table and column names You can turn off this https://bugs.mysql.com/bug.php?id=31670 feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.1.22-rc-community MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> load data infile '/tmp/test.txt' into table core_dars fields terminated by ','; ERROR 13 (HY000): Can't get stat of '/tmp/test.txt' (Errcode: 13) [17 Oct 2007 17:49] Miguel Solorzano Thank you for the bug report. That sounds as permission issue: [miguel@skybr 5.1]$ bin/perror 13 OS error code 13: Permission denied Please see: http://dev.mysql.com/doc/refman/5.1/en/load-data.html "For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege. See Section 5.7.3, “Privileges Provided by MySQL”." [17 Oct 2007 19:17] Donovan Hsieh As you can see from the screen capture text, the input file '/tmp/dars.txt' has rwxrwxrwx and it is located in /tmp directory. Also, I login as root from console shell and it has "GRANT FILE ON *.* TO `root`@`localhost`" privilege. I still think it is a BUG. [18 Oct 2007 8:17] Sveta Smirnova Thank you for the fe
on me: None Category:MySQL Server: InnoDB storage engine https://bugs.mysql.com/bug.php?id=80538 Severity:S3 (Non-critical) Version:5.7.11 OS:CentOS Assigned to: View Add Comment Files Developer Edit Submission View Progress Log Contributions [26 Feb 23:21] J Scavok Description: I was attempting to use LOAD DATA INFILE (without LOCAL) to populate three separate InnoDB tables. All three tab-separated-values files were located in error 13 the same directory (/var/lib/mysql-files). Two were successful, while the third failed: 1) OKAY: 5,638,286 rows/ 262,764,135 bytes 2) OKAY: 3,739,764 rows/ 102,659,743 bytes 3) FAIL: 5,638,286 rows/4,369,760,837 bytes; Error 13 (HY000): Can't get stat of '/var/lib/mysql-files/patent.tsv' (Errcode: 13 - Permisssion denied) Yet when I manually invoked error 13 hy000 `stat' it returned this: [root@localhost mysql]# stat '/var/lib/mysql-files/patent.tsv' File: `/var/lib/mysql-files/patent.tsv' Size: 4369760837 Blocks: 8534704 IO Block: 4096 regular file Device: fd00h/64768d Inode: 1577079 Links: 1 Access: (0644/-rw-r--r--) Uid: ( 0/ root) Gid: ( 0/ root) Access: 2015-10-13 07:23:17.000000000 -0700 Modify: 2015-10-13 07:27:36.000000000 -0700 Change: 2016-02-25 15:56:00.360040034 -0800 I'm wondering if it has to do with the large file size of 4.1 GB (4,369,760,837 bytes)? The other two (relatively) large files (5,638,286 rows/262,764,135 bytes and 3,739,764 rows/102,659,743 bytes) were successfully processed by LOAD DATA INFILE. N.B.: I did not use LOCAL with the LOAD DATA INFILE statements. Specifics: OS: CentOS release 6.6 (Final) MySQL: +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 5.7.11 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1 | | version | 5.7.11 | | versi