I am starting a software as a service company and have a dedicated MySQL server running on Linux. It has RAID mirroring but I need to take nightly backups as well and store them either remotely or on a locally connected drive.
There will be 100, and hopefully eventually 1000’s of databases.
I am thinking of using the built in MySQL tools backup script in the GUI tools, which seems to work well. But I have also read about rsync and other disk mirroring backups. What do you guys recommend?
Also, do you guys think a simple external USB connected drive 500GB to the MySQl server is good idea, or is it worth the money to look at TAPE or remote backup on a geographically different location? What exactly is the benefit of TAPE anyway? Seems to me like TAPE is so freaking old, and expensive, I don’t understand why anybody would use it over a simple USB external drive.
I realize that this is probably wishful thinking, but if someone could point me to the closest existing technology to do what I need to do I would really appreciate it. I run two forums from an SDX account at JaguarPC. For those of you that don't know, an SDX account is basically a large shared hosting account with more available resources and less accounts perserver. Anyway, they've been great, but I need to set up some sort of backups and I'd like to do them to my home pc. What would be ideal....and I doubt it exists....would be something like robocopy on windows which syncs up changed/added files on a regular basis. The problem is, this is a Linux account and my home pc is an XP machine. Is anything even remotely similar to this possible?
Just as an aside, I'm already creating nightly DB Dump backups but they are stored in the account? This won't help much in the case of a catastrophic failure. The backup, if possible, would backup these DB backups as well since they are in the account.
some software that can be ran on a desktop that will allow me to download and backup my databases from my Cpanel server.
I have a remote backup server that once the databases are backed up can be uploaded to this location. Im not too sure if im going around things in a long winded fashion, but ideally i need a solution that can take management of my database backups.
The cpanel dedi im using at the moment is currently utilising the Backup feature, so this is a secondary backup. At the same time i would like to select which databases are backed up too.
Realistically im looking for your expert advice here, im a novice when it comes to server admin etc so your expert help to guide me would be fantastic. Im not to sure whether i would need a desktop tool to back these databases up, or whether it can be done at a server level? Dare i say it im just used to using GUI's and not so familiar with command lines etc.
We have a dedicated server, on which we hosts about 15 sites. I am needing to: Backup each site individually (all files) Backup each Db associated with each site FTP to our own in-house ftp server
I have been searching around all afternoon, and possible solutions to each point above are the following:
Iterate through each top level folder in, say /var/www/vhosts/ and tar each folder individaully
I have only been able to do a mysqldump the whole server, and have only found scripts into which you have to manually specify each db if i need separate backups for each one done
Not an issue, we currently have backups from a separate server running
Is it possible to set this all up in one, top-level cron job?
Just a warning to all other hosts out there using cPanel it currently generates corrupted mysql backups due to a bug in their pkgacct script which has been like this for over 6 days now.
[url]
So for anyone out there it's an easy fix.
Of course not every host is doing it so the fun of helping a customer migrate data and explain to them that their hosts backups being made are all corrupted is lots of fun.
Sort of sad but I've been told this isn't a critical enough issue to even push it out to all versions. Right now it makes a great lock in so customers cannot switch providers without a lot more work.
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
How many would you guys recommend me? Currently I make backups on my own server and one at offsite. And what's the diffrence making backups trough ssh ot ftp? Because right now I work with ftp because I don't understand ssh.
I have a VPS and an NAS in same data center that are connected via a private network within the datacenter. I can access the datacenter's private network and both servers via VPN.
I can access VPS via SSH. How do I FTP the data on the VPS to the NAS without downloading to my desktop and re-uploading?
I've got a VPS with SLHost and have setup a remote backup account with RVPalace
The VPS is running WHM/Cpanel
I'm running a fairly busy forum and host a few friends sites on the server to. (CMS systems etc)
What's the best way to go about backing up the data to this remote host?
Would you say WHM's backup system is sufficient? I don't feel comfortable with one backup every 24 hours, so i'm wondering if there's anyway to reduce that to every 6 hours?
Or would you guys recommend RSync instead?
I do have a question regarding RSync...something that worries me
If it's set to backup the sites every 6 hours and only backs up when something changes (Files/databases)
If, god forbid, a site gets hacked, but isn't noticed and Rsync kicks in and backs up the hacked site, there'd be no way to go back to a previous backup, would there?
what I want to do is a backup every night of the files on my servers from the Data Centre to a server in our local office. What would be the best program to do this? The OS would be Windows Server 2003.
I have a dedicated server that only has around 3-4gb of data on it. I would like to do automated nightly backups for as cheap as possible. I don't want to pay to have my server managed just to be able to have automated backups, so what other solutions do I have? I know I can get really cheap storage from Amazon or Mosso, but is there a way to automate this?
I would like to know what is the difference in cpanel between a full backup and a daily or weekly backup, and how they work together. I was under the impression that a daily backup was a backup of all the files at the end of the day but apparently according to my host this is not so, and Im a bit confused as to what is the purpose of the daily and weekly backup.
I have dedicated server and I have daily,weekly and monthly backups located in:
root: /backup/cpbackup (my secondary drive) each account's backup locate in specific directory like: the backup of account website1.com will be located in: root: /backup/cpbackup/website1 all backups are not compressed file
if anyone knows about cheaper and reliable colocation services in East/ Central. I don’t need premium bandwidth (Internap, Level 3, etc). I need to colocate ½ rack to host my Backups, Bandwidth needed is 5 MB since I use Rsync at different hours, so I don’t need to push more than that.
I try to look for colocation services here in Colorado, but all companies quote me $50 to $70 for each server and $130 per MB.
Check this out... I was just diggin around in my Dreamhost panel and discovered something new that I've not even seen announced anywhere... Dreamhost is giving a BACKUPS user on each account, totally separately from the web user. You are allowed... well, I'll just copy / paste straight from the panel:
At DreamHost, you may only keep website-related content on your regular users. You do, however, get one user per account where anything legal may be stored; your Backups User.
This user cannot have any websites pointed to it, nor may you share files via it... it is only to be used as an off-site backup for your personal files. As such, we keep no backups of files on this account. These are already supposed to be your backups... not your only copy! (Of course, you should always keep your own copies of all data stored with us.. we make no guarantees!)
Every full DreamHost Hosting plan includes 50GB of backups space! (Additional usage will be charged at the rate of 10 cents / GB a month: the best backup deal on the net!)
Pretty interesting... they didn't HAVE to do that, it's just another one of those things that they give in order to be even MORE awesome, evidently.
Rsync seems to be popular as a backup solution, so I thought I give it a look myself. However, after looking for a while I think it is lacking in either (1) usability or (2) security for backups.
Lets use a backup of /home for example:
(1) To make the transfer secure I'd use rsync over ssh. Backup works great - untill you have to restore. Restore works only partially, because all the files now have the user/group id of the user on the backup server (even if the restore is run as root). You'd have to chown all the individual users dirs, permission files....error prone and a lot of manual work --> not good.
(2) Running rsync in daemon mode on the remote server preserves uid/gid and permissions. Restoring works like a charm when run as root. But, hey, now every 13 year old with some knowledge and a packet sniffer can write down your data unencrypted. They just need to look for -lets say- db-info in php files etc and suddenly have access to your customer base or whatever you store.... Even worse if you transfer db dumps or other sensitive data. So it is not safe to use --> not good.
Is there a way to secure the transfer or keep uid/gid info intact? And how do all the backup providers handle the issue? (This one here claims rsync is secure.) Or is there another way to fix the problem - restoring uid/gid and secure transfer for backups.
I have recently wen't with a Windows VPS and am wondering the best way to do backups to a remote computer (hopefully without buying software). Any suggestions?
I want to set up my server (a linux dedicated server) to automatically create daily backups of the pop3, mysql, & webfiles. I want it to go to a server which i have purchased with the exact same specifications.
I am not very good at unix command line/scripting. So what I need is for someone to help me define the backup strategy, select the scripts, and tell me of how to make sure backup server is secure.
We all know about backups, and compressing files, etc etc... so, what do you guys do in this situation?
I have a quad core, 4gb ram, 250gb disk, when I run cpanel backups to my remote server, the server loads go up to 3.
Is there any way I can control this and lets say... dont let it go bellow 2?
Improved Backup Performance — Speed is safe.
cPanel’s backup facilities in 11.24 have seen significant speed increases. In previous versions, load averages while backups were running could be as high as 3. With our reworked and enhanced backup system, load averages tend to stay around 1.2 when backups run on servers with many accounts. This is an extremely substantial performance increase that you and your customers will notice right away. With our new backup system, there is no reason not to keep your data safe."
I've been searching for a tool to automate website backups for me, that is to keep regular copies of files and databases in case of unexpected data loss. So far I found Site Vault that handles both FTP and MySQL backups at the same time. Does anyone know good alternatives to consider?
