The tag has no usage guidance.

learn more… | top users | synonyms

15
votes
4answers
21k views

Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances' [closed]

I am having trouble running mysqldump as the mysql root user. When I try to backup the mysql table I get this error: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'...
13
votes
6answers
2k views

Downtimeless MySQL backups on a budget

My current MySQL backup scenario is to replicate our db to a second server and run mysqldump on that server to remove any downtime from table or row locking. This is working well but costs $150 per ...
11
votes
4answers
5k 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, ...
11
votes
3answers
1k views

Is this a valid backup strategy for MongoDB?

I've got a single dedicated server with a MongoDB database of around 10GB. I need to do daily backups, but I can't have downtime with the database. Is it possible to use a replica set on a single disk ...
11
votes
2answers
10k views

How do I create a read only MySQL user for backup purposes with mysqldump?

I'm using the automysqlbackup script to dump my mysql databases, but I want to have a read-only user to do this with so that I'm not storing my root database password in a plaintext file. I've ...
9
votes
3answers
5k views

Do InnoDB tables got locked during mysqldump when mixed with MyISAM?

I'm looking for a backup solution for my mysql servers and I need as less downtime as possible. I have the following: MySQL servers they are not replicated each server stands for its own This ...
8
votes
6answers
4k views

Optimal way to make MySQL backups for fairly large databases (MyISAM / InnoDB)

Currently we have one beefy MySQL database that runs a couple of high traffic Django based websites as well as some e-commerce websites of decent size. As a result we have a fair amount of large ...
8
votes
1answer
8k views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
7
votes
2answers
4k views

pg_restore taking much longer than pg_dump

I am regularly saving and later restoring a smallish PostgreSQL database, which is used for testing. Its data is updated regularly as a result of tests, then a new dump must be made, and the dumps are ...
7
votes
1answer
218 views

Does a failed full backup invalidate future transaction log backups?

I have a server running SQL Server 2005. I have nightly full backups, with transaction log backups every 15 minutes. This is a relatively small server so I am not doing any differential backups. If ...
6
votes
3answers
2k views

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 ...
5
votes
1answer
620 views

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?
4
votes
2answers
455 views

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 ...
4
votes
3answers
4k views

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days ...
4
votes
2answers
593 views

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 ...
3
votes
1answer
10k views

pg_dump: [archiver (db)] connection to database failed: FATAL: Peer authentication failed for user “postgres”

I'm trying to backup my Postgres DB to another server but I keep getting denied access. my pg_hba.conf file looks like this: # DO NOT DISABLE! # If you change this first entry you will need to make ...
3
votes
1answer
1k views

ssh connection operation timed out using rsync

I use rsync to backup my remote server on my local device but when I combine it with a cron job my ssh times out. Just to be clear, the data is stored on a remote server and I want it stored on my ...
3
votes
3answers
2k views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
3
votes
1answer
5k views

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 ...
3
votes
4answers
3k views

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 ...
3
votes
2answers
413 views

Is there a debian-sys-maint equivalent in centos?

I am using debian-sys-maint as practical way to do database dumps in our debian systems, somenthing like this: mysqldump -u debian-sys-maint -p`cat /etc/mysql/debian.cnf | grep password | tail -n 1 | ...
3
votes
2answers
4k views

MDBDATA log folder is full, MDBDATA backup keeps failing

Our MDBDATA log folder has gotten full and it's causing users outlook to lose connection. To remedy the problem my co-worker suggested that we move old logs onto our D: drive since it's not being used....
3
votes
1answer
138 views

SQL Server backups - transferring between instances

I work in a development shop where we primary use SQL Server for our day-to-day development and testing. Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on ...
3
votes
1answer
79 views

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 ...
3
votes
1answer
181 views

Backup of write heavy Solr / MySQL server

I am attempting to set up an automatic backup for a server running Ubuntu. This server is used to host a couple applications which are rather write heavy and subject to a good amount of traffic. To be ...
3
votes
2answers
20k views

Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> 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 ...
3
votes
3answers
3k views

How can I split phpmyadmin's server backup to database backups?

I have a big .sql file which i created with phpmyadmin to back up my development databases. is there any way to split this big backup into several files, each file for a separated database? the file ...
3
votes
1answer
557 views

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 ...
3
votes
2answers
455 views

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script ...
2
votes
2answers
4k views

How to make pg_dump less resource greedy

I have configured cron to invoke pg_dump on a daily basis using following rule: # xyz database backups: 00 01 * * * root umask 077 && pg_dump --user=xyz_system xyz | gzip > /var/xyz/backup/...
2
votes
2answers
106 views

How to back up a database with thousands of files

I am working with a Fedora server that runs a customized software package. The server software is quite old, and its database consists of 1,723 files. The database files are constantly changing - ...
2
votes
2answers
241 views

Is backing up to a NAS over private fibre link better than tape?

I have recently taken over the responsibility of a small business network of 35 users. I am a bit green on backup strategies and am considering my options. We currently backup our SBS Server to tape (...
2
votes
2answers
179 views

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 ...
2
votes
2answers
391 views

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 ...
2
votes
2answers
845 views

How to store 250TB of data and develop a backup/recovery plan? [closed]

I'm really new to this topic, so big apology for stupid questions. I have a school project and I want to know how to store 250TB of data with life-cycle for 18 months. It means every record is ...
2
votes
2answers
2k views

Encrypting Amazon EBS Snapshots

Would love it if someone could help me out with this: The setup is a distributed LAMP architecture hosted on Amazon EC2 instances. MySQL Percona. We use Amazon's EBS snapshots for backups. We have ...
2
votes
2answers
80 views

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 ...
2
votes
4answers
686 views

Transferring PostgreSQL Database Between Servers

Is it possible to directly transfer a PostgreSQL database between two PostgreSQL servers? I've currently been setting up a "development" version of my production database by using pg_dump to ...
2
votes
1answer
764 views

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 ...
2
votes
2answers
2k views

PGP decryption fails with error for one file

We store database backups encrypted with PGP Command Line 9.7.0. Files look like 2009.bak.pgp Here's command line used to backup these files: pgp --encrypt F:\2009.bak --recipient admin@company.mail ...
2
votes
4answers
13k views

Incremental/Differential MySQL Backup using mysqldump

Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
2
votes
1answer
62 views

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 ...
2
votes
2answers
111 views

Backing up Entire MySQL Directory

In regards to: Remounting MySQL under a new mount point What would be the best way to backup MySQL data before moving the mount point? Can this be done with MySQL running? Would a simple rsync off ...
2
votes
1answer
530 views

Using mongodump with an auth enabled mongodb server

I'm trying to do a daily backup of my mongodb server (auth enabled) using the mongodump tool. mongodump provides two parameters to set the credentials: -u [ --username ] arg username -p [ --...
2
votes
1answer
367 views

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At ...
2
votes
1answer
259 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
2
votes
2answers
2k views

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 ...
2
votes
2answers
62 views

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
2
votes
2answers
1k views

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 ...
2
votes
1answer
621 views

Postgresql 9.0.8 Physical Backup on Windows Server 2008 R2 results in “Access is denied”

I've built a script to perform a physical backup of a Postgresql 9.0.8 database by following the "Standalone hot physical database backup" recipe in the PostgreSQL 9 Administration Cookbook (Riggs/...