AREAS.TMD file in database. What is it?

Permalink
Hi

I've got a few problem sites with a custom theme that are quite old. All of them have an AREAS.TMD file in the database that is causing problems. The dB keeps crashing and it's always that file that is the issue. Does anyone know what this file is and what it's function is? The sites are running 5.6.3.3. I haven't been able to update them to the latest version due to the manual update process required so.

I do know that one of the Areas in the sites was incorrectly named when built, so instead of "Main" they are called "Main_Copy", which might be the issue?

Thanks, Karen

grovesk
 
jasteele12 replied on at Permalink Reply
jasteele12
Hello Karen,

A .TMD file is MySQL's intermediate file file for a table that needs to recreate its data file.

You could try renaming it, and see what happens, although I would think it would be called Areas.TMD (not AREAS) - the database was not uploaded from a Windows machine was it?

You should probably run this from your favorite MySQL tool:

CHECK TABLE Areas;

and possibly

REPAIR TABLE Areas;

Hope that helps,

John

BTW: There is no current way to upgrade to 5.7+ from 5.6.3.3 (the latest 5.6 release)