What is Digg?Sponsored by Dragon Age: Origins
See the new YouTube feature trailer for Dragon Age: Origins view!
youtube.com/DragonAge - EA presents BioWare's new dark fantasy epic Dragon Age: Origins. '9/10' from Game Informer.
13 Comments
- inactive, on 10/12/2007, -1/+9i prefer this simple backup script
http://www.debianadmin.com/mysql-database-backup-using-automysqlbackup.html - fishsoda, on 10/12/2007, -0/+4What happens when your recovered data is corrupted.
- shucklak, on 10/12/2007, -0/+3I'll second automysqlbackup. It's such a simple script that even the newest *nix users can figure it out.
- inactive, on 10/12/2007, -2/+5Aaaand you still have to table lock to do it...therefore its useless.
- fishsoda, on 10/12/2007, -0/+3One mans trash is another man's treasure.
- merreborn, on 10/12/2007, -0/+2"Create a replica, and have it backup that. Then you don't care if the tables are locked, everything will sync backup after the backup is done."
Great idea in theory. Unfortunately, the slave is really easy to crash in the last version of mysql for debian sarge (4.1.11sarge2), and if there are any temp tables open at the time of the crash, replication is broken.
And lock tables on a large, live database = an hour or more of downtime. - mvdde, on 10/12/2007, -0/+2Create a replica, and have it backup that. Then you don't care if the tables are locked, everything will sync backup after the backup is done.
- rynoon, on 10/12/2007, -1/+3I'm not sure why you're getting dugg down. It's always good to be aware of the alternatives.
- jimmyrayjit, on 08/13/2009, -0/+1If you are facing database loss from your MS SQL, you can recover them this way:
http://www.sqldatabase-recovery.com
I promise you. You will easily recover them. I have solve my problem and have recovered my lost SQL database. - jues, on 10/12/2007, -0/+1or.... mysqldump -u root -p --all-databases | mysql -u root -p -h remote.system.net
- Glanzer, on 10/12/2007, -0/+0If you're looking for a robust enterprise solution to MySQL backups, check out Arkeia (http://arkeia.com/pdfs/datasheets/others/Arkeia_MySQL_plugin.pdf).
And no, I don't work for them. - cptcomic, on 10/12/2007, -0/+01. You have to specify a password ( -pPassword ), otherwise you can't automate it
2. With regard to security, your approch is a very bad one
just my 2 cents - stock99, on 10/12/2007, -0/+0can't we just use rsync to back it up like other file?
© Digg Inc. 2009
— Content created and posted by Digg users is