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

[21novembre]

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

[Thomas Bartkus]

<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

[steve]

"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

[21novembre]

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