Hello.
Maybe some directory doesn't exist in the path where MySQL stores
temporary files. See:
http://dev.mysql.com/doc/mysql/en/temporary-files.html
Martijn van den Burg wrote:
> Hi list,
>
> After the most recent reboot (which we used to increase the
> ulimit/open_files_limit on our Solaris 8 machine running 4.1.10-log),
> the following message has started to appear in the errorlog:
>
>
> InnoDB: Error: unable to create temporary file; errno: 2
>
>
> I have searched google and the lists for this error, but couldn't find
> anything substantial, other then that it might have to do with the
> setting of tmpdir (which is unset). Any ideas?
>
>
> Regards,
>
> Martijn
>
>
> -- =0D
> The information contained in this communication and any attachments is co=
> nfidential and may be privileged, and is for the sole use of the intended=
> recipient(s). Any unauthorized review, use, disclosure or distribution i=
> s prohibited. If you are not the intended recipient, please notify the se=
> nder immediately by replying to this message and destroy all copies of th=
> is message and any attachments. ASML is neither liable for the proper and=
> complete transmission of the information contained in this communication=
> , nor for any delay in its receipt.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com