hello if i have multiple domains all in one or separate hosting companies is there a way to backup all the data files+database together ? like a program to login to my cpanel and backup all my domains together so that the restoring will be easy?
You can use something like: http://www.navicat.com/ to do the databases. There are a number of ftp programs which can be setup to perform backups of all the files.
by Persky Bunkermeister36 on Sep 26, 2006 at 4:44 pm Permalink There are two things you have to protect yourself from: loss of files due to hardware failure, and loss of file due to change or accidental deletion. "Mirroring" protects you from certain kinds of loss, but not all. For example, if your computer is stolen, or if something catastrophic happens, like your house catches fire and your computer is destroyed by heat or water. Also, mirroring doesn't protect you from accidental deletion or change of files either. Backups should be stored as far away from your computer as possible. I have all my email automatically forwarded to a free internet email account for backup. And, I use a program called "SyncBack" ( http://www.2brightsparks.com/freeware/freeware-hub.html ) for backing up files. I organize my files in such a way that different types of files are backed up in different ways. I copy all my files onto a big (200GB) external disk drive. I keep this drive well hidden in the house, and refresh the backup at least once a month. I organize all the files that I want to protect from accidental deletion in a folder called "active," and I back that folder up pretty well every time something changes -- I have a bunch of 1 GB USB thumb drives I cycle through so that I can retrieve older versions of files if need be. I also backup my my web browser profile this way. I store the current backup in my pocket. (This method wouldn't work for backing up photo's and media -- but I don't consider those "active" files.) SyncBack is easy to use -- you can create "profiles" specifying what and where to copy files, and a keyboard shortcut launches a specific backup profile. These days, there are a lot of free places on the web to store files -- you can mail yourself copies of your most important files, and just store them in a free email account... while those places aren't safe from prying eyes, you can encrypt files if you are concerned about privacy. A final comment about passwords -- if you have accounts you want somebody else to access if you should die unexpectedly, or find yourself suddenly unable to access the internet, create a file with all your account information and passwords, and encrypt it with a master password that you don't use for anything else. The master password should be easily rememberable by yourself and the person you share it with -- I shared my password with my brother and use the name of one of his childhood buddies as the password. re: mirrored backups comment Scubabob -- the question is about "home" computer... remote mirroring is a very expensive solution for a home user, though it depends a little on how the user wants to replicate their data -- still it's more complex than I expect 99% of home users to undertake. So how does "colocated mirroring" protect you from theft and fire and accidental loss of data? I was a manager at AT&T IS (back in the days when their network of UNIX boxes were among the world's biggest networks). There, mirroring was used to ensure 24x7 operations of "mission critical" applications. Users of individual applications were still responsible for planning their own incremental backups so that they could recover from various kinds of "user errors" and application failures. Databases made this easier, because you just had to back up log files to tape, they were used to "roll forward and backwards" through the data -- but who's running a mission critical 24x7 application at home that they can roll back from database log files? With my back up system, if my home computer dies, is attacked by a virus, or my own stupidity -- I can take my USB stick to the local internet cafe -- and pretty well pick up where I left off at home. re: CNE MSCE101 -- how do you backup the gear on the CEO's desk? (Scubabob... maybe create a better answer for this?) My partner works in upper management of a large (40,000 employee) firm -- I can't tell you the # of times she comes home with a computer just given to her by the PC guys, and for one reason or another, she can't do what she brought it home to work on. Many managers don't trust their CNE/MSCE101 guys. 9 Pts Rate Answer
if you have separate site on separate hosting company, I don't think it possible to backup all databases without login into each account. But if you put them together in one private server, the database backup will be much easier. simply use mysqldump via root SSH and all databases will be backed up