HELP! How can I get my tables (.FRM etc..) back into a database. - MySQL

[Erik van der Veen]

Hi,

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
database.
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...

Erik

[Erik van der Veen]

Oke..

Solved my own problem allready....
Seemed that after reconfiguring the newly installed database to only ISAM
usage, the data directory reverted to default.
So I was putting the files in the wrong directory...

Thanx







"Erik van der Veen" <erik_vanderveenhotmail.com> schreef in bericht
news:4409e950$0$11067$e4fe514cnews.xs4all.nl...

> Hi,
>
> 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
> database.
> 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...
>
> Erik
>

[Bill Karwin]

"Erik van der Veen" <erik_vanderveenhotmail.com> wrote in message
news:440a0a1a$0$11077$e4fe514cnews.xs4all.nl...

> 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.

So you waited until you had a server crash before you thought about making
database backups?

> Seemed that after reconfiguring the newly installed database to only ISAM
> usage, the data directory reverted to default.
> So I was putting the files in the wrong directory...

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:
[url]http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html[/url]

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.

Regards,
Bill K.