The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [restore]

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

Filter by
Sorted by
Tagged with
37
votes
7answers
54k 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 &&...
4
votes
1answer
2k 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 ...
13
votes
3answers
8k 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 ...
17
votes
3answers
40k 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 ...
9
votes
4answers
15k 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 ...
8
votes
3answers
7k 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 ...
7
votes
2answers
4k views

Extract registry key from NTBackup System State backup

A Windows Server 2003 machine died recently but I need some information that was contained in the now-defunct server's registry. I have a "System State" backup file created by the Windows Server 2003 ...
1
vote
4answers
4k 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 ...
2
votes
1answer
10k 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 ...
2
votes
1answer
6k 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 ...
1
vote
1answer
213 views

Restore (PITR) of CloudSQL (MySQL) fails with Got a packet bigger than 'max_allowed_packet' bytes

When doing a PITR-Restore of a second generation Google CloudSQL instance, the restore fails with "Failed to Create" error. I cannot manipulate the instance clone, except reading logs and deleting it. ...
1
vote
1answer
1k views

MySQL “max_allowed_packet” error — how do you profile the max packet size?

Keep running into into the "max_allowed_packet" error msg, which to data I've just guessed at what the number should be.... I'd like to stop guessing, and know how to see what the number should be -- ...
1
vote
2answers
660 views

Backup workaround for IaaS v2 Virtual Machines on Azure?

Looked high and low, but couldn't figure out a way of backing up my VMs in Azure's new portal i.e. IaaS v2 VMs (made using the resource manager). I was wondering if anyone has implemented a ...