I have been asked to repair a MySQLServer instance. My understanding is that the associated executables are on the Windows XP C: drive, but the data was on the E: drive. The E: drive failed. However, I have what I believe to be a backup copy of the data (a single file named "ibdata1"), which someone copied to a folder on the C: drive just before the E: drive failure. My questions are:
1. Is it likely that the "ibdata1" file IS the SQL data? Does "ibdata1" sound like a default-name, and is a small SQL dataset stored in a single file?
2. Is there a way to see (edit) the configuration? I am hoping that I can just change a pointer to point to this data file. I found MySQLInstanceConfig.exe, but it prompts me saying it will over-write the current config. I would just like to view the current cofig (location of data).
Obviously, I have never worked with MySQL. Any help / suggestions sincerely appreciated.