How To Easiest Do Backup And Transfer Of Mysql Files
Jun 29, 2008
I have following problem-i have over 20 sites on server and each site has own database.Is there a way to speed up backup and transfer or other server?
Method which i use right now it's following:first i archive entire directory using command tar -pczf name.tar.gz public_html,and then repeat with each directory.But i think i could simply archive all requied directories,but that will took toomuch time,so if i drop connection during archiving it wont be archived at all then.So i think best solution will be to create some kind of batch command which can load in background,so that means command wont stop if client lost connection.
So let's say i have 2 sites and two directories located and different places.
One is at home/site1 and other at home/site2
So i think i would need to put command into batch file
tar -pczf site.tar.gz. /home/site1 and tar -pczf site2.tar.gz /home/site2
Will that work? Also second part,mysql databases,i founded if i login into phpmyadmin as root i can see all databases.I managed to export all databases,but question will import again to phpmyadmin work.I think phpmyadmin create command for each database "if there is no db sitename_mysqlbase,create it",but howmuch i know phpmyadmin have limit with importing size of mysql database.Could that be done with import/export mysql command?
I'm in the process of switching to a new host for my websites. My old host is Servage and my new host is Dreamhost.
I'm looking for a way to directly transfer all my files from Servage to Dreamhost (i.e. don't transfer them via my PC).
Whilst Dreamhost offers a whole suite of access to their servers, Servage only offers FTP (no SFTP, no SCP, no SSH, no RSYNC). Servage also don't give any ability to create a tar.gz of my files (I tried to use a Perl script to execute a shell command to tar my files, but it didn't work )
So currently the only way I can see to get the files across to Dreamhost is to use the ftp command (via SSH on Dreamhost), but this command is severely limiting because mget can't transfer directories - it can only transfer files in a directory.
Can anyone see an easy way for me to get all files across to my new host?
is there any soft for windows who can transfer files from one server to another? I have Shell access on both servers but dont know how to do that via shell..is there any GUI soft for windows where I can on one window see files from one server and on other to see files from second server?
I've been asking a fair few question lately here on WHT. You've all been a great help so far. I just ordered two new servers from www.northstorm.net. I want to take all my video files from my previous host, and transfer them over to my new host. There's roughly 100 files which is a total of about 8GB. I have a php script which can copy the files manually, one by one, but that's the last resort as I'm not very keen on that idea.
I have root access to both servers so I can pretty much do what I want with them. What's the best way to grab the entire contants of a ftp folder and transfer it over? I need to copy the files from my old host to one of my new servers, and then copy the files between my two new dedicated servers.
Are there any good software that will backup current server files and restore them on a new server?
I'm looking for full backup, that would backup all the files in less time instead of going to each account's cpanel first and downloading backup than restoring it to new server.
I have a 6GB backup file created with another Plesk Backup Manager, now I trying to upload this backup file to my Plesk Backup Manager but after upload 3% I am getting "413 Request Entity Too Large" error, I tried with disable NGINX but still getting this error.
how can I resolve this error or is their any other way to upload my file on backup manager?
I see that Backup Manager have a file size restriction of 2GB how can I increase this?
transfer a client's site files (over 220 MB) to my server. The client does not use cPanel or have SSH access.
FTP is horribly tedious. I have created the account on my server and have SSH enabled. I have a feeling I can use wget to download the files to the account's home directory, but I am not sure of the correct syntax to recursively download all the directories and the files.
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
I administer a busy forum and require a best backup solution. (Servers are clustered and running Debian Etch)
Currently when backup script packs the whole partition using command: tar cvzf /backup/webroot/webroot-(today's-date).tar.gz /webroot But, this causes huge load on to the server and the whole website becomes unavailable during this time.
Since the number of files is huge, it takes around 10-15min for it to finish.
Now, I need another software or a way to limit tar's load on to the system so that the website doesn't go down during the backup process.
(dd would work as /webroot has it's own partition but I'm not sure on how it the load goes with it and also if it works with cron) Do you know any good solution?
Also, right now all backups are on each server separately.
To clarify, mysql server's backups are on mysql server and actual files' backups are on web server.
As you may have realized, this is very bad as it won't protect me from harddisk failures and hackings.
(Hacker can just delete the whole thing and website will be gone forever...)
So, to prevent them from happening and also for central management of the backups, I got a server just for backups.
Now, I need a way to transfer the backups to it.
What software do you recommend to accomplish this? (scp, rsync, ncftp, etc...)
Some of you may say R1Soft's CDP is the best but I would like to have that as my last option because I don't want to rely on another company when it comes to backups.
I was wondering what you people do when a new customer registers a new domain (only domain) and then parks in on your server. Now I manually park it on top of parked.myhost.com so that everybody who visits this domain will see the custom "Hosted with"-page. But there has to be an easier way/automatic way to do this? So please, share your knowledge
I'm doing some research on offering VPS hosting solutions, nothing firm yet as do we start to offer them or not.
So, what are you experiences for as automated as possible VPS hosting offering? Using multiple servers as VPS hosts etc. ready made images etc.
Or am i better of by doing custom tailored my own?
The basic plan is to offer as automated as possible, with minimal support overhead etc. using 2co/paypal/moneybookers subscriptions etc. basicly as simple, and yet as powerfull as possible. Sounds like custom tailored system is the best option.
How about just the server backend only automation wise?
I've got two domains (for sake of example, domain A and domain B). Domain A resolves correctly to my web server. Domain B is just sitting collecting dust. I didn't set these domains up, a previous programmer at my job did.
How do I configure resolv.conf, named.conf and the zone file(s) correctly to have domain B redirect to domain A?
I've already set up httpd.conf so that any requests for the host name of domain A will redirect.
e.g. [url]-> [url] I just need the DNS part of this fixed (that I'm a bit of a noob at).
Do I have to do something like this in named.conf:
Code: zone "domaina.com" { type master; file "/var/named/domaina.com.hosts"; };
zone "domainb.com" { type master; file "/var/named/domaina.com.hosts"; }; Then in the domaina.com.hosts zone file add an alias like this?
Code: domainb.com. IN CNAME domaina.com. Or do I need to create a domainb.com.hosts zone file with basic info emulating domaina.com.hosts zone file, and add its entry in named.conf?
I've got two domains (for sake of example, domain A and domain B). Domain A resolves correctly to my web server. Domain B is just sitting collecting dust. I didn't set these domains up, a previous programmer at my job did.
How do I configure resolv.conf, named.conf and the zone file(s) correctly to have domain B redirect to domain A?
I've already set up httpd.conf so that any requests for the host name of domain A will redirect.
e.g. [url] I just need the DNS part of this fixed (that I'm a bit of a noob at).
Do I have to do something like this in named.conf:
Code: zone "domaina.com" { type master; file "/var/named/domaina.com.hosts"; };
zone "domainb.com" { type master; file "/var/named/domaina.com.hosts"; }; Then in the domaina.com.hosts zone file add an alias like this?
Code: domainb.com. IN CNAME domaina.com.
Or do I need to create a domainb.com.hosts zone file with basic info emulating domaina.com.hosts zone file, and add its entry in named.conf?