Got Error 140 From Storage Engine Mysql
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 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join 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 symbolic Link Failed up vote 0 down vote favorite I have three database files, which is: criminal.frm, criminal.MYD and criminal.MYI. They are physically store on an external drive which is mounted on mount point: /mnt/mysql/ I tried to create three symlink to those three files individually and put those links into a existing database directory: /var/lib/mysql/existed/. When I try SELECT * FROM criminal; it shows the error ERROR 1030 (HY000): Got error 140 from storage engine Then I tried SHOW TABLES; the criminal table does exist(probably because the frm file is there) Later, I tried to create a empty database CRIM and manually put three symlinks (frm, MYI and MYD)in the /var/lib/mysql/CRIM directory. Again, it showed the same error: ERROR 1030 (HY000): Got error 140 from storage engine I googled on those problems and they are mostly associated with file/directory permissions. So I changed the ownership of original database files on external drive, the ownership of directory that contains them on external drive, and the ownership of symbolic links. All of them are mysql:mysql now. I also changed the default storage engine from InnoDB to MyISAM. Still getting the error message. Guys help me. Any advise would be much appreciated. Thanks!! mysql permissions symlink share|improve this question asked Aug 14 '14 at 22:41 mingweili0x 11 Have you tried defining the table with a DATA DIRECTORY instead? At it's MyISAM that should work AFAIK. Symbolic links won't work. hard links would but would require being on the same device. But generally, don't assume moving files around will work for MySQL without extra effort. –Wrikken Aug 14 '14 at 22:57 @Wrikken, symlinks are fully supported at the database directory level or the datadir level in MySQL. Symlinking at the file level may be an issue, though. –Michael - sqlbot Aug 15 '14 at 2:45 @Michael-sqlbot: Well: "In the data directory, you always have the table format (.frm) file,
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 About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign http://stackoverflow.com/questions/25318703/mysql-symbolic-link-failed 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 Why are symbolic links not working in MySQL? up vote 0 down vote favorite I'm having an issue, I searched a lot but I'm not sure if it's related to a previous security patch. On http://serverfault.com/questions/176207/why-are-symbolic-links-not-working-in-mysql the last version of MySQL on Debian Lenny ( 5.0.51a-24 ) I need to share one table between two db, those two db are in the same path ( /var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to the table in db1. When I query the same table from db2 I get this : 'ERROR 1030 (HY000): Got error 140 from storage engine' This is how it looks : test-lan:/var/lib/mysql/test3# ls -alh drwx------ 2 mysql mysql 4.0K 2010-08-30 13:28 . drwxr-xr-x 6 mysql mysql 4.0K 2010-08-30 13:29 .. lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.frm -> /var/lib/mysql/test/blbl.frm lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYD -> /var/lib/mysql/test/blbl.MYD lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYI -> /var/lib/mysql/test/blbl.MYI -rw-rw---- 1 mysql mysql 65 2010-08-30 13:24 db.opt I really need those symlinks, is there a way to make them working like before ? ( old MySQL-server is fine ) mysql debian symbolic-link share|improve this question edited Dec 4 '12 at 5:23 John Gardeniers 23.5k83997 asked Aug 30 '10 at 19:26 Eno 1794 ad
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 About http://dba.stackexchange.com/questions/10108/can-i-specify-a-different-disk-for-a-specific-mysql-table Us Learn more about Stack Overflow the company Business Learn more about hiring http://forums.devshed.com/mysql-help-4/error-130-storage-engine-690421.html 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 Here's got error how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Can I specify a different disk for a specific MySQL table? up vote 3 down vote favorite 1 I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its got error 140 data. It also has a secondary hard drive that is larger and not an SSD. I am about to create a table that I fear might be too large to fit on my SSD; is it possible for me to instead store that one table on the larger (but slower) drive? If it matters, I'm generally using MyISAM tables but could be persuaded to use InnoDB if that would help. mysql windows disk-space disk-structures share|improve this question asked Jan 4 '12 at 0:07 Michael McGowan 3442718 add a comment| 3 Answers 3 active oldest votes up vote 3 down vote Migrating s single MyISAM table to another disk is only possible in Linux versions, not Windows, of MySQL with the DATA DIRECTORY and INDEX DIRECTORY clauses of ALTER TABLE on a MyISAM table. However, in Windows, you can manually move the .MYD and .MYI files to where you want. UPDATE 2012-01-03 22:03 EDT Interestinging, MySQL 5.5.15 on my Windows 7 machines says symlink support exists: mysql> show variables like 'have_sym%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_symlink | YES | +---------------+-------+ 1 row in set (0.09 sec) I also discovered that symlinking is possible in Windows: http://en.wikipedia.org/wiki/NTFS_symbol
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases MySQL Help Got error 130 from storage engine Thread: Got error 130 from storage engine Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread March 31st, 2010,06:42 AM #1 No Profile Picture chuza View Profile View Forum Posts Registered User Devshed Newbie (0 - 499 posts) Join Date Mar 2010 Posts 2 Rep Power 0 Got error 130 from storage engine Hi, I am on a cPanel server and I am getting this error while creating a db dump. root@server [/var/lib/mysql]# mysqldump juser_db > juser_db.sql mysqldump: Got error: 1030: Got error 130 from storage engine when using LOCK TABLES - I tried myisamchk -r *.MYI and it has not fixed this. - Plenty of diskspace available. - MySQL running fine. I even tried restarting the service but dump still doesnt work. I am not much of a MySQL expert, so I am not sure what else to do. I searched a similar error in the forum but that thread was also incomplete. Faq Reply With Quote April 1st, 2010,10:34 AM #2 No Profile Picture JClasen View Profile View Forum Posts Visit Homepage Contributing User Devshed Intermediate (1500 - 1999 posts) Join Date Jun 2007 Posts 1,515 Rep Power 1426 Error 130 from storage engine is probably an fs related error. Please check the actual error message with perror before continueing any further. Regards, Jens Faq Reply With Quote April 1st, 2010,02:10 PM #3 No Profile Picture chuza View Profile View Forum Posts Registered User Devshed Newbie (0 - 499 posts) Join Date Mar 2010 Posts 2 Rep Power 0 You mean, I