469,890 Members | 1,978 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

Retrieve MySQL data

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
Jul 20 '05 #1
5 1652
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).
Jul 20 '05 #2
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).
Jul 20 '05 #3
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).
Jul 20 '05 #4
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).

Jul 20 '05 #5
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).

Jul 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Andy Jackman | last post: by
reply views Thread by Marc | last post: by
16 posts views Thread by Daniel Tonks | last post: by
13 posts views Thread by no.mail.pls | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.