1

I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that.

I've tried just copying the database files into the MySQL Data folder, but most/all of the tables are missing (wordpress). Is there any other way I could recover this data?

I believe it was using InnoDB.

3
  • A list of the filenames that you restored would be helpful. Jan 15, 2012 at 17:38
  • coxnetworks.co.uk/databases.png I think are the important ones
    – e__
    Jan 15, 2012 at 17:50
  • Ok, I've got it to work. I installed WAMPServer, copied and pasted the whole data directory, went into phpmyadmin, exported it, and then got back to the normal mysql install package. Don't ask me why it worked, but it did.
    – e__
    Jan 15, 2012 at 18:18

3 Answers 3

2

If you are using InnoDB, then you need the ibdata* files that should have been in the main MySQL data directory, i.e. the parent of the folder containing the database files.

6
  • I have the ibdata files (coxnetworks.co.uk/databases.png), but how would I go about restoring them on Windows?
    – e__
    Jan 15, 2012 at 17:52
  • Stop MySQL server, place the ibdata files where they belong and then restart MySQL. This of course is assuming that the new MySQL server doesn't have any other data. Jan 15, 2012 at 17:53
  • That's what I tried, but it just doesn't start at all if I do it. It doesn't have any data at the moment, apart from obviously the performance_scheme stuff that comes 'preinstalled'
    – e__
    Jan 15, 2012 at 17:57
  • Check your MySQL error log and it will show what the problem is. It may be that your MySQL configuration file's settings regarding InnoDB do not match how the files are setup. Jan 15, 2012 at 17:59
  • Ok, I've got it to work. I installed WAMPServer, copied and pasted the whole data directory, went into phpmyadmin, exported it, and then got back to the normal mysql install package. Don't ask me why it worked, but it did.
    – e__
    Jan 15, 2012 at 18:18
1

It worked because if you used the default export from phpmyadmin, it writes the dump to a sql file with an insert script.

0

Ok, I've got it to work. I installed WAMPServer, copied and pasted the whole data directory, went into phpmyadmin, exported it, and then got back to the normal mysql install package. Don't ask me why it worked, but it did.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .