Questions tagged [database-backup]
247 questions
6
votes
2 answers
pg_dump compression; Server or Client side
When you are specifying compression on pg_dump, is the compression happening on the server side so that the transfer is quicker or is the pg_dump doing the compression?
Thank you
![](../../users/profiles/314128.webp)
KoboldAtWork
- 63
- 3
6
votes
2 answers
Recover mysql database - mysql/mysqldump gives "table . doesn't exist (1146)"
Backstory
Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql.
Reinstalled with Linux Mint because I was on Ubuntu 10.0.4 this…
![](../../users/profiles/106732.webp)
Matthew
- 273
- 1
- 2
- 10
6
votes
3 answers
Creating a *Consistent* *Online* MySQL Backup with InnoDB AND MyISAM tables
I just spent hours building a new database server to replace 2 failed servers from a mysqldump file created a month ago, then used my server's bin-logs to bring that mysqldump up to date. Now that I have this new database server online, and have…
![](../../users/profiles/45257.webp)
Jim Rubenstein
- 1,187
- 1
- 10
- 16
6
votes
1 answer
How to backup/restore excluding filestream varbinary in SQL Server 2008?
There is an application used in a production site that uses SQL Server 2008 as its DBMS.
The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into the DB tables.
The point is that now and then it…
![](../../users/profiles/72447.webp)
fdierre
- 161
- 4
5
votes
0 answers
Best Way to Backup ClickHouse Data
We recently started using Yandex ClickHouse for our data backend, and I'm working on figuring out how best to backup our data. There seem to be two ways of doing this.
ALTER TABLE ... FREEZE PARTITION
The ALTER TABLE ... FREEZE PARTITION command…
![](../../users/profiles/434276.webp)
Matt
- 51
- 1
- 2
5
votes
2 answers
Is it possible to take a snapshot of a database in Azure?
So, to clarify, I'm aware I could dump the database using tools written for the database that don't know anything about azure.
I know I could do an import / export.
And I know I could just extend the point-in-time recovery retention period for the…
![](../../users/profiles/226538.webp)
Parthian Shot
- 1,155
- 3
- 16
- 32
5
votes
2 answers
Cassandra snapshot restoring : random missing data
I'm having a hard time restoring snapshot on Apache Cassandra (version 3.0.9). As far as I can say, I'm following the procedure described on datastax blog, along with several other ones (for instance :…
![](../../users/profiles/256501.webp)
P. Bender
- 51
- 1
- 5
5
votes
5 answers
Ola Hallengren's SQL Backup to Network Location not working
I have set up Ola Hallengren's SQL Server Maintenance Solution on several SQL Express servers (2008 to 2012 R2) in the past few years. I recently have started having issues with the network backup component on all of them a new one. I've had this…
![](../../users/profiles/217045.webp)
MagnaVis
- 388
- 1
- 4
- 13
4
votes
1 answer
Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots
Basically what I'm looking for is a way to tell mysql (percona-flavored) to take the following steps:
Flush all committed transactions to the filesystem
Start buffering all transactions (keep the filesystem in a coherent state)
Wait for me to do…
![](../../users/profiles/23332.webp)
HonoredMule
- 187
- 11
4
votes
2 answers
How to do offsite AWS RDS PostgreSQL backups?
As a measure to mitigate against catastrophes such as a malicious entity gaining full access to our AWS account and deleting everything, I am in the process of setting up offsite backups for our production database. We use PostgreSQL on AWS RDS. We…
![](../../users/profiles/29175.webp)
Olivier Lalonde
- 713
- 3
- 13
- 20
4
votes
2 answers
Configured Azure Backup sends me a health check report every 15 minutes
I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via
EXEC msdb.smart_admin.sp_set_parameter
@parameter_name = 'SSMBackup2WANotificationEmailIds',
@parameter_value =…
![](../../users/profiles/92096.webp)
Daniel Hilgarth
- 75
- 1
- 10
4
votes
1 answer
MS SQL Server DB version without restoring?
Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
![](../../users/profiles/139468.webp)
SteB
- 989
- 6
- 15
- 31
4
votes
2 answers
Duplicating an ESXi host to another ESXi host as a backup solution
I have an ESXi host with the following virtual machines:
1 x Active Directory Server
1 x Remote Desktop Services Server
1 x SQL Database Server
1 x Accounting Software Application Server
I have a second "blank/empty" ESXi host.
In theory, what I…
![](../../users/profiles/61373.webp)
Earls
- 295
- 1
- 7
- 21
4
votes
2 answers
Rackspace cloudserver backup options
I recently signed up with Rackspace to host some database servers. I've got two MySQL servers set up, and have a method to create backups (using the Percona Xtrabackup and innobackupex tools). I've been trying to use duplicity to copy these…
![](../../users/profiles/45257.webp)
Jim Rubenstein
- 1,187
- 1
- 10
- 16
4
votes
1 answer
Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?
Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server and in real-time have it backup to the second…
![](../../users/profiles/70635.webp)
BobFranz
- 63
- 1
- 3
- 6