On 9/10/2012 9:55 AM, Garot Conklin wrote:
Not to beat the perms to death but /tmp should have the sticky bit set as well... so 1777 not just 0777. Perhaps hard kill any lingering mysql PIDS unless this is production and u expect other DB's to be running... if u have duplicated this DB schema somewhow by mistake and a second or first identical instance is running it is plausable to assume that the other running instance has locked the file it is using preventing it from being written to.
Excellent point! Yes, you can have multiple MySQL instances running on the same host machine but they cannot share the same --tmpdir location. Name collisions can and do occur between them if they attempt to share a common folder. Verify that you have properly isolated each instance from every other by following these guidelines:
http://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
