Databases Backup ? (Rsync)
I am using bqinternet.com to backup (Rsync) some accounts.
I sent them a ticket before 2 days and didn't get any reply.
I used this command to schedule a remote backup for specific accounts:
Code:
echo "30 6 * * * root rsync -avz -e ssh ~account1 ~account2 ~account3 myuser@myuser.bqbackup.comerver" >> /etc/crontab
But, I found this command will backup only files.
How can I backup also databases?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
How Do You Backup Your Databases
So your host keeps at least a daily backup of your database, but if you don't get to the backup in time, you may find that they have a backup of a crashed database. That means its important to have a procedure for getting regular backups by other means too. How are you doing this?
View Replies!
View Related
Backup MySQL Databases On PC
I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC? I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.
View Replies!
View Related
Backup And Restore Mysql Databases
I have a corrupted VPS, and have some mysql databases on it. I want to backup databases and restore them on the new server. Cpanel service is down on the vps and I cannot transfer accts. Is it possible to do so ? 1- Zip or Tar the username folder in /home dir. 2- zip or tar the database name in /var/lib/mysql folder Either by SSH or File manager trough HyperVM Then transfer files some where safe... When vps is rebuilt, restore the archives and databases to the folders I have backed up before rebuilt. There are also some accounts on a terminated vps that there is only an image of the vps available so, I only can tar files using a jailed shell account, move to the new vps and untar them. how to do it and avoid database problems.
View Replies!
View Related
MySQL Backup Multiple Databases
My site is databases driven and runs on around 15 mySQL databases. Im wanting to download a local copy of these databases daily, however, if i try and back them up via cPanel (on a WHM VPS) they give me blank files. Each databases is around 55mb and growing. I can back them up one by one via phpmyadmin, it just takes around 5 minutes per database. Meaning around 40 minutes per night.. Is there any solution for having a script downloading them automatically so i can download them via ftp? I've tried [url].htm but it gives me blank files.
View Replies!
View Related
Backup MySQL Databases By Cron
how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working. Change the commented variables in the following file and save it as backup.sh: Code: #!/bin/sh # This script will backup one or more mySQL databases # and then optionally email them and/or FTP them # This script will create a different backup file for each database by day of the week # i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1) # This is a trick so that you never have more than 7 days worth of backups on your FTP server. # as the weeks rotate, the files from the same day of the prev week are overwritten. #/bin/sh /home/user/directory/scriptname.sh > /dev/null ############################################################ #===> site-specific variables - customize for your site # List all of the MySQL databases that you want to backup in here, # each seperated by a space # If not run by root, only one db per script instance databases="mydbname" # Directory where you want the backup files to be placed backupdir=/home/mydomain/backups # MySQL dump command, use the full path name here mysqldumpcmd=/usr/bin/mysqldump # MySQL Username and password userpassword=" --user=myuser --password=mypasswd" # MySQL dump options dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables" # Unix Commands gzip=/bin/gzip uuencode=/usr/bin/uuencode mail=/bin/mail # Send Backup? Would you like the backup emailed to you? # Set to "y" if you do sendbackup="n" subject="mySQL Backup" mailto="me@mydomain.com" #===> site-specific variables for FTP ftpbackup="y" ftpserver="myftpserver.com" ftpuser="myftpuser" ftppasswd="myftppasswd" # If you are keeping the backups in a subdir to your FTP root ftpdir="forums" #===> END site-specific variables - customize for your site ############################################################ # Get the Day of the Week (0-6) # This allows to save one backup for each day of the week # Just alter the date command if you want to use a timestamp DOW=`date +%w` # Create our backup directory if not already there mkdir -p ${backupdir} if [ ! -d ${backupdir} ] then echo "Not a directory: ${backupdir}" exit 1 fi # Dump all of our databases echo "Dumping MySQL Databases" for database in $databases do $mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql done # Compress all of our backup files echo "Compressing Dump Files" for database in $databases do rm -f ${backupdir}/${DOW}-${database}.sql.gz $gzip ${backupdir}/${DOW}-${database}.sql done # Send the backups via email if [ $sendbackup = "y" ] then for database in $databases do $uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu $mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu done fi # FTP it to the off-site server echo "FTP file to $ftpserver FTP server" if [ $ftpbackup = "y" ] then for database in $databases do echo "==> ${backupdir}/${DOW}-${database}.sql.gz" ftp -n $ftpserver <<EOF user $ftpuser $ftppasswd bin prompt cd $ftpdir lcd ${backupdir} put ${DOW}-${database}.sql.gz quit EOF done fi # And we're done ls -l ${backupdir} echo "Dump Complete!" exit Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone . You should chmod the file to 777: Code: chmod 777 backup.sh If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory: Code: dos2unix backup.sh If you don't have dos2unix installed, you can install it using yum if you have that: Code: yum install dos2unix If you don't have yum, get it here. You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command: Code: ./backup.sh Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is: Code: /path/to/file/backup.sh
View Replies!
View Related
How To Backup To Your PC Using Rsync
I use bqbackup.com in addition to ServInt's backup. The ServInt backup is inaccessible to me and can be restored only by their NoC. Is there a way for me to download the backup files from bqbackup.com to my PC? I am using Win XP Pro. I backup the entire VPS, but I want to be downloading only the changes made each day after the initial download to my PC.
View Replies!
View Related
Rsync / Backup
I am setting up a mirror server to kick on in the event my main server fails and I need some help with syncing the two. It is my understanding I can use rsync to mirror the two. But, will that cover everything (ie. database, mail, etc) or only files?
View Replies!
View Related
Rsync Backup
I am using rsync to database and i found out it corrupted my database. I should have used mysql dump before backing up the data..The problem with taking mysql dump each is that it takes a long time and resources as database is around 10 GB if i want to take backups every 4 hour, whats the best way as mysql dump causes server load problem
View Replies!
View Related
So I Do An RSync Backup - How Do I Restore It?
Backing up a server is obviously very important. Lets say I do a daily rSync backup and eventually my server HDD crashes, I know it isn't just a 'one click' job to restore my backup but what is it necessary to do in order to carry out a complete and effective restore back to how it was? A step-by-step 'tutorial' on restoring an rSync backup would be helpful not just to me but to many 'would-be' server administrators.
View Replies!
View Related
Rsync Backup Related
Currently I am using rsync to backup directory and mysqldump sql file on both external and internal backup drive Now the directory has around 100,000 files that hardly change. Only thing that happens in that directory is either the old files are deleted or new files are added. All of them image Due to some reason when i rsync using any of the two commands below, it transfer each and every file again rather then transferring the new or updated files. Here is what i am currently using rsync -avH /old/path /destination/path (this is for internal backup drive) or rsync -avz -e ssh /old/path username@username.remoteaddress:/destination/path why all my files in the directory all uploaded again
View Replies!
View Related
Using Rsync To Backup An Entire Server
The backup program (cpbackup) that comes with WHM/Cpanel is not ideal for our current situation. We have lots of third party applications installed on our server along with many customized configuration files. We need a solution that will backup everything and allow for fairly simple restoration. How viable is rsync for full server backups? Can it handle 100 GB of data? More importantly, how would you restore the backup to a new server? If the new server already has an OS the restored files would break the system, right?
View Replies!
View Related
Rsync Backup - User Permissions
I have a problem with my rsync backup First of all my setup is thus: I have a Linux box at the office which has an rsync cron on it which pulls from my web server as a backup. It pulls websites, mysql, conf files etc. My web server is running debian etch LAMP etc. When I originally set it up I used root user to log into the web server, and setup keys to authenticate, this worked perfectly. I then decided that having direct root access to the web server was a bad thing so I have turned off root login (PermitRootLogin no in sshd_config) I then setup a backup user which works fine for the website files but fails on permissions for the mysql data files (/var/lib/mysql) How can I get over this without granting root access to the backup user which would defeat the object of not allowing root access. I have been told about host authentication based on ip address but I have dynamic address at the office so that would be no good
View Replies!
View Related
SSH, Rsync And Offsite Backup
I have a VPS with remote backup that I dod every night with rsync. Now, for further SEO testing, Im looking into a reseller account. Some reseller plan do offer access via SSH. Im not familiar with this ssh access for a reseller. Would I still be able to program a cpanel backup and then rsync all my cpanel backup ?
View Replies!
View Related
Rsync Backup To NAS Via FTP
I just signed up with Rsync Palace for remote backups 2 days ago. Otto and Darin at Rsync Palace gladly helped me out and actually ended up setting me up for free. It's really an inexpensive price to pay for a little additional piece of mind to have a remote backup. I have a VPS with cPanel that has NAS on a private network. The way they set it up was for Cpanel cron job to create backups of my VPS and place the backups in a /backup folder off root; Daily, Weekly and Monthly. Then they have Rsync via cron set up to take those backups to the remote Rsync Palace server daily. I still want to maintain backups on my NAS in the datacenter. (cPanel will only backup remotely or locally, but not both.) In addition to Rsync securely transferring my data to Rsync Palace for offsite backups... How can I set up Rsync to ftp the same /backup data across the private network to the NAS? (Only ftp is available via the NAS.)
View Replies!
View Related
Offsite Backups (via Rsync) - What Files/folders To Backup
I'm currently using (amongst other backup systems) rsync to an offsite space (am using BQBackup at the moment) I'm just wondering - apart from backing up all of /home/, /var/lib/mysql/ and the important config files (httpd.conf, php.conf, etc etc) is there anything else that *needs* to be backed up? Obviously in a worst case scenario, a new machine would be deployed with a fresh OS install (and a fresh WHM/cPanel install) so I wouldn't worry about backing up OS files or cPanel core files, although I'm wondering if there's anything apart from the /home/ directory and the MySQL databases which would be lost (and so need backing up) in the event of a crash?
View Replies!
View Related
Daily Backup + Rsync Ssh + Large Number Of Files
i just wana know is it safe to do remote daily backup for about 70,000 files? file sizes is about 200kb and every day i have about 1000 new file, so rsync first should check old files becouse i am deleting about 30-50 of them daily and them backup new 1000 files , so how much it will take every time to compare that 70,000 files? i have 2 option now: 1-using second hdd and raid 1 2-using rsync and backuping to my second server , so i can save about $70 each month.
View Replies!
View Related
UNLIMITED Databases
Do u want to run an online e-commerce store? create a forum? or develop the next facebook or myspace? If you answered yes to any of th questions then there are very important factors you need to consider before choosing a host. You have to understand that there's a difference between Database and database size. UNLIMITED database means that you have as many databases as you want, but of what use is an unlimited database if the disk size for the database is just 50MB for example. Don't be deceived by the number of database a web host company is willing to chun out. Do a little research, ask questions. Afterall you might not need an unlimited database afterall.
View Replies!
View Related
Setting Up Databases
Does anyone know anything about how to set up a mysql database? I installed this script for a gallery for wordpress but it won't create it's own databases. I already set one up myself but Im still getting this error: Quote: SELECT * FROM wp_fim_cat ORDER BY date DESC Is there something Im supposed to add inside each database table? And how do I add it to make it work?
View Replies!
View Related
Visualizing MySQL Databases
I've recently been asked to do a lot of data extraction from a state that has about 20 databases, each with between 10 and 100 tables. I often find myself diagramming things out on paper to try to visualize how everything works together. I wondered if there's a tool that would "draw" the tables, columns, and relationships? I hesitate to say this, but almost like how MS Access does it, but that runs on Linux and does MySQL. Is there such a thing? I know about phpMyAdmin and MySQL's Query Browser, but it's not what I'm looking for.
View Replies!
View Related
MS Access Databases On Server
My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
View Replies!
View Related
Is There A Way To Search Through MySQL Databases
I am running a dedicated server with Debian, and I installed a community sofware that has a lot of mySQL entries, many of which need to be changed to fit my needs However, it is very hard to know exactly where each value I need to change is stored. Is there a way to search all database tables for a specific value? For example, one thing that is stored in the database is the site's title displayed in the browser's title bar. The sofware does not give me the option to change it, so I have to find where it is located in the database and change it myself, but it would be extremely time comsuming to check all tables one by one for any occurences of the current title.
View Replies!
View Related
Are My MySQL Databases Hosed
My HD was failing. So ServerBeach quickly set me up with a fresh box with the dying drive installed as a secondary drive. (nice job guys) I'm able to mount the secondary drive and browse/copy the files... but when I get to the most important files of all, the database binaries, my /var/lib dir looks like this: Code: [root@rosemary v2]# ls -l /mnt/dying/var/lib/ total 68 ... .... -rw-r--r-- 1 root root 2171 Sep 14 03:02 logrotate.status drwxrwsr-x 6 root 41 4096 Oct 12 2005 mailman drwxr-xr-x 2 root root 4096 Oct 12 2005 misc ?--------- ? ? ? ? ? mysql drwxr-xr-x 4 root root 4096 Oct 12 2005 nfs drwxr-xr-x 2 ntp ntp 4096 Sep 14 10:31 ntp ... ... And if I try to cd into the dir, I get this: Code: [root@rosemary v2]# cd /mnt/dying/var/lib/mysql -bash: cd: /mnt/dying/var/lib/mysql: Input/output error I really *really* need this data! Am I just totally S.O.L. ?
View Replies!
View Related
How To Delete Databases Or Reset CPanel
I've been running a forum for a while now which of course had a database. Now I sold the vBulletin License and I'd like to delete the database that was created for it. How do I do that? I've looked throught cPanel, but couldn't find an option on deleting a whole database. Might be looking in the wrong sections or something. Can someone help me out? It would be even better if it is possible to reset my whole server throught cPanel. Is this possible?
View Replies!
View Related
SQL 2000 Databases Hacked
Recently I have noticed at least a couple of SQL 2000 databses hacked in different servers. The hacker inserts a javascript code whose source is [url] file. The code is inserted in all records of some tables especially the tables having html code in the records. We are running SQL 2000 on some unused port and not the default port and also we have firewalls enabled in all the servers. We also have the latest updates and fixes applied in the servers. Can anybody throw some light on this and help me find the cause and solution to prevent this from happening again?
View Replies!
View Related
Make Backups Of HyperVM Databases
I have one server with 500GB disks. The server is running HyperVM. My secundary backup disk is mounted /backup. In the main node I installed ProFTPd and I'm already making backups of cPanel coming trough a VPS hosted on that server. And I would like that all backups made by users or Automated Backups made by HyperVM would go to /backup, so I done this: 1) I would like to make backups of HyperVM databases. I done this: [url] Is this correct? 2) I went to Home/Central BackupServers and added: [url] Is this correct? 3) Then I went to Servers/localhost/Central Backup Config and selected 127.0.0.1 from the list. [url] Is this correct? Is only this I need to do to make my backups? Is there anything left? If disk one fails will I be able to restore the server after reinstalling HyperVM?
View Replies!
View Related
Uploading SQL Databases By FTP
we have been trying to import sql databases through cpanel. The old server the client was on did not have any control panel. While the new server the client is migrating to, has cpanel. We try importing sql databases through cpanel, but because the sql databases are so large in size, they corrupt while importing them. The client's old server he would be able to access all his sql databases through FTP. While with this new cpanel server, we can't upload sql databases by FTP. We are wanting to use FTP because when using cpanel, the sql databases corrupt. So is there anyway to upload sql databases with FTP directly into mysql when using cpanel server?
View Replies!
View Related
Cron Job With Multiple Databases
I have several DBs and need to run a cron job on one of the databases every night. to run a repair/optimize on the DB as its very active, this is the command I thought I would use: Code: REPAIR TABLE `etc` , `etc` , Code: OPTIMIZE TABLE `etc` , `etc` , How do I specify which database to run this on in the cron in CPanel?
View Replies!
View Related
Large MSSQL Databases And Harddrives
I have two servers which both run (very) large databases. To put that into context, one has about 40,000,000 database entries whilst the other has around 100,000,000. These both currently run on 250GB SATA-II's. I'm considering adding a 147GB SA-SCSI 15k in replace for the 250GB SATA-II's for the live databases. Would this be beneficial? I've no experience with faster speeded HDD's - especially on servers. Reason I ask is I have some web applications which access these databases and can often take a while (minutes) to look up data.
View Replies!
View Related
How Many SQL Server Databases Your Site Uses
I would like to build a personal website powered by a content management system and I'm wondering: How many SQL Server databases a site requires? At the Godaddy.com site, the plans for Windows offer one, two or three SQL databases and at least 10 MySQL databases. The integration with MySQL is easy?
View Replies!
View Related
How To Check Which Mysql Databases Cause Server Load
How can i check (using SSH) which databases/users cause server load to mysql ? I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ? I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.
View Replies!
View Related
Configuring Server To Handle Both MySQL And MS Access Databases
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus. Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time? I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right? If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access. Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View Replies!
View Related
Change Databases Password Wihout Effecting Users
my server has just compromised and someone can retrieve all databases on server with my root sql password. i changed the root sql password to avoid attacking again and want to ask a question...do i have to change all user's databases password too? many users have wordpress, forum and other php scripts with config file contains current database password.If i change their pass their sites will stop working. How to do this without bothering users?
View Replies!
View Related
UK Media Hosting (mp3/avi) - No Databases Or Php
I have most of my sites on the very reliable clook.co.uk but I only only get around a Gig of bandwidth per month per site. I'm thinking of getting an unlimited hosting package so I could upload client's music files, large images, video clips etc.. Nothing is illegal or adult. Then I could host my sites as normal at Clook and then point to all the very large files being hosted at the new place. I think I'd get about 10Gig of traffic max a month. And as it'll just be an extended online harddrive I've no real need for databases, email, php, cPanel etc... I've seen some unlimited offers at hostpapa.co.uk for 4.99 a month with a free domain. Is there a catch? What do you recommend?
View Replies!
View Related
Updating Access Databases On Local Web Server
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases. The two errors I get are: Operation must use an updateable query. or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!) Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
View Replies!
View Related
How To Configure Mysql To Hold Your Databases On Another Partition On Hard Drive
I have a server that is running linux with cpanel and I am running out of space on a partition. I was getting this error: Drive Warning: /dev/sda3 (/var) is 83% full I looked in the folder and went to /var/lib/mysql and noticed that I have about 6 databases that are a little over 1 GB each. The sda3 partition only has a capacity for 9.9 GB and I was suggested to configure mysql to hold my databases on another partition that has more space..
View Replies!
View Related
|
TRACKER
