MySQL keeps many different files, some contain real data, some contain meta data. Witch ones are important? Witch can your throw away?

This is my attempt to create a quick reference of all the files used by MySQL, whats in them, what can you do if they are missing, what can you do with them.

When I was working for Dell doing Linux support my first words to a customer where “DO YOU HAVE COMPLETE AND VERIFIED BACKUP?” Make one now before you think about doing anything I suggest here.

You should always try to manage your data through a MySQL client.  If things have gone very bad this may not be possible. MySQL may not start. If your file system get corrupt you may have missing files. Sometimes people create other files in the MySQL directory (BAD).  This should help you understand what is safe to remove.

Before you try to work with one of these files make sure you have the file permissions set …

This post covers the basic information of files that MySQL Server uses / creates for various tasks. Update: Various files in MySQL 8.0 Refer following updated article for latest information…

The post MySQL related file types and basic information first appeared on Change Is Inevitable.

Background Knowledge

With the use of Samba we are able to share files through a local network and make it appear as if the files are on the Mac OS X locally. The instructions below will step you through step by step on how to access files from the Mac OS X to a Windows XP/Vista™ system through the network.

NOTE: Instructions to unblock network traffic through a software/hardware firewall are not provided. Refer to your software/network manual or support web site for details.

NOTE: These instructions will not allow for sharing via the Internet.

Solution

Setting up a file share in Windows XP

1. Open Windows Explorer/My Computer (press Windows Key+E) or go to the Windows Start Menu -> Programs -> Accessories -> Windows Explorer.
2. Browse to a folder you wish to share and right mouse click on it and left mouse click on “Properties”. …