innodb gives error 2

Help
william
2007-02-20
2013-05-29
  • william
    william
    2007-02-20

    if i use automysqlbackup.sh.2.5 i get following messages in the mysql <hostname>.err file.

    070220 15:41:18  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:41:19  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:42:24  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:42:24  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:43:23  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:43:23  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:44:04  InnoDB: Error: unable to create temporary file; errno: 2
    070220 15:44:04  InnoDB: Error: unable to create temporary file; errno: 2

    i have a mysql database with 434 tables  and four of them are innodb tables.

    # df -k
    Filesystem            kbytes    used   avail capacity  Mounted on
    /dev/dsk/c0t0d0s0    6050182 4840327 1149354    81%    /
    /proc                      0       0       0     0%    /proc
    mnttab                     0       0       0     0%    /etc/mnttab
    swap                  671008     104  670904     1%    /var/run
    swap                  670920      16  670904     1%    /tmp

    the database itself is 513Meg.

    system is a sun solaris 5.9 sparc