The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
232 views

Backup RHEL 5 Web Server Disk and DB Data to USB Drive, Best Way to do this?

We are using a dedicated web server with Redhat Enterprise Linux 5 installed, we are using this to host a couple of our websites. We asked our host to attach an external USB hard drive to our server ...
0
votes
1answer
231 views

Complex retention policy

I have daily database backups scp'd to a directory on a local linux machine for multiple databases. The naming format is [dbname].backup; there is no timestamp and currently the latest backup ...
1
vote
1answer
43 views

Backup slowness after changing the SAN switch

We have a netbackup environment Recently we changed the connectivity of two of our sql servers(cluster servers) from one SAN switch(MDS 9509) to another (MDS 9513) followed by which we are ...
0
votes
2answers
98 views

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...
1
vote
1answer
127 views

Import SQL Dump from Command Line

I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the ...
0
votes
1answer
32 views

How to create a consistent backup of an application (database and files on a disk)? [closed]

I have an application where some data is stored in a database and some directly on a file system. When a user performs an operation, his action can trigger a change to a database and to some file on a ...
3
votes
2answers
410 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 | ...
0
votes
1answer
590 views

pg_dump fails, no space left, need to delete partial backup file to free space

Easy points. On my mac, postgres.app 9.2, I ran "pg_dump pdbt > pdbt.sql". It used up all my space and then failed with the error below. Now I want to free up the space taken up by "pdbt.sql" but I ...
0
votes
1answer
164 views

Why does the mysql backup grow if a table is crashed?

I use this backup script on my debian squeeze server to create a backup of all mysqltables: #!/bin/sh BACKUP_DIR=/var/backups/mysql/ DATE=$(date +%Y-%m-%d) for i in /var/lib/mysql/*/; do dbname=...
0
votes
1answer
433 views

How to run a mysqldump automated with SAFELY stored mysql credentials?

I'm looking for a way to SAFELY run daily backups using mysqldump. Safely means not storing username/password in a text file or any other unencoded format. I know there is (apparently it isn't) a way ...
3
votes
1answer
180 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
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 ...
-1
votes
2answers
1k views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
2
votes
1answer
402 views

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

No match for a database image file was found based on the source database alias “URCDB”

I used IBM Data Studio to backup a test database named URCTEST. Now, I want to restore it to the actual (empty) database, URCDB. I've got little experience with IBM DB2, so I assumed this was ...
0
votes
1answer
23 views

Not Backing Up Files That Don't Change In A WordPress Install

I have a WordPress install and I'm wonder what is generally best practice when it comes to back up. I'm asking here instead of WordPress.stackexchange as this question is not only a WordPress question ...
1
vote
2answers
39 views

How to avoid restoring deleted user accounts when recovering from backup?

Typically in websites, when a user wants to permanently delete his/her account, is necessary to remove this account also from the backups to avoid unwanted reactivations in case of backup restoration?
1
vote
1answer
55 views

Backing up a mirrored SQL environment

I have 2 SQL servers in Mirror configuration. I want to backup these servers but backing up the SQL databases in Mirror state causes an error. These two mirrors also have a witness set. I would ...
0
votes
3answers
386 views

mysqldump --single-transaction with dump files separated by table?

Using mysqldump, how can I create a consistent backup of a MySQL (InnoDB) database and have the dump files be separated by table? To create a consistent backup using mysqldump, I know there is --...
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 ...
0
votes
3answers
126 views

MySQL backup and save in external server

I have MySQL 5 installed in a Ubuntu server. I want backup the database for: latest 7 days weekly and store those backups in another server. I prefers the tool runs in the same server that host ...
0
votes
1answer
642 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
1answer
188 views

Backup and bz2 large mysql datefile with innobackupex in the background

I'm using the following command to backup a large running mysql database (~500GB). innobackupex --user=user --password=***** --stream=tar ./db-backup | bzip2 - > backup.tar.bz2 Since the backup ...
0
votes
3answers
653 views

How does tape backup affect production systems such as SQL Server

I am not a systems person or a DBA, and as I was reviewing a bid for a project, I started to wonder how the tape backup (LTO-5 3000) affects live production applications such as Sql Server Databases ...
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....
1
vote
3answers
516 views

Good backup strategy for heterogeneous data consisting of images/databases/office files/svn repositories/

I'm looking for a simple on-site (i.e. not online) backup solution for our small company. Right now we have approximately 4TB of data in total, maybe adding ~500GB per year. The amount of data ...
0
votes
1answer
35 views

Remove Backup Configuration in SQL Server

I did a backup to a particular database and restore it in another Server. Now I want to remove that backup. But I couldn't remove it. Whenever I remove it, I got the attached error. Could you please ...
0
votes
2answers
2k views

Server failed, can I retrieve my database from the my hard disk?

I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the desktop,...
1
vote
3answers
2k views

Hourly database backup [closed]

I have a VPS with Kloxo control panel, I want to have database backup from one of my websites in every 2 hour. How i can do this? Kloxo doesnt support Hourly backups, only support daily, weekly and ...
0
votes
2answers
162 views

MySQL Backup - incremental

I know that you can use mysqldump. I am currently dumping the following way: ${MYSQLDUMP} --single-transaction -u ${MUSER} -h ${MHOST} -p${MPASS} $db | ${GZIP} -9 > $FILE From my understanding ...
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 ...
0
votes
1answer
548 views

Using rsync to make daily backups every 24hrs

I would like to backup /home/* /root/* and mysql databases to a set of RAIDed drives. Performance wise I want to do incremental backups. Would this be the idea? rsync -al /home /dev/sdb/backups/...
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?
2
votes
2answers
110 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 ...
0
votes
1answer
474 views

Can you a virtual service account access the network in workgroup

By default SQL Server Uses a virtual account for the sql server service: NT SERVICE \ MSSQLSERVER which is a Virtual Account. I know you can give this account nework access in a domain by adding ...
1
vote
1answer
399 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
1
vote
1answer
4k views

SQL 2008 Backups to UNC Share Failing 0xC002F210

This problem is driving me NUTS!! We take backups of all of our production databases to a network share, which are then backed up to tape nightly. 8pm Mon-Fri - Full backup, followed by log backup ...
0
votes
2answers
290 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
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 [ --...
1
vote
1answer
183 views

Minimum mysql wait_timeout?

On a hard-hit database server which ofter suffers from maximum connections being saturated, mysqltuner.pl suggests me to set wait_timeout (< 1) I am wondering whether it would be wise to ...
1
vote
1answer
2k views

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...
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/...
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 ...
1
vote
1answer
1k views

How to export database from Oracle 10g

I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
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 ...
0
votes
1answer
508 views

MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS

I will be uploading a web application to amazon ec2 instance in the next couple of weeks. I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS. The only confusion i ...
1
vote
3answers
403 views

Backing up data (including mysqldumps) to S3

We have a web app on a number of servers and we want to add an additional layer of redundancy by backing up the key data to S3. The key data is the MySQL database and a folder containing dynamically ...
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 - ...
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 ...
1
vote
4answers
2k views

Mysqldump causes “Too many connections”

A scheduled backup using mysqldump on one of our databases is causing Too many connections. The database is of both InnoDB and MyISAM tables with size of around 500Mb. The Too many connections appears ...