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
