Mysql Automated Backups
May 18, 2009
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.
View 1 Replies
ADVERTISEMENT
May 20, 2009
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?
View 10 Replies
View Related
Jun 8, 2009
I'm used to operating dedicated servers. This year I want to venture into getting a reseller account and / or media temple account.
With my dedicated servers, I do automated mysql dumps and I do nightly rsyncs of all my /home /etc and other important data so disaster recovery is possible.
My question is, how do you do the same thing? Sleep well at night? with these regular web hosting accounts?
I see most newbie people who pay for web hosting do not bother to backup their data. Ignorance is bliss until disaster strikes.
How do you automatically backup your data (mysql and directories) in your multiple web hosting accounts like reseller or grid service media temple?
View 5 Replies
View Related
May 12, 2008
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.
View 3 Replies
View Related
Mar 2, 2009
how to achieve the following:
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?
View 4 Replies
View Related
Mar 18, 2008
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.
View 8 Replies
View Related
Mar 5, 2009
Which VPS providers offer automated OS reloads for their clients?
View 14 Replies
View Related
May 18, 2009
I run my own Mail Server.
Everytime I create a new website account in WHM I am required to go in and manually edit the DNS record to include the MX record of my mail server.
I would like to streamline the process and need a way to make WHM automatically include my MX records every time I create a new account. Is this possible?
View 2 Replies
View Related
Sep 17, 2008
MPORTANT: Do not ignore this email.
The hostname (server.mydomain.com) resolves to . It should resolve to xx.xx.xxx.xx. Please be sure to correct /etc/hosts as well as the 'A' entry in zone file for the domain.
Some are all of these problems can be caused by
/etc/resolv.conf being setup incorrectly. Please check this file if you
believe everything else is correct.
You may be able to
automaticly correct this problem by using the ' Add an A entry for your
hostname ' under ' Dns Functions ' in your Web Host Manager
View 7 Replies
View Related
Dec 19, 2008
I have a few questions about backup. Other than any backup service provided by your host, do you backup your vps regularly?
Is it automated or manual?
Are you using any external backup service / server?
View 9 Replies
View Related
Apr 23, 2007
Is there a way to automate the generation and FTP of home directory backups in Cpanel?
CPanel lets you create a full account backup and ftp's the result to another server but can only be done manually from what i understand. Is there a way to initiate the process automatically? maybe schedule it for once a week.
View 3 Replies
View Related
Feb 25, 2015
Are there any providers out there can be integrated with Plesk so that DNS zones for all vhosts are automatically propagated on the secondary DNS service?
I've asked DNS Made Easy but they advised that the domain has to be set up manually with them first.
View 3 Replies
View Related
Nov 13, 2008
I run an online music archive site . Djs can upload their mixes to share and we also archive radio shows for people to listen back to.
Basically I was wondering if it would be possible to build a secondary server that could do this for me.
The secondary server could have multiple cast rippers running and could record internet radio shows, then once finished recording transfer it could send them over to my primary server to add to the website for people to download.
View 7 Replies
View Related
May 2, 2008
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 2 Replies
View Related
Mar 14, 2008
I have a centos server & whenever I reboot it, it goes into File System check and takes about 1 hr to turn online.
The irony is, I reboot the server only when the load goes high (esp when traffic is high).. And the server is down for long times when traffic is high.
The server config is pretty good, but it shows these problems once in 15-20 days.
View 3 Replies
View Related
Nov 17, 2014
I am using a Linux server together with Parallels v10.31 ... Unfortunately I get little or no real support from my host so and if I do it's cryptic.
I have been getting a large amount of emails from my server [hundreds daily].
I have attached a screen grab indicating type of email being sent.
I have created only one cron job and that was to reset the RAM on a regular base.
Also is it safe to update to the latest version without a major disaster happening....
View 1 Replies
View Related
Jul 4, 2008
I found this useful script to get backup in plesk:
http://www.web-hosting-control-panel...kup/gfx_backup ...
View 3 Replies
View Related
Jul 1, 2008
Just wondering, since it appears to be hard to come by, but are there any providers that offer the option to use an automated system in order to provision new licenses for cPanel (or others?)
For example, you're setting up a VPS in the middle of the night, customer wants cPanel. You can't use the trial licenses via cpanel.net since they limit you to 3-4.
If your provider has an automatic API to bill and provision your license, you're good to go. If you don't...
Options? I'm mainly looking in Montreal (I know of Netelligent and Iweb, but both are manual povisioning).
It's not a make-or-break thing, but something nice to have.
View 2 Replies
View Related
May 8, 2014
It has been bought to my attention during our upgrade planning, that PPA & Plesk Panel do not offer the functionality for setting up a backup MX servers. In our current configuration we use Sendmail as both secondary and tertiary MX servers. These are manually configured and prone to configuration mistakes.
Multiple scenarios need to be taken into consideration.
Scenario 1: Hosters Plesk hosted primary mail server + secondary & tertiary mail servers.
Scenario 2: Client hosted primary mail server + hosters secondary & tertiary mail servers.
I am looking for alternate ways for backup / secondary MX servers for our planned PPA / Plesk deployment. An automated solution would be ideal, but we are falling short trying to find a solution to streamline the process and remove margin for error.
View 1 Replies
View Related
Oct 21, 2014
I'm trying to redirect users to database/mail management pages with automatic login link, while logging in part works ok, I have issues with redirections.
Plesk is installed on different server than my site, and if I try to use "success_redirect_url" param in link url, it will show this error "Original link and target URL should be on the same domain."
It works ok if I prevent browser from sending http referrer to plesk, but I'm not sure if it will work for all user as this depends on their browser.
Is this a bug? Is there a workaround that would not depend on used browser?
View 14 Replies
View Related
Mar 15, 2007
I wanted to know which one do you prefer these 2.
1.) Personalized hosting with custom made packages
Support via IMs, PMs & Emails. "Feel at home"
2.) Automated hosting & pre-made packages.
Support via inefficient "live help" operators who have the same answer - "Your support request has been forwarded to a higher authority" . No interaction with the owner & the "professional feel"
I like no. 1 & thus I provide hosting on the same principles.
So which one do you prefer, & if you are a host, which one do you incorporate?
View 1 Replies
View Related
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
Jan 21, 2007
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?
View 1 Replies
View Related
Oct 25, 2009
In WHM I set my backups to go to the / directory in a flder called backup. This filled up rather quick and that partiton is now full!
I was going to change the location to /home as i have over 400GB of space here but it says: Setting this to /home is a very bad idea.)
View 8 Replies
View Related
Jul 29, 2008
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.
View 4 Replies
View Related
