PDA

View Full Version : Restore data by copy the data file


asp123
08-23-2004, 04:12 AM
Please help...

Firstly, i have restored the data by copying the data file into
c:\mysql\data\abc\

It works.

But, I have the problem as I want to copy another updated data files (*.frm, *.MYD, *.MYI) into the folder.

All data is lost! but, the size of the data file is not zero. :eek:

If I do the same action to replace the old data files, it works again. :confused:

Now, how would I can restore the updated data?

Thank you very much.

raf
08-23-2004, 09:00 AM
What exactly are you asking for?

Why don't you simply create a dumpfile and then run this at the server where you want to add the data?