469,632 Members | 1,666 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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
Jul 20 '05 #1
2 1989
"Thomas Bartkus" wrote:
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


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
Jul 20 '05 #2
"Thomas Bartkus" wrote:
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


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
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
3 posts views Thread by Reuben Pearse | last post: by
1 post views Thread by Elaine | last post: by
1 post views Thread by Rajesh Kapur | last post: by
reply views Thread by newman | last post: by
3 posts views Thread by deepstar | last post: by
5 posts views Thread by zgh1970 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.