By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,207 Members | 1,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,207 IT Pros & Developers. It's quick & easy.

Can I backup my databases by copying "data" folder instead of mysqldump?

P: n/a
Hi all,

I made a question several days before to describe my strange trouble of
mysqldump. But I still can't figour it out. Well, I just want to ask
another question whether I could just backup my databases by copying
the data folder to some place? Then if I meet some disaster, could I
just copy the backup folder back to recover my databases?
Thank you.

Zh.y

Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<21********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi all,

I made a question several days before to describe my strange trouble of
mysqldump. But I still can't figour it out. Well, I just want to ask
another question whether I could just backup my databases by copying
the data folder to some place? Then if I meet some disaster, could I
just copy the backup folder back to recover my databases?
Thank you.

Zh.y


Yes!
Presuming that you will shut down the server during a copy/restore
operation, you may do a simple copy on the data directory.

Thomas Bartkus
Jul 23 '05 #2

P: n/a
"tom173" wrote:
<21********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi all,

I made a question several days before to describe my strange

trouble of
mysqldump. But I still can't figour it out. Well, I just

want to ask
another question whether I could just backup my databases by

copying
the data folder to some place? Then if I meet some disaster,

could I
just copy the backup folder back to recover my databases?
Thank you.

Zh.y


Yes!
Presuming that you will shut down the server during a
copy/restore
operation, you may do a simple copy on the data directory.

Thomas Bartkus


It is detailed, with the tar parameters and all, in the mysql manual
(Section 6 but I could be wrong).

You can also issue an sql command to lock tables, and then make a
backup. A little drastic than shutting down mysql, but still may stop
service to users.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-backup...ict221584.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=763035
Jul 23 '05 #3

P: n/a
Thank you very much! I'm reading the manual.
But, I still wish somebody could help me out from my previous question
about mysqldump. Here is the link:
http://groups-beta.google.com/group/...eddfff1321ef5f

Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.