Databases
StackOverflow2013
Postsdbo
POCan I find mysql version from data files, need for data restoration
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan I find mysql version from data files, need for data restoration
    text
    copied!<p>I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this was running on has crapped out, but I was able to put the drive into an enclosure and gain access to the files and recover the MySQL data folder. </p> <p>We are mostly a Windows company and I have very limited linux experience. Before this machine crashed we were experimenting with moving this blog to a Windows Virtual Machine running PHP for IIS; and we have an older copy of the Wordpress database up and running on MySQL 5.1. </p> <p>I am currently trying to retrieve the latest data from the linux MySQL data folder and import it into the current database but I am having problems.</p> <p>Problems so far: </p> <ol> <li><p>I do not know what version of MySQL was installed on the linux box </p></li> <li><p>I see <code>ib_logfile0</code>, <code>ib_logfile1</code>, and <code>ibdata1</code> on the linux MySQL data folder, but am not sure if it was truly running InnoDB or not as I also have <code>.frm</code>, <code>.myd</code>, and <code>.myi</code> files in the wordpress folder</p></li> </ol> <p>If I can figure out the version of the linux box MySQL I might be able to create a virtual machine to run linux and MySQL so I can copy the data folder and then do an export dump; unless someone else knows of an easier way to get the data into my current database.</p> <p>Any help or guidance on this issue would be greatly appreciated.<br> Thanks, Nathan</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload