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?

View 5 Replies


ADVERTISEMENT

Plesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database

May 27, 2014

I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.

View 1 Replies View Related

How Transfer Full Backup From FTP Backup To CPanel?

Dec 14, 2008

I have transfer full backup with cpanel to ftp backup,

But,How transfer full backup from FTP Backup to cPanel?

Whitch software?

View 9 Replies View Related

Transfer Files At 40 Kb / S

Jul 8, 2008

I know which is the transfer speed of my hosting? I have hired a plan with bluehost and I can only transfer files at 40 kb/s

View 14 Replies View Related

Files Transfer

Jul 23, 2007

i have a backup file about 2 giga in my linux server and i want to move it to windows server what is the best and quick way?

View 3 Replies View Related

Transfer Files Between 2 Host

Jul 16, 2008

I would like to transfer a folder which contain 500 files from FTP server to another FTP server

Is' hard formeto Donwload and upload normally Is there any script which do this for me? some thing like what rapidshare.com do?

View 6 Replies View Related

Transfer Files To A New Host

Mar 3, 2008

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?

View 12 Replies View Related

Transfer Files From One Server To Another

Sep 9, 2007

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?

View 3 Replies View Related

Transfer Files From One Host To Another

Feb 18, 2007

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.

View 14 Replies View Related

Server Files Transfer

Jan 10, 2007

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.

View 4 Replies View Related

How Do I Transfer A Website Files From One Web Host To The Next

May 2, 2009

When you buy a website you have to transfer it's files to your host.how can i do that?

View 4 Replies View Related

Rsync Doesn't Want To Transfer Files

May 16, 2008

i have a client machine which requires backing up, and the server. For some reason, rsync doesn't want to transfer files...

i've already set up keys, it logs in fine without asking for password.

server config:

max connections = 2
log file = /var/log/rsync.log
timeout = 300

[backup]
comment = Rsync backups
path = /secondary/client
read only = no
list = yes
uid = nobody
gid = nobody
auth users = root

client command:
rsync -vz --recursive --progress --stats -e "ssh -i /root/.ssh/rsynckey" root@server.com:/backup/ /home/usertobackup

it keeps saying cannot find the backup folder, even thouhg it does exist on the server and is what is specified in the path above?

View 7 Replies View Related

Transfer Large Data Files

Jun 15, 2008

I have a debian box, and have archived a gallery in to a .tar file, 5.77gb.

I have a centOS box, and have used wget to bring the data file over to the new server.

However upon doing so it only detects it as 1.8gb when it starts downloading.

I have terminal access to both servers, just trying to bring my files over from one server to another.

View 4 Replies View Related

Transfer Gzipped Files From 1 Server To Another

Jun 7, 2007

Could I Transfer Gzipped Files From 1 Server to Another?

I'm in the process of changing servers, and I was wondering if there was some sort of command where I Could transfer my backups to the new server?

View 7 Replies View Related

Plesk 12.x / Linux :: 413 Request Entity Too Large - Can't Upload Backup Files With Backup Manager

Sep 17, 2014

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?

View 2 Replies View Related

How To Transfer Huge Files Without Shell Access

Feb 8, 2008

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.

View 6 Replies View Related

Fastest Way To Transfer 50gb Of Files From Old Server To New

Aug 14, 2007

what's the fastest way to transfer 50gb of files from old server to new?

I tried using cpanel's backup to transfer a backup through ftp to my new server, but it stopped at 3gb.

I just need to transfer public_html directory and everything inside it from my old to new.

I dont have physical access to my server, just root access via ssh.

View 14 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only

Feb 11, 2008

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?

View 2 Replies View Related

Backup Solutions - Compressing Partition & Transfer

Aug 6, 2008

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.

View 5 Replies View Related

Easiest Way To Replicate Account On CPanel

Mar 29, 2007

I'm in the process of updating a big account from one platform to another, and I thought of using a test site before.

What's the easiest way to replicate an account using a different domain with cPanel/WHM?

View 3 Replies View Related

Easiest Way To Park A Domain After Registration

May 9, 2007

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 a cPanel user

View 3 Replies View Related

Easiest Automation Of VPS Solutions For Hosting Provider?

Sep 20, 2008

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?

View 11 Replies View Related

DNS / Bind - Easiest Method To Redirect A Domain To Another

Jan 2, 2007

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?

View 2 Replies View Related

DNS / Bind - Easiest Method To Redirect A Domain To Another

Jan 2, 2007

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?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved