Error 1017 Hy000 Mysql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting error 1017 hy000 can t find file ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join error hy000 mysql odbc 5.1 driver access denied for user the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a
Error 2002 Hy000 Mysql
minute: Sign up MySQL, copying tables files gives rise to “ERROR 1017 (HY000): Can't find file:” even though its there there up vote 10 down vote favorite 6 I want to copy the database tables from my production server to
Error 2002 Hy000 Mysql Centos
a local test machine so I can perform test om (copies of) the real data. I stopped mysql and deleted all the frm, MYD and MYI files. Starting mysql here and querying show tables gives an empty result set. I then shut down mysql and copied all the frm, MYD and MYI files from the server. When starting mysql "show tables" shows the tables as expected but trying to query them I get the error message ERROR 1017 (HY000): Can't find file: error 2006 hy000 mysql './WhateverTableIQuery.frm' (errno: 13) But the WhateverTableIQuery.frm file is on the disc and is identical to the one on the server. Any ideas about what might be the problem? mysql share|improve this question edited Apr 12 '14 at 13:46 Benjamin 11.4k1692171 asked Aug 24 '12 at 9:33 user1622094 83115 I didn't dump and import because I wanted to save time. Some of the tables are big and building the indices takes forever. –user1622094 Aug 24 '12 at 12:03 add a comment| 6 Answers 6 active oldest votes up vote 25 down vote accepted I'd suggest giving two things a try: 1. Check Permissions Make sure that your MySQL data directory and all the files in it are owned by mysql user and mysql group. This may not be the case if you copied the files onto your local test machine as root user: chown -R mysql:mysql your-mysql-data-dir-here 2. Repair corrupted tables Use mysqlcheck to check for corrupted tables and repair them if it finds any: mysqlcheck -u root -p --auto-repair --all-databases If you still can't use the tables after that then give mysqldump a go! share|improve this answer answered Aug 24 '12 at 11:21 Tom Mac 6,74621524 As you guessed I copied the files as root and forgot to change the owner. Doing so fixed the problem. Thanks a lot! –user1622094 Aug 24 '12 at 11:53 add a comment| up vote 2 down vote I encountered the same issue after restori
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site
Error 1215 Hy000 Mysql
About Us Learn more about Stack Overflow the company Business Learn more about error 2013 hy000 mysql hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join error 2003 hy000 mysql windows the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL: ERROR 1017 (HY000): http://stackoverflow.com/questions/12106727/mysql-copying-tables-files-gives-rise-to-error-1017-hy000-cant-find-file Can't find file when creating table up vote 0 down vote favorite I searched for this error here but nothing really relates to my problem. I'm trying to debug a script, which starts with CREATE TABLE IF NOT EXISTS 'tablename' (...) However both in the script and in the MySQL client on console I get this error: ERROR 1017 (HY000): Can't find file: 'tablename' (errno: http://stackoverflow.com/questions/33940744/mysql-error-1017-hy000-cant-find-file-when-creating-table 2) The strange thing is: The database is completely empty. What I checked: -The mysql Server is running as user 'mysql', the directory with the mysql databases and the files belong to the same user and have enough rights (read/write/execute). -The user I use to log into the mysql client has the right to create tables. In the mysql client I can even drop the empty database and create it again, but I still can't create a table. EDIT: It somehow was a problem with the table name. I just added "Test" to end of the tablename, and then it worked, despite me dropping and creating the database several times. I assume that the table name was still somehow cached in mysql. The script ran on the same server before without problems, but as it was a temporary table, the table was deleted later. EDIT2: Admin restarted the DB, this solved the problem without any changes to the original command. mysql share|improve this question edited Nov 26 '15 at 15:35 asked Nov 26 '15 at 14:08 Fels 313310 1 stackoverflow.com/a/12108426/3181416 –Munjal Mayank Nov 26 '15 at 14:14 Thanks, but I ch
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site http://dba.stackexchange.com/questions/50820/issue-moving-database-between-servers-cannot-find-frm-file-even-though-its-th About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us 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 database skills and learn from others in the community. Join them; it only takes a minute: Sign up hy000 mysql Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Issue moving database between servers (cannot find .frm file even though it's there) up vote 2 down vote favorite I used MAMP on my local machine to make a little site with a mysql database. I moved all the site files over the error 1017 hy000 to server. Great. The name of my database is roster and it has one table called users. I copied the 'roster' folder which contains the following files: db.opt users.frm users.MYD users.MYI I put the 'roster' folder in the mysql directory. I run the following: No error. Awesome. But when I run the following: $query = "SELECT last_name, first_name, u_name, skype_id, primary_location FROM users"; $result = mysql_query($query)or die('query error'.mysql_error()); Then I receive the following error: query errorCan't find file: './roster/users.frm' (errno: 13) Furthermore, when I login to the server and login to mysql. I see the database and table: mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | phones_db | | roster | +--------------------+ 4 rows in set (0.00 sec) mysql> use roster; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +------------------+ | Tables_in_roster | +------------------+ | users | +------------------+ 1 row in set (0.00 sec) mysql> select * from users; ERROR 1017 (HY000): Can't find file: './roster/users.frm' (errno: