0
votes
2answers
60 views

What is the best/most secure way to download/send/keep offline backups?

I have a small app that uses MySQL. I'm on a small Ubuntu box using Apache on Digital Ocean. In case anything ever goes wrong, I would like to have something that periodically sends me or downloads in ...
2
votes
5answers
108 views

MySQL DB Backups: Lockless, Per-Table Restore, MyISAM/InnoDB

The Problem I'd like to implement a MySQL backup strategy on a dedicated server. It has multiple databases on, combined total is about 150GB. Most of this is weighted toward one of the databases. ...
0
votes
2answers
76 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
1answer
169 views

Restore Database of deleted Domain -Parallels

I accidentally deleted a domain from parallels plesk.Is it possible to restore the database related to the domain
1
vote
1answer
38 views

IBM Tivoli Reclaim vs Update

What is the difference between TSM reclaim vs update? I have accidentally run the reclaim command on my offsite pool? Is it fine to run the reclaim command on offsite pool or is there a bad impact by ...
1
vote
1answer
83 views

Is it safe to use password in script to backup database of remote server?

Currently, Im using a small script to automatically backup my database (of a webserver). To backup the database, I have created a user account with only read and lock privilages. The script will use ...
0
votes
1answer
362 views

Ubuntu automysqlbackup configure to have separate databases in one folder with gzip

I have automysqlbackup running on Ubuntu 10.04 and it works perfectly fine. I currently have it performing daily backups for all databases, but I would like to adjust the configuration to do the ...
1
vote
1answer
70 views

Backup websites with database in ubuntu server

I am having one ubuntu local server in which we used to have all our development websites. They all are php based sites. I would like to know whether we can have script or something to cron backup the ...
4
votes
3answers
810 views

Backup MySQL databases in 1 file but with separated .tar.gz for each db

I'm now using this in cron to backup all my databases in 1 sql.gz file: 0 0 * * * root mysqldump -u root -pPASSWORD --all-databases | gzip > /home/backup/db/`date +\%G-\%m-\%d`_db.sql.gz ...
1
vote
1answer
74 views

Can the production db server be in our intranet domain?

I've got someone setting up a "backup-relay" server on our intranet. It will transfer our local backups off-site, and transfer backups of our production db (which is off-site) back home. These are ...
4
votes
2answers
306 views

Best practices for backing up databases

I asked this on stackoverflow, but someone pointed out it would be better to ask here. Let's assume Subversion and MySQL on a RAID NAS. What are the best practices for backing up data? I was ...
1
vote
2answers
163 views

Nightly Backups and Server Performance

At a certain time we run a few backup scripts to backup: code/files databases other important files on the server During this time the websites on the server grind to a hault giving timeouts and ...
0
votes
1answer
45 views

Repairing MySQL databases - restoring data issue

Today I reinstalled Web-Developer Server Suite and although all my old PHP pages work, the databases don't... I copied them over from my backup folder and only some of the tables re-appeared. How ...
-1
votes
4answers
87 views

File and Database encryption [closed]

Just curious what do you guys use for file or database encryption? Any good programs out there or techniques employed for securing IT personal information? Main reason is the company I work for has ...
0
votes
1answer
44 views

Test the proper execution and integrity of a backup

Every night my company generates automated backup all our servers on a backup server: -- backups folder ---- server1 backups folder ------ server1_backup_files.7z ------ server1_backup_db.7z ---- ...
10
votes
4answers
2k views

Should I backup and restore the `mysql` database?

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, ...
3
votes
2answers
790 views

Differential backups with LVM

Is it possible to create differential backups based on LVM snapshots (or maybe a similar technique)? I'd like to perform backups of my intranet server, which hosts multiple services, and their ...
0
votes
1answer
218 views

How Gmail and other Mailservice providers must be taking there DB Backups? [closed]

Being Anxious, I thought of asking this question in SO, which will certainly help in getting an idea for how the big DB carriers take their backups. How Gmail and other Mailservice providers must be ...
-2
votes
0answers
23 views

DB Backup on Client when Hoster does not answer emails [closed]

I have got a strange situation where my website hoster does not answer support tickets any more. What I am trying to do is to do a full backup of my hosted sql db. I can access the db alright. ...
0
votes
1answer
528 views

Before repair with myisamchk, do “mysqladmin shutdown” first or backup database first?

This is Drupal 6 cache table. Server version: 5.1.49-1ubuntu8.1 (Ubuntu) According to Can't Repair Mysql Table Shut down your DB and back it up. Repair operations are dangerous. but ...
2
votes
1answer
167 views

Is it safe to backup crashed MySQL table?

The cache table (MyISAM) marked as crashed. Is it safe to backup before repair? (I'm worried if the repair process gone wrong)
2
votes
1answer
196 views

Restoring MySQL user accounts, databases and configuration from backed up /var/lib/mysql directory

Last night, I backed up my Ubuntu 10.10 box using the sbackup utility. The process ran with the default options, which backed up the /etc /home /usr /var directories to a separate partition on my ...
2
votes
3answers
1k views

Amazon EC2 + EBS:: Regular backup plan?

I have read some articles about amazon ec2 instances and ebs. I found out that, the data on the instance are not persistent, which means, if the hardware fails, instance shut down, I will lost my ...
0
votes
2answers
618 views

SQL Server 2008 database Backup

today I was trying to restore a database with a backup I had made previously on another computer, however I kept getting the following error message: the media loaded on "filepath" is formatted to ...
1
vote
2answers
342 views

how to choose backup strategy?

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. ...
1
vote
4answers
597 views

Best Software For Automated Database Backup (MySQL and MSSQL) [closed]

What is the best software that can backup mysql and ms sql databases automatically? Thanks
1
vote
2answers
240 views

Centralized Database Backup Server

We have database servers running on MySQL and Microsoft SQL. Is there a software that can do automated backups to all our database servers? I've already evaluated zrm of mysql(no web access,hard to ...
0
votes
4answers
62 views

back-up database in Linux partition from windows partition!

Hello I am in a very embarrassing situation, I was trying to upgrade to ubuntu 10.04 from ubuntu 9.10 yesterday and while updating I forgot to put my laptop on charger and the battery ran out. Since ...
1
vote
4answers
116 views

What are questions to ask when planning database backups?

Examples: Was is the operating environment? How large of a dataset? Are offline backups acceptable? Is point-in-time restoration a requirement? What storage engine? CONTEXT: Want to ask how to do ...
0
votes
2answers
238 views

How to back up a MSSQL Database

I have a MSSQL databse hosted on a windows server, What do I need to download a back up to my pc? I am familiar with backing up MSSQL databases, I believe I need to download a Microsoft database ...
1
vote
3answers
194 views

Linux server - backup production database

I had created a script to backup a production database. My initial approach was to backup the mysql directory itself (/var/lib/mysql) but it was discouraged by other users. The script is very simple, ...
0
votes
1answer
49 views

Generation of backup put my website down - is there an easy solution?

On my database server there is a cronjob that backups all the databases in a way that makes it easy to restore them. It is something like this: 0 5 * * * /usr/local/bin/backup.php The problem is ...
2
votes
1answer
25 views

How to ensure dbs are all in sync when restored?

In large server environments, how do you handle the issue of backing up SQL Server dbs which may not be in sync with other dbs they rely on? So if I back up DB1 from a server, and it uses another db ...
1
vote
1answer
84 views

What does SQL Server do if you select more than 1 full backup when doing a restore?

I have a backup file that contains 2 backup sets. Both backup sets are full backups. When I open SQL Server Management Studio and choose "Restore..." and pick the file as my device, it lets me pick ...
1
vote
1answer
1k views

PostgreSQL Backup/Restore

What's the best way to backup a postgresql database? I've tried using the documentation at www.postgresql.org, but I always get integrity errors when restoring. Right now I'm using this for backup: ...
2
votes
2answers
513 views

Sql Server 2005 database lost, How to recover all records. MDF/LDF size is same as it should be

Few months back, I installed a sql server 2005 on one of my client machine. I gave him a backup option to take backup timely but he never took any backup. Today he called me that "i m not able to ...
2
votes
4answers
362 views

Standard database backup procedures

I've been looking at the setup we've implemented for a hosted client, who has a database backed up several times per day (and the last week of backups always available). Say the backups require 20gb, ...
2
votes
5answers
673 views

What are the consequences if I backup LIVE databases every 3-hours using mysqldump?

If I am not mistaken, when executing mysqldump, it will lock the tables, isn't it? Erm, never mind, my question is: What are the consequences if I backup LIVE databases hourly using mysqldump? I ...
3
votes
4answers
2k views

SQL Server “Quick” Incremental backup?

I'm working on a very large database (250+ gigs) with well over 225 million records. The database is hard to work with simply from its sheer size. This database is read-only. We're looking at getting ...
2
votes
4answers
8k views

How to copy & move MySQL database

I'm very new to servers and databases, my experience spanning only a few installations of XAMPP for easy website testing and exploration. So I have XAMPP installed on my laptop, and I just put it on ...
0
votes
2answers
269 views

SQL Server Partial Backups

We currently distribute snapshots of our database to our stores by using rdiff on compressed backups of the entire database. In order to optimize how long it takes to both create these backups, and ...
1
vote
2answers
370 views

How to restore just ONE mysql database from a collective backup

I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file. How can I tell mysql to import ONE of the databases contained in the dump file? -M ...
0
votes
2answers
4k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
9
votes
8answers
7k views

How do I backup a mysql database, but at low priority?

I want to backup a database, but during the day when there is load on the server. It's vital that the backup doesn't impact apache and other databases running on the same server. It should be ...
0
votes
2answers
90 views

Am I backing up my database correctly? And then load it as INNODB?

mysqldump -hlocalhost -uUSERNAME -pPASSWORD THEDATABASE | gzip > /home/db_backup/abc.sql.gz tar -xzvf ./abc.sql.gz mysql THEDATABASE -uroot -pPASSWORD < abc.sql The important note is that ...
0
votes
3answers
730 views

Loading MySQL dump with different table type

Suppose I have an SQL dump, how do I load this into a fresh mySQL installation...as innodb?
2
votes
1answer
149 views

How do I backup a database to a .sql statement?

How do I backup a database to a single SQL file? After it's backed up, how can I load it/restore the database with InnoDB? It must be InnoDB.
0
votes
1answer
150 views

Good off-site backup solution for database and files

I was searching for a tool that would make remote backups/restores easier for both database and files, but I couldn't find any, so I started thinking about creating my own online service that deals ...
-12
votes
4answers
4k views

what is the best way to backup mysql database? using a mysql existing tool or technique? [closed]

the database has million of records, and will need to be backed up every data entry from the user.
-2
votes
2answers
254 views

how to use mylvmbackup [closed]

any useful tips or easiest way