Am 09.06.2012 03:29, schrieb Keith Keller: > On 2012-06-09, Miguel Cardenas <renit...@gmail.com> wrote: >> I'm still backing up and will take some time before restore the >> system, in the mean time I want to know if I can restore the databases >> from the *.frm *.MYD and *.MYI files, maybe creating the databases >> again and replace them with the old data files? > > If they are MyISAM tables, then you should be able to restore most of > your tables in this fashion. It depends on how often these tables are > written to; if they get writes very frequently then they may be too > inconsistent to recover. The basic process is to create the directory > (either with CREATE DATABASE or directly on the filesystem; make sure > the mysql user can write the directory), then copy the files in to the > directory (make sure nobody is doing any writes to the db during this > process, and make sure the files are owned by the mysql user when done)
oh no, do NOT start mysqld or create datanases copy simply the WHOLE datadir while mysqld is stopped pn both sides and you are done, this does include any myisam, innodb tables including myysql-user-table before you are starting mysqld make shure "chown -R mysqld /path/to/data/dir" that was ot, you are done in the worst case it is the ame as a normal crash and reboot on a working system and needs "repair table" on some innodb tables to repeir indexes there is no magic or rocket science needed
signature.asc
Description: OpenPGP digital signature
