No announcement yet.

mysql repair table Error "Can not create new tempfile"

  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql repair table Error "Can not create new tempfile"


    when trying to repair a corrupt table in my database I get an error that says: Can not create new tempfile: '. / newuse 5_hagale/post.TMD' |

    this only happens with this table, the other tables are allowed to repair without any problem,

    I appreciate your help.

  • #2
    This can be caused for a couple reasons:
    1. The file already exists.
    2. You dont have the needed disk space.
    3. You dont have permission to the tmp space.

    Did you verify that the file doesnt exist?

    You can also change your tmp location using --tmpdir in my.cnf & then restart MySQL
    Gentoo Geek


    • #3
      If you're on a shared host, you need to contact your hosting provider to handle the above.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API


      • #4

        hi, my server is dedicated.

        not seem to be a problem for little disk space:

        Filesystem Size Used Avail Use% Mounted on
        / dev/sda2 224G 118G 95G 45% /
        tmpfs 3.9G 0 3.9G 0% / dev / shm
        / dev/sda1 97M 50M 43M 54% / boot
        / dev/sda4 2.0G 42M 1.9G 3% / tmp

        You dont have permission to the tmp space.*

        How do you give permission for this?, With chmod 777 on the folder?


        • #5
          Edit my.cnf, depending on OS, it should be in /etc

          Add this line under the mysqld section & restart MySQL, then try your repair.

          tmpdir = /
          Gentoo Geek


          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.