Email address obfuscation in effect -- please
click here to turn it off.
[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
> hi,
> how i can take backup of mysql databases?
1. Read the backup section of the mySQL book that you bought when you
decided to administer a mySQL database.
2. Read section 4.4 of the online mySQL manual
3. visit google.com and type in "mysql backup" then peruse the results at
your leisure.
4. Do all of the above and maybe even add in a visit to frshmeat.net and
sourceforge to look for other solutions.
There are a great many ways to backup mysql databases - enough to fill whole
chapters of books. Before you use someone else's solution, make sure you've
read the manual and are aware of the security implications of whatever
strategy you finally adopt.
Our solution is to use a bash script that copies the contents of all our
mySQL databases to a local file. We then tar and gzip the file before
placing it in our backup folder that resides on a RAID array. That folder is
then rsync'd to another machine each evening and from there will be copied
to tape and archived.
Russell.
_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members
Home | FAQ | Server | Presentations | Mailing Lists/Archives | Member Tools | Links | Sponsors | Contact