myisam - How can I recover MySQL tables from data files? -


I have a database (all MyISAM tables) and the machine where MySQL was running is no longer bootable. However, we have all MySQL data files from the data directory, how can I view in the Data Directory?

I am doing some searching on this and it seems to MyISAM that I can simply copy the database subdirectory from the old MySQL data directory to the new MySQL data directory. However, it is not working for me, trying to recover the database, a database with the name of the database appears in the list of databases in phpMyAdmin, but all the tables are shown "in use" and in it There is no information (for example, number of rows, number of bytes, column information, etc.). No operation on such tables (eg, select * FROM {table}, repairs {tables}, check {table}) does not give any such "such a table" error.

One of my tools is search by a microALEEP DBACCtrael I is a component that is supposed to restore data from FRM / MED files, but when I try to run it, Not listed, which can recover it from my FRM / MID files

This is on a developer workstation which is running Vista Business 32bit. MySQL version is 5.0.27. After fixing the machine, I went and found the same version of MySQL (v5.0.27), wondering if I'm just going to drop into binary data files then I should do it with the same version of MySQL. It still does not work

Any insights will be greatly appreciated ... Thanks!

- Josh

  1. Install the same version of mysql.
  2. Remove the mysql directory from the server's data directory and copy it from the crashed server This is the main element
  3. Copy the copy of the database that you want To recover the server's data directory
  4. Start mysql.
  5. Switch to the mysql database: USE mysql; and the repair table on every table & lt; Table name & gt; Run .

Tip: Make sure that there are two permissions of the same directory as the directory of the directories

If you have mysql Database (MySQL directory in the data directory of your old server), you can try the following:

  1. You want to recover the database with the same database.
  2. You can then create each table (it would be nice to use the same structure - you will have a big chance of recovery).
  3. Then close the mysql server and delete the files from the database directory and overwrite it with the file Old Server
  4. Start mysql and repair each table.

Comments

Post a Comment