There are files beginning with 1.<sequence number>. The sequence number is 000001 to 000015. A new file is created every time MySQL is restarted. The 1.index file contains a list of these files. One thing that I have done is when I was hardening the security we stopped MySQL and moved the data directory to a directory called /var/lib/db/mysql. I changed the datadir variable in the my.cnf file to point to this directory. This was to be sure that our data directory was not on the same partition as our SYSTEM or the Log partitions. Everything is working fine except I have the files mentioned above.
Thanks, Sandra Arnold Data Warehouse Administrator MartinFederal Consulting Consultant to Oak Ridge National Laboratories Computational Data Analytics Group Data Architectures Team -----Original Message----- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Wednesday, March 27, 2013 3:14 PM To: mysql@lists.mysql.com Subject: Re: *.index files in MySQL Data directory Am 27.03.2013 19:53, schrieb Arnold: > What are the *.index files in the MySQL Data directory? I notice a new one > is created every time that MySQL is stopped and restarted. My Data directory > is not in the default location so does that have anything to do with it? maybe a "ls -lha" of a sample would be nice never seen one of them from MySQL 3.x to 5.5 nor with MariaDB, indexes are .MYI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql