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