Retrieve MySQL data

[Marc]

Hello,
Until recently I ran a php/apache mySQL wbsite on MacOSX. For some
reason I can't get the machine working again so now the site is
offline. I succeeded to copy the MySQL data from the Mac OX partition.
However, this is the 'raw' data - not a SQLdump but the frm, myd and
myi files for each table.
The data is not of much use if I want to use it in a website again,
I'd rather have a SQLdump.

So now my question is:

Can I just add these files in the data directory of another mySQL
installation I setup locally under win2k and be able to make a dql
dump?

Or is there another solution?

Thanks!
Marc

[Aggro]

Marc wrote:

Can I just add these files in the data directory of another mySQL
installation I setup locally under win2k and be able to make a dql
dump?

Or is there another solution?

Atleast if you are using same OS and same version of MySQL it should
work (it worked for me). I'm not sure will it work from one OS to
another OS, and from some version to another version it propably won't
work (properly). But give it a try (but be sure to have backups before
trying).

[Aggro]

Marc wrote:

Can I just add these files in the data directory of another mySQL
installation I setup locally under win2k and be able to make a dql
dump?

Or is there another solution?

Atleast if you are using same OS and same version of MySQL it should
work (it worked for me). I'm not sure will it work from one OS to
another OS, and from some version to another version it propably won't
work (properly). But give it a try (but be sure to have backups before
trying).

[Aggro]

Marc wrote:

Can I just add these files in the data directory of another mySQL
installation I setup locally under win2k and be able to make a dql
dump?

Or is there another solution?

Atleast if you are using same OS and same version of MySQL it should
work (it worked for me). I'm not sure will it work from one OS to
another OS, and from some version to another version it propably won't
work (properly). But give it a try (but be sure to have backups before
trying).

[Marc]

OK, problem solved. How?

1 move all datafiles from Mac OSX to pc;
2 install MySQL on pc& move the datafiles in the datafolder of new
MySQL installation;
3 start mySQL server;
4 use mysqldump.exe (in bin directory) to backup the data;
5 voila....

Thanks for the advice Agg.

Aggro <sp**********@yahoo.com> wrote in message news:<CY**************@read3.inet.fi>...

Marc wrote:

Can I just add these files in the data directory of another mySQL
installation I setup locally under win2k and be able to make a dql
dump?

Or is there another solution?

Atleast if you are using same OS and same version of MySQL it should
work (it worked for me). I'm not sure will it work from one OS to
another OS, and from some version to another version it propably won't
work (properly). But give it a try (but be sure to have backups before
trying).

[Marc]

OK, problem solved. How?

1 move all datafiles from Mac OSX to pc;
2 install MySQL on pc& move the datafiles in the datafolder of new
MySQL installation;
3 start mySQL server;
4 use mysqldump.exe (in bin directory) to backup the data;
5 voila....

Thanks for the advice Agg.

Aggro <sp**********@yahoo.com> wrote in message news:<CY**************@read3.inet.fi>...

Marc wrote:

Can I just add these files in the data directory of another mySQL
installation I setup locally under win2k and be able to make a dql
dump?

Or is there another solution?

Atleast if you are using same OS and same version of MySQL it should
work (it worked for me). I'm not sure will it work from one OS to
another OS, and from some version to another version it propably won't
work (properly). But give it a try (but be sure to have backups before
trying).