MySQL Forums
Forum List  »  Merge Storage Engine

Manual backup of files fails
Posted by: Michal Glebowski
Date: May 06, 2008 01:45AM

Dear Friends.

I've got problem with manual backup of merge table.

1. I create MERGE table which consists of some MyISAM tables.
2. I copy database folder from my MySQL..\Data\ somewhere else.
3. I DROP DATABASE.
4. I manually copy back folder to MySQL..\Data\ folder
5. All partial tables are here back but when I try to access MERGE TABLE I get an error: Can't find file 'here my merge table name'.

I found that file responsible for keeping table structure (mymergetable.frm) is there.
What shall I copy more to be able to restore MERGE TABLE that way (manually)?
Michal.

Options: ReplyQuote


Subject
Views
Written By
Posted
Manual backup of files fails
11899
May 06, 2008 01:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.