Hi! Well recently on one of my Servers (Dedicated), an SQL Problem has occured. Somehow some tables such as phpbb_posts (phpBB Forum) cannot create temp files after I cleared out /tmp (it was full at 485 MB). Now the new /tmp is at 985 M..so no path has changed, but when I try repairing phpbb_posts, phpMyAdmin returns an error saying Can't create new tempfile: './Database Name/phpbb_posts.TMD' Anyone who can help? Thanks in advance EDIT: Paying someone to do it!!
here Filesystem Size Used Avail Use% Mounted on /dev/sda1 457G 84G 351G 20% / /dev/sdb1 459G 129M 436G 1% /disk2 tmpfs 1013M 0 1013M 0% /dev/shm /usr/tmpDSK 985M 76M 859M 9% /tmp /tmp 985M 76M 859M 9% /var/tmp the one being used atm i think is /usr/tmpDSK even though /tmp shows the same stats
More than likely /tmp is symlinked to /var/tmp so they both contain the same content. The reason you are getting the error is that your /tmp partition is full. There is only 9% or 76Mb available. Seems the tempfile phpbb_posts.TMD is larger than 76Mb, consequently there is not enough room on the partition to create the file. Unfortunately there are only two ways to correct this. 1. Shrink one of your other partitions and then grow this partition using the newly freed space. 2. Reload the operating system and create a new partition scheme during the reload with sufficient space for /tmp. If you are not familiar with parted or filesystems in general I would recommend that you hire an admin should you choose to perform step 1.
hi no youve got that wrong..i also checked in cpanel..and it shows up as total size: 985 M; Used is 85M, Available is 851M and it shows to have used 10%
My bad, you are correct you have plenty of space. Next you would need to review the logs to see if you can better determine why phpmyadmin cannot create the file.