Retrieve MySQL data

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Marc
    #1

    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
    Tags: None
    • Aggro
      #2
      Re: Retrieve MySQL data

      Marc wrote:
      [color=blue]
      > 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?[/color]

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

        Comment

        • Aggro
          #3
          Re: Retrieve MySQL data

          Marc wrote:
          [color=blue]
          > 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?[/color]

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

            Comment

            • Aggro
              #4
              Re: Retrieve MySQL data

              Marc wrote:
              [color=blue]
              > 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?[/color]

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

                Comment

                • Marc
                  #5
                  Re: Retrieve MySQL data

                  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 <spammerdream@y ahoo.com> wrote in message news:<CYghc.467 $uz.167@read3.i net.fi>...[color=blue]
                  > Marc wrote:
                  >[color=green]
                  > > 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?[/color]
                  >
                  > 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).[/color]

                    Comment

                    • Marc
                      #6
                      Re: Retrieve MySQL data

                      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 <spammerdream@y ahoo.com> wrote in message news:<CYghc.467 $uz.167@read3.i net.fi>...[color=blue]
                      > Marc wrote:
                      >[color=green]
                      > > 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?[/color]
                      >
                      > 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).[/color]

                        Comment

                        Previous template Next
                        Working...