Returning data from a backup to its original location or to its successor.

learn more… | top users | synonyms

3
votes
1answer
1k views

MySQL: How to backup and restore using different schema name using xtrabackup

I very often need to create a backup of a database and import it using a different schema name. These schema's are pretty large (3-5GB) and mysqldump is a pain. xtrabackup seems promising but I cannot ...
27
votes
7answers
29k views

Linux: how to restore config file using apt-get/aptitude?

I've occasionally lost my config file "/etc/mysql/my.cnf", and want to restore it. The file belongs to package mysql-common which is needed for some vital functionality so I can't just purge ...
13
votes
5answers
11k views

How can I speed up a MySQL restore from a dump file?

I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and ...
12
votes
2answers
6k views

Simple Backup Strategy for Amazon EC2 instances / volumes?

You have entered Introductory Backups for Amazon EC2 EBS-backed Windows Images 010... I have been browsing my brains out to find a simple backup strategy for our single windows 2008 server running ...
5
votes
4answers
6k views

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 ...
7
votes
3answers
3k views

Active Directory disaster recovery with DPM

I have a sort of catch-22 question here. Suppose I'm using Microsoft System Center Data Protection Manager (2010 or 2012, it works the same way) to backup, amongst various other things, my Active ...
4
votes
3answers
10k views

How can I back up a table structure but NOT its data in MySQL

I am using MySQL Administrator for making my database backup. I can perfectly back up the whole database with all its tables. There are some tables whose size is very big so I wonder if I could only ...
2
votes
1answer
8k views

Backup Exec 2010 throwing error trying to restore Exchange mailbox

Error category : Resource ErrorsError : e000848c - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again. If the server or ...
1
vote
1answer
312 views

Restore Exchange mail after upgrade and decommission?

I recently upgraded our Exchange 2007 environment to Exchange 2010 and decommissioned the Exchange 2007 servers. We have almost 2 years worth of backups for our Exchange 2007 environment that would ...
1
vote
1answer
3k views

oracle database move current server to another machine problem

these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then ...
0
votes
4answers
2k views

Restore linux backup to new hardware

I was looking at following the instructions in this serverfault question for restoring a backup of a server to new hardware. I am a little bit confused by the whole process and have a few specific ...