Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Erik van der Veen
March 4, 2006, 7:23 pm
rate this thread
Can anybody tell me how I can get the backup ( just a file copy of the
directory with .frm, .MYI and .MYD files) back into a newly created
I am failry new to MySQL.
Due to a crash of my Windows 2003 server I was in a hurry creating a very
quick backup so I didn't tokk the time to find out what a correct backup
mechanisme shoul be.
Now I have a new server and installed the latest MYSQL (I think I had an
earlier version before)
I just copied the files into the "mysql datafiles" folder. It doesn't pick
them up automaticaly.
Can anybody tell me how to get them back in.
I can't imagine the data's lost ?
Many, many, Thanx in advance...
Re: HELP! How can I get my tables (.FRM etc..) back into a database.
So you waited until you had a server crash before you thought about making
For what it's worth, the proper backup technique uses the "mysqldump" tool
(or GUI front end to same). Read about backing up and restoring in the
following section of the docs:
It is not safe to back up the files in the data directory while the MySQL
server is running, because the contents of the files don't necessarily
include all committed data in the databases; some data could reside in
cache, in the memory of the MySQL service's process. If you copy the files
in the data dir, you might get a version of the database that is incomplete
and internally inconsistent.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum