Welcome Guest ( Log In | Register )



 
Closed TopicStart new topic
> MySQL Errors? - Error 13!
Trekkie101
post Sep 3 2005, 03:24 PM
Post #1


Teh Teckeh Trekkeh
Group Icon

Group: Members
Posts: 682
Joined: 8-September 04
From: Scotland, UK
Member No.: 389



Recently been attacked by

"Can't create/write to file '/tmp/#sql_28e2_0.MYI' (Errcode: 13)"?

Then its a simple fix, please DELETE (backup first) your SOURCE files that talk to the MySQL database, and re-upload them

This will purge them from the system and force them to recreate the temporary files.

Do NOT delete your database, just backup your files, delete them, re-upload them and youll be fine.

This is due to MySQL crash. Easily fixed and no data has been lost.

Sorry guys


Details:
MySQL crashed while writing data, it seems the temporary file has been corrupt and probably deleted by the system in an attempt to correct itself. This isnt a problem as the data is stored in a much more secure way to prevent this, and MySQL is coded to directly stop this. But as the file is now gone, the server cant write to it like it wants to because its not there, Error 13 is "Permission Denied". Now to fix it, Apache is already using our source files and a byte cacher is holding all our files and all has the old MySQL temporary file name, so you need to delete your current files, which will purge them from the cache, and then upload them again which will make fresh new entrys in the cache for the temporary storage. The temporary file is for holding data to be written to the database and its built like this so that this specific error cant happen to the database. This is highly unlikely to happen again, but then again it was highly unlikely to happen a first time.

~Trekkie
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. General Problems With New Account(2)
  2. Php Parsing Error On Smf On My Site(16)
  3. My Site(5)
  4. Upgrade Error(3)
  5. MySQL Database(3)
  6. IPS Driver Error / MySQL Database(1)
  7. Wrong Password/username - Fatal Error In Horde(4)
  8. Can I Access MySQL Database From Outsite, Directly(10)
  9. MySQL - Can't Connect(1)
  10. Problem With MySQL Not Being Able To Connect(9)
  11. Weird MySQL Message(4)
  12. Mail Delevery System Error(6)
  13. Problems With PHP/Joomla On Hosted Site(7)
  14. Help Me!(3)
  15. Site Unavailable!(7)
  1. Error Accessing Forum Topics(1)
  2. Mysql Error Never Seen On My Site Before (too Many Connections).(13)
  3. Mysql Connect Error, Too Many Connections.(1)
  4. Php And Mysql Version.(7)
  5. Problems With cPanel(9)
  6. Problem With MySQL(5)
  7. What Is The MySQL Version @ Asta ?(16)
  8. Server Or Me?(5)
  9. Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql(3)
  10. Strange Error (maybe Directoryindex Glitch?)(6)
  11. Mysql Server Not Stable After Hard Disk Swap On April 6th(2)
  12. Connecting To Astahost's Mysql(8)
  13. New Tutorials Have Issues(2)


 



- Lo-Fi Version Time is now: 5th December 2008 - 01:29 AM