Web Server - File And MySQL Backups

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


ADVERTISEMENT

ERROR! MySQL Manager Or Server PID File Could Not Be Found

Feb 14, 2008

Recently,Mysql has been a problem that is going down.So,I have to restart Mysql Service everyday. You can see for further information at here

Quote:

ERROR

Couldn't connect to database.
Please contact admin about this err. Back

DETAIL
2002 : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

This is the error when i restart Mysql Service via SSH

Quote:

ERROR! MySQL manager or server PID file could not be found!
Starting MySQL SUCCESS!

what i should do and give me a solution to kill this error

View 2 Replies View Related

Free File Storage Service That Can Be Used For Backups

Mar 19, 2009

file storage service that can be used for backups and allows FTP access.

Do you know of any reliable service that also offers a free account?

View 6 Replies View Related

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 View Related

MySQL Nightly Backups

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

Corrupted MySQL Backups CPanel

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

Plesk 12.x / Linux :: Downloading Backups To Local Computer - Save File In TAR Format?

Jul 27, 2014

If I try to download a plesk backup to my local machine it saves a file a few bytes in size in .xml.tar.html format

My other non plesk 12 machines correctly save the file in .tar format ....

View 11 Replies View Related

Mysql Cannot Create File In /tmp

Feb 3, 2008

I always have this error with mysql

Can't create/write to file '/tmp/#sql_7042_0.MYI' (Errcode: 13)

the /tmp has been chmoded 1777. I installed mysql downloaded from rpm on www.mysql.com, version 5.0.51a 64bits for CentOS-5

View 9 Replies View Related

Mysql: Incorrect Key File For Table

Apr 20, 2009

I have a server with many db on mysql 5

Any db contains 5 table with data

This data is processed by routine

Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"

The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..

View 1 Replies View Related

MYSQL Incorrect Key File For Table

Jul 3, 2008

what I can do about the following database error in mysql?

Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it

I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.

View 5 Replies View Related

Mysql Open File Limit

Aug 14, 2008

I am trying to increase my open file limit on my CentOS release 4.6 VPS.

I have tried modifying my /etc/security/limits.conf with the following:
@mysql soft nofile 4096
@mysql hard nofile 4096
@mysql soft sigpending 4096
@mysql hard sigpending 4096

Even is a mannual set it with "ulimit -n 4096 mysql" it will not stick.

Any ideas what I can do to get this limit increased permanently?

View 7 Replies View Related

How To Import Mysql Dump File To Database By SSH

May 19, 2009

How to import mysql dump file to database by SSH?

How to import mysql database host to other host database by SSH?

View 4 Replies View Related

Is It Possible To Export The MYSQL DB From An Hypervm Backup File

Jun 10, 2009

Is it possible to export the MYSQL DB from an Hypervm backup file?

If possible,how to?

As I fail several times to restore it in Hypervm.

View 9 Replies View Related

MySQL Error: Can't Create/write To File '/dev/shm/MYxQT8lz'

May 19, 2008

one of my site shows this error

MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'

I checked space on the server is still 25 GB free,

View 1 Replies View Related

Backups Are Killng My Server

Dec 7, 2007

Opt 248
3gb ram
250gb sata II

My server runs great 95% of the time. Loads average under 1. However backups have become a server killer. I use cpanel scheduled backup at early morning hours. The reason backups kill my server is that I have 300,000+ (and counting) images in a directory. They are all small pngs generated by LaTeX. It takes my server several hours to backup the images. I usually even have to stop apache to free up some power. This problem is only going to get worse as I get more images. Maybe I could upgrade proc or upgrade to faster HD? That would be costly, hopefully not.

Should I hire a professional backup service? Costly, and would that help? Or is there a way of storing the images or doing the cpbackup I am doing wrong?

View 6 Replies View Related

Backups Killing My Server

Dec 7, 2007

Opt 248
3gb ram
250gb sata II

I have a fairly unique problem. My server runs great 95% of the time. Loads average under 1. However backups have become a server killer. I use cpanel scheduled backup at early morning hours. The reason backups kill my server is that I have 300,000+ (and counting) images in a directory. They are all small pngs generated by LaTeX. It takes my server several hours to backup the images. I usually even have to stop apache to free up some power. This problem is only going to get worse as I get more images. Maybe I could upgrade proc or upgrade to faster HD? That would be costly, hopefully not.

Should I hire a professional backup service? Costly, and would that help? Or is there a way of storing the images or doing the cpbackup I am doing wrong?

View 3 Replies View Related

Cheap Dedicated Server/vps For Backups

Jul 11, 2008

All I need is to host 20-40 GB of backups. I need full ssh access so I'm only interested in dedicated or vp servers. The best I could find today was celeron 1.3 ghz, 40 GB server for $27/mo. (paid quarterly).

View 13 Replies View Related

Server Path(s) For Backups With Whm/cpanel

Mar 9, 2008

Anyone know the server path(s) for backups with whm/cpanel?

I'm talking about the backups that are kept for sites where they can be downloaded via web from cpanel. (daily, weekly, monthly)

View 3 Replies View Related

Set Windows Server To Download Backups

Feb 25, 2007

I was wondering if i could use my windows dedicated server to download backups from my website on a daily basis? Maybe with a cron job or something...

Heres the setup:

Dedicated Server with windows 2003 - Want to use for downloading backups

Shared Server hosting my website with cpanel - Want to make backups of

View 0 Replies View Related

Backups On Apache Web Server Nodes

Jun 18, 2015

I have set up a backup node in PPA, and set it to be ready to provide, however backup tasks are saving the backups to the apache web server nodes? How do I find the cause of this?

View 6 Replies View Related

Cheap Server With 100Mbit For Remote Backups

Mar 23, 2008

cheap dedicated server for remote backups with at least 200GB hard drive and 100Mbps up/down connection and 1000GB transfer. It would be the best to be in US, but it can also be in Europe if speed from US can be at least 60Mbps.

The best I found is Hetzner (49 eur), but they are in Europe and they have a 99 eur setup fee which is too much for me.

It would be great that it's even cheaper than this, because this Hetzner server have a dual core AMD 5600+ CPU, 2x400GB HDD and 2GB of RAM, so because I don't need all that I was hoping to find even cheaper Celeron or Sempron with 200GB HDD and 512MB or 1GB of RAM in US.

View 14 Replies View Related







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