Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
3
votes
2 answers

Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errors

I have a master/slave replication setup where I use InnoDB and MyISAM tables in over 7000 databases that I want to copy from my master to the slave to restore replication. Both servers were running Ubuntu 10.04.2 LTS (which uses the mysql-server…
Edward van Kuik
  • 226
  • 2
  • 6
3
votes
1 answer

Looking for automatic backup methods for sites

I need a suitable backup automation script that will run in PHP on my apache server. Some of my sites run Drupal. Which is the most suitable method to automatically backup both the code and the database?
Naweed Chougle
  • 83
  • 1
  • 8
3
votes
1 answer

If I have full backup (.bak) and 3 differential backups (.dif) how can I restore them to a new database?

I need to check some old data. I need to check data from last night compared to data today. I am going to use SQL Data Compare to do this but I need to setup a fresh database to restore the backup to so I can compare it against the existing…
MetaGuru
  • 896
  • 6
  • 22
  • 36
3
votes
1 answer

Not able to backup of postgres DB from DBeaver

Hope you are doing great. We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine. Whenever we try to take backup of Database it is giving error as "Native client is not specified for connection". I did search…
Satish Lamak
  • 51
  • 1
  • 3
  • 7
3
votes
1 answer

Most efficient/quick SQL database update/restore method

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 will only be used as read-only. We're looking at getting faster hardware, but either way…
KTF
  • 161
  • 1
  • 2
2
votes
2 answers

What is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?

I'm trying to convince a client that their SQL Server backup strategy is insufficient. Long story short is that their current backup "strategy" is a weekly full backup followed by daily transaction log backups. I have already advised the client…
PEBKAC
  • 21
  • 1
2
votes
1 answer

How to secure the db dump taken from daily run script

In one of my mysql slave servers I have written a daily run script, which 1) stops slave, 2) takes a db dump, 3) starts slave again, 4) encrypts it, 5) copies it to my s3-bucket. I am using aws-cli to copy the dump to s3-bucket. The issue here is…
Rajat Singhal
  • 123
  • 4
2
votes
2 answers

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a standard .sql file, gzipped and then ran through…
Wingar
  • 31
  • 4
2
votes
2 answers

How to Dump all databases from MySql server with mysqldump without passwords

Is it possible to dump all databases without supplying the username and password for each databe ? The server has 10 databases with different usernames and passwords. I will be logged in as root (centOS) I used the following but i get access…
firephil
  • 169
  • 1
  • 1
  • 8
2
votes
2 answers

Will a Veeam 8 Snapshot Backup be be unable to restore my non-quiescable file-based databases if someone is logged in to them at the time?

We have some very old file-based databases (multi-user, but not Server-based) that are running on some VMs on an VMWare ESXi. Setup HyperVisor The ESXi is running ESXi version 5.1.0 Virtual Machines The VM with Visual Fox Pro is running Windows…
leeand00
  • 4,869
  • 15
  • 69
  • 110
2
votes
1 answer

s3cmd: on-the-fly backup

To do backups I created a script that makes an archive of all the folders I need to backup, sends it to S3 (through s3cmd) and then deletes it after upload has been completed. I'm looking for a way to avoid having to create the archive and then…
MultiformeIngegno
  • 1,687
  • 9
  • 26
  • 31
2
votes
1 answer

Postgresql: missing data after crash

I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8 It looks like all my postgresql databases were reverted to the state they were in 3 months ago. Columns that I added…
EoghanM
  • 560
  • 2
  • 7
  • 15
2
votes
3 answers

simple script to backup PostgreSQL database

Hello I write simple batch script to backup postgeSQL databases, but I find one strange problem whether the pg_dump command can specify a password? There is batch script: REM script to backup PostgresSQL databases @ECHO off FOR /f "tokens=1-4…
Mick
  • 347
  • 3
  • 14
  • 27
2
votes
2 answers

Any issues with filesystem-only backups on PostgreSQL?

I am running my DB server in amazon cloud, and I have the database files on a separate EBS volume. When it comes to backup/restore operations, I found it infinitely simpler to just do a filesystem-level backup rather than sql dump because I can…
Goro
  • 664
  • 3
  • 9
  • 18
2
votes
1 answer

LVM+MongoDB. Dropping in speed of backup creation

Till recent time we have been making mongo backups archiving LVM snapshot on hidden SECONDARY server with RAID10 on SAS disks. Currently operation on making snapshot from volume with 500 Gb of data on it takes lo-o-o-ong time. Final archive is about…
user76667
  • 41
  • 5
1 2 3
…
16 17