Backup Of MySQL Database To A Remote Server
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Remote Database Backup Service
I have a tiny MySQL database (10MB) and I'm looking for some remote backup service. Someting that will backup the database and let me recover it if the host is in trouble. I strongly prefer something simple and fully automated.
View Replies!
View Related
Backup BIG MySQL Database
What is the recommended method of backing up big MySQL database of size 2 GB ? Quote: # mysqldump gallery > gallery.sql mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES # I checked the table, it is fine, but can't do the backup. Quote: mysql> check table 10tir_user_group; +-------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+----------+ | gallery.10tir_user_group | check | status | OK | +-------------------------+-------+----------+----------+ 1 row in set (0.07 sec) mysql>
View Replies!
View Related
How To Backup Database (cpanel Server)
I have a crucial database (mysql). My server is running cpanel. It has daily backup but it is not enough as it is running a lot of transaction daily. I would like to run the backup to backup database only every 30 mins using cronjob. How do i do that in crontab. I have root access to the server.
View Replies!
View Related
Remote Backup Solution For Server
backup service for my dedicated server that can do the following: Take backups of the server without my laptop being involved when the backup takes place. (So I can take a vacation for two weeks and have my laptop turned off - while backups still taking place). Strangely I have found it impossible to find such a service ... All services I have looked at require my laptop is turned on and running some software while backup of server is takeing place.
View Replies!
View Related
Remote Cpanel Server Backup
i run cpanel on centos, and i backup all websites and system setting to the 2nd hd by whm's backup feature everyday, i want to ask if any script or method i can backup all the files to another server in a period of time, it may be a week or 3 three days...etc,
View Replies!
View Related
Incremental Backup Of CPanel Accounts To A Remote Server
I want to back-up accounts managed by cPanel/WebHostManager to a remote server. I want to be able to restore to any of the last 7 days. I believe doing an incremental back-up each night can accomplish this best, saving both bandwidth and disk space on the remote server. Using the back-up functionality built into WHM is appealing because WHM knows what files need to be backed up to do a full restore. However, WHM can't do exactly what I'm looking for either. I've been looking into using rsync as described in this document: [url] It looks becaue of the "hard link" capabilities of linux, rsync can be used to create what functions like a full back-up every night but requires a full backup the first day and then each day after that only the incremental changes have to be transfered. However, because I don't know what directories need to be backed up, I'm not sure how to implement an rsyc solution either. (BTW, I want to back-up everything necessary to be able to restore each account except the log files. So, that means MySQL, mail, config info, and whatever the user has uploaded)
View Replies!
View Related
Backup My Remote Dedicated Server With Centos Installed Over Ssh
i have a dedicated server with rapidswitch. Few days back all my websites stopped working, due to some reason which i was not able to solve. NOw, i want to backup all the files stored on my server. Each and every file including the database and every file there on my server. I tried to log in through ssh on filezilla but i was not able to find out all the folders. I have putty and could login over ssh , but i don't know the commands to backup. Could, you guys tell me how to get all those files on my local computer. i also have cpanel/whm installed and that is working.
View Replies!
View Related
New Server Without OS (Remote FTP Backup Server)
I just purchased a new server with 4 hotswap HDD of 250GB each and reload with new CentOS 5 without any host control panel. The purpose is to backup all my other Cpanel servers data remotely. All my Cpanel servers are fully managed servers. This is the first time i'm going to do all things by myself, so I'm really a newbie. Please don't advise me to hire a server admin because I end up learning nothing I need to learn.. 1. My first step now is to secure & harden the server. - Can anyone mind to share with me valueable knowledge of basic server security & hardening? I was also thinking to use sudo root password which my serveradmin actually did but I don't know how. But su - access level would be OK too. - I also need to install firewall and close all kind of port and block all SSH connection from all kind of IP except my server & my own IP address only. Can anyone provide me a guide? 2. Secondly what I need is to install FTPd and create user for each hard drive with 2 directory inside. /sda/server1/ /sda/server2/ /sdb/server3/ /sdb/server4/ /sdc/server5/ (reserved for future server) /sdc/server6/ (reserved for future server) /sdd/server7/ (reserved for future server) /sdd/server8/ (reserved for future server) Does anyone knows where to find documentation how do install ftpd and how to setup user pointed to the specific directory.
View Replies!
View Related
Remote Dedicated Mysql Server
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View Replies!
View Related
Move Mysql Db From Remote Server
how can i move mysql db from remote server ? (via SSH or most pratical way) suppose that... source server domain : google.com host : localhost user : zode pass : 123 db : source destination server domain : yahoo.com host : localhost user : hala pass : 456 db: target
View Replies!
View Related
Remote Mysql Server In WHM
I see option to setup remote Mysql server in WHTM but wonder can i connect 2 servers through private network then fill in Remote server address something like 192.168.1.2. If it is possible it would save me a lot of bandwidth for both servers.
View Replies!
View Related
DDos And Remote Mysql Server Two
i have two server one for running apache and second is sql server.Now come to problem. I have a very strange type of ddos attacks on my httpd server and due to these attacks my apche server failed many times (10 to 15 times)in a day. When i checked max http connection use by a single ip then i am surprised to see that my remote sql server ip is using maximum of http connections and behind this there is some other ips whose doing the same. I installed media layer it seems to work fine for me but suddenly he blocked my remote sql server ip due to using maximum http connection lolz its very strange any body please help me out of this problem.
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
PhpMyAdmin, CPanel And Remote Database
I've just purchased a second server of which I wish to use a database server for a number of my databases and I'd like manage it remotely (from the web server) via phpmyadmin. I've configured my firewall and granted access to the web server on root@webserverip and also username@webserverip (username being just one of the database accounts I wish to grant access in order to test this). Accessing mysql remotely from the webserver now works on both accounts (via ssh and php). However, having configured the phpmyadmin config file to include the ip (network ip) of the 2nd server I am unable to see the 2nd server when logged in to phpmyadmin. I just have the usual root@localhost and username@localhost.
View Replies!
View Related
Splitting VBulletin Onto 2 Servers - Remote Database
I have one server setup to power my forum and its database. It has been running from this server for a while now and as the site gets bigger i have decided i want to move the database to a seperate server. I have another server at Ecatel and wanted to know if its possible to do this, as they are in seperate datacenters.. or is it only possible between two servers on a private network in the same DC?
View Replies!
View Related
Remote Backup Or Local Backup
I would like to weight the benefits and costs of using remote backup and local backup to another hardisk? Let's assume the price is the same. What's the benefits of using remote backup? Is it secured to use local backup in another hardisk? I'm running on linux centos. What happend if hacker get hold of my server? Currently, i have 80GB of diskspace. Does it mean i will need at least 80GB of ANOTHER hardisk to backup that?
View Replies!
View Related
Remote Backup
I have a linux dedicated server and use BMU (BackMeUp) for create cpanel full backup. But this cant create remote backup for me. BMU use "ncftp" for this. and i see following error about this problem: Time: Fri May 16 03:38:17 2008 The following list of files have FAILED the md5sum comparision test. This means that the file has been changed in some way. This could be a result of an OS update or application upgrade. If the change is unexpected it should be investigated: /usr/local/bin/ncftp: FAILED So, im install "ncftp" manually, but issue not resolved and i havent remote ftp backup too! How can resolve this issue? BMU Refrence: [url]
View Replies!
View Related
What Exactly Is Remote Backup?
What exactly do you do when you take a remote backup through resync? For instance, if i signed up with say bqbackup and started resyncing and taking backups, would i be copying all the data from my server to the remote server or is it possible only to copy the cpanel backups made daily/monthly/weekly to the remote space? Also, when the resync runs everyday, does it replace the old files or does it create a new copy of everything that has changed?
View Replies!
View Related
Phpmyadmin Large Database Backup
I have a large database 800MB and the export zip & gzip option does not work on this size database export. works fine on upto 30MB table sizes, does phpmyadmin not support large table export/backup using gzip or zip? If its the case that i should be able to use the zip options then what would i look for to put this problem right? if its the case large table databases are not supported what could i use instead to backup the database tables with compression (gzip)?
View Replies!
View Related
Looking For Remote Backup Space
first of all i don't know where to post this, so if this is in the wrong section, any mod can move it to the right section . what i need is, trusted remote backup space for websites. i googled and found many, but i would love to know who is trusted and who isn't . i don't need massive space, around 10-15 GB and about 100 GB monthly traffic .
View Replies!
View Related
Remote CPanel Backup
What's the best way to do a remote backup? Right now I have them all being backed up to a 2nd drive on the server. If I do a remote backup, is it just as easy to access the files and do a restore?
View Replies!
View Related
Remote Backup Alternative
I am using BQbackup since 10 months ago without problems. But in the last 6 days the transference rate is very slow (3kB/s). I already sent some emails to Scott but I dont receive a reply. So I need to have a look in other alternative to store my backups.
View Replies!
View Related
Remote Backup Biz
I have already developed shell scripts to automate account management, add/delete users, change quota, passwords etc. I am now working on web interface which will be used for managing the accounts, testing some free scripts and writing tutorials. So far, my scripts can create chrooted (jailed) accounts with some basic shell commands. The same disk space is also configured in samba and rsync daemon. Customers can use ssh/sftp or simply mount it as a network drive. Free utilities for Windows users (like deltacopy) work just fine with rsync daemon. Script can also modify iptables-based firewall and allow only certain IPs to access the server but I am still working on that part. It takes about 10 seconds to create a new account and I have tested it on CentOS server.
View Replies!
View Related
Backup To Remote Ftp
I'm thinking about buying a shared hosting plan with lots of space. Anyone do backups to remote ftp server instead of rsync? I was wondering if it was possible to configure ftp in such a way to only transfer files that are NOT present on the remote ftp. This way, it doesn't overwrite existing files and thus save on bandwidth. Is it possible to transfer an entire folder with a ftp command, I know the mput command is for uploading multiple files to another location. Lastly, what are the advantages of rsync over ftp besides saving banddwidth and trannsferring only files that were changed?
View Replies!
View Related
WHM Remote Backup
I noticed that when "WHM Remote Backup" backs up my websites via ftp, the tar.fz archives are incomplete, meaning the backup is pretty much useless. I have tried with both PASV on and off and it still persists. Any ideas why? Also, what is the command to force the whm remote backup to run?
View Replies!
View Related
Remote Backup Implementation.
I've been exploring two possibilities. 1) Have a backup server in the same physical location as the main servers. Then have automated backups occur, through a local network. The benefits of this are obviously a) No bandwidth fee's b) Total control over data instead of relying upon a third party c) Faster transfer speeds. However, that doesn't really help when it comes to disaster recovery etc, so, some sort of remote solution would probably be best. 2) Have a remote server in a different datacentre. There's two ways of doing this, either by renting a server in an a different datacentre, and having remote backups that way (probably with Rsync), OR paying for some third party service. I'd be interested in your input on what you think would work best and be most cost effective.
View Replies!
View Related
Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database
In previous thread we made few manual transfer of our domains. We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature. All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
View Replies!
View Related
Backup For My Database To Move From Hostmonster But I Can’t
I just want to move from hostmonster to dedicated server the problem is the database(vbulletin) size about 1 GB when I try make backup for it through ssh it arraive to 723 MB then stop becuase it have highload on hostmonster system they not allowed more than 20% cpu I take to them they tell me can’t do any thing I please them make backup but they say we can’t do any thing for you and I’m sure they can log by root and do it with ssh on less than 1 minute how can I make backup or if there r way to move the database to the new server 2 day ago and I can’t move to the new server
View Replies!
View Related
R1soft Remote Backup Provider
I have recently had to set up all my backups again (add me to the ranks of disappointed bqinternet customers). I choose to go with Handy Networks - and I am SO very happy I did. The got all my servers set up quickly and correctly, but the most impressive thing was the communication - it is one of the best support experiences I have had in this industry. Not only on the initial set up, but even the questions i had afterward - they went above and beyond in their answers. I know companies get ripped all the time on here for bad support - just wanted to give a little praise!
View Replies!
View Related
CPanel Automated Backup Is NOT Backuping One Big Database
i recently find out that I don;t have an database backup for one of my biggest websites. The database I'm talking about has 228 tables (198.6 MB) In the backup file I only get this : -- MySQL dump 10.11 -- -- Host: localhost Database: lxxxxxxa_sXXXl -- ------------------------------------------------------ -- Server version5.0.45-community-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; The other databases I have tried are all ok, but none is this big. Is there any size limit ? I have uploaded an printscreen with the setings of my WHM.
View Replies!
View Related
Remote Backup- Security In Canada / Usa
I was thinking of starting service provider of online backup service located in USA the data is stored in a vault (off site server) Data replicated to another server at a another location. Critical data is 128-bit encrypted, compressed, and then uploaded to a REMOTE server hosted by my company via Secure Sockets Layer (SSL) with enhanced security. The client chooses what kind of encryption they want to use and they choose their Password (I don't have access to this info) With out their password they can NOT restore their information back Lose the password and the Data can not be restored its loss I have no idea what the passwords are. Now all the info will be stored on this server The question that comes to mind if the USA Government wanted to look for any information located in this storage server Can they force the clients to give them access to this data ? Talking to someone at storage pipe.com He was saying that in Canada this info is protected and can not accessed by law He was saying a lot of company's because of this are looking for off site storage in Canada because of this issue. So from what I can understand if the storage server is located in the USA if the Government wants to look at the files they will force the clients to provide them access to these fies either by asking or by court order But in Canada this not an option the files are protected by Law Now a lawyer I am not be it seems that if the company has nothing to hide it will not be and issue. But like I said I have no idea what people or company's are backing up. It can be anything! All I do is store the backup data. All I know is the amount(size) of Data stored on the server. The last thing I need is people banging on my door asking me to access these files. Now if I had my server located in Canada they would be protected by law.?
View Replies!
View Related
Restoring SQL Database Backup To Invision Power Board
I moved my site to a new host and am running IPB 1.3 forums, I have a 62meg sql backup to restore. I have tried using BIGDUMP.php as max upload is over 52megs. No Joy! I also tried zipping the file, got it down to 9megs, It wont complete the upload in PhpMyAdmin? I have not had to restore a back up before, and am really struggling.
View Replies!
View Related
Mass Backup Accounts To Remote FTP With ROOT Access And CPanel/WH
I have a VPS and about 140 accounts on it. I've also got cPanel and WHM installed. I'm moving to a new host, but the thought of having to move all these accounts manually really makes me lazy I have to go into each account and go to backup -> backup to remote FTP, and yeah.. Is there any way I can mass backup all of my accounts, or all accounts I select, to a specified FTP server? I only have root access on my VPS, but not on the server I'm moving all the backups to..
View Replies!
View Related
|
TRACKER
