Backup/Restore MySQL databases.

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

    Backup/Restore MySQL databases.

    Is it safe to say that restoring the [/usr/local/myql/data] directory from a
    backup would that restore all database data and structure? All usr/pwd and
    GRANT info?

    Thomas Bartkus


    Tags: None
    • steve
      #2
      Re: Backup/Restore MySQL databases.

      "Thomas Bartkus" wrote:[color=blue]
      > Is it safe to say that restoring the [/usr/local/myql/data][/color]
      directory[color=blue]
      > from a
      > backup would that restore all database data and structure? All
      > usr/pwd and
      > GRANT info?
      >
      > Thomas Bartkus[/color]

      You would be able to restore the data as you state. You would then
      have to run an sql repair on all tables, as mysql would not be in sync
      with those tables. I have heard that sometimes repair may not work,
      but I have not had problems with this personally.

      I don’t know about the privilages. I am talking about restoring
      databases one at a time.

      --
      http://www.dbForumz.com/ This article was posted by author's request
      Articles individually checked for conformance to usenet standards
      Topic URL: http://www.dbForumz.com/mySQL-Backup...ict125574.html
      Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=433751

        Comment

        • steve
          #3
          Re: Backup/Restore MySQL databases.

          "Thomas Bartkus" wrote:[color=blue]
          > Is it safe to say that restoring the [/usr/local/myql/data][/color]
          directory[color=blue]
          > from a
          > backup would that restore all database data and structure? All
          > usr/pwd and
          > GRANT info?
          >
          > Thomas Bartkus[/color]

          You would be able to restore the data as you state. You would then
          have to run an sql repair on all tables, as mysql would not be in sync
          with those tables. I have heard that sometimes repair may not work,
          but I have not had problems with this personally.

          I don’t know about the privilages. I am talking about restoring
          databases one at a time.

          --
          http://www.dbForumz.com/ This article was posted by author's request
          Articles individually checked for conformance to usenet standards
          Topic URL: http://www.dbForumz.com/mySQL-Backup...ict125574.html
          Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=433751

            Comment

            Previous template Next
            Working...