Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms

2
votes
2answers
59 views

Backup status report from multiple server in sql server 2005

Per daily routine activities of DBA, as we know backups are important to be monitored and to make sure they are corrupt free, i am trying to fetch a report to get such status. Moreover, we have SQL ...
1
vote
2answers
95 views

How to find what frequent and/or large transaction have taken place in MS SQL Server?

Each day is experiencing about 1GB sum total of all the transaction log backups that day, while at the end of that week the Full DB backup is about 180MB. For a business database for buying/selling ...
0
votes
2answers
70 views

Which files in the “MySQL-5.0.27-win32” folder do i need to backup?

Ok, I am using a pretty old MYSQL "mysql-5.0.27-win32" and the file and the structure maybe different from the latest Mysql (mysql 7). Here is the current structure of of mysql-5.0.27-win32: In ...
0
votes
2answers
161 views

MySQL incremental backups per database (not global)

While searching for free/open-source MySQL incremental backups solutions I have found a number of ways to do incremental backups and all of them seem to either rely on "logical" way of backups/restore ...
0
votes
2answers
736 views

How to run a cold backup with Linux/tar without shutting down MySQL slave?

I run the following before tar-ing up the data directory: STOP SLAVE; FLUSH TABLES WITH READ LOCK; FLUSH LOGS; However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
0
votes
1answer
15 views

MySQL - Backup new and modified entries only

I am developing a very huge system in Java using Hibernate and MySQL. Now, I want to automate the daily, weekly, and/or monthly replication (backing up) of the data that are stored from the database ...
0
votes
1answer
26 views

WordPress MySQL writes during “Flush Tables With Read Lock” are rejected instead of being queued

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being queued to ...
0
votes
1answer
46 views

Access denied to user ODBC, but trying to login as root

I'm trying to do a backup of a MySQL database on Windows, but for some reason it's trying to log me in as ODBC instead of root - does anyone know why? As you can see below the red line, I can login ...
0
votes
1answer
93 views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
0
votes
1answer
156 views

MyISAM : Should I be concerned by these warnings?

I restored some tables from recent Databases backups. Because Im supporting a legacy system that only uses MyISAM tables in their DBs, for backing up I used a little script that pretty much copies all ...
0
votes
1answer
841 views

What is best strategy for backup on streaming replication(hot standby) environment

I have questions. What is best strategy for backup on streaming replication(hot standby) environment. I’d like to do backup on slave server and restore(PITR). First, I set up streaming ...
0
votes
1answer
226 views

Taking hot backup of slave node in postgres (master-slave config with repmgr)

I have a postgresql setup with master-slave configuration using repmgr. I'm struggling with taking a consistent snapshot backup (pg_start_backup) of the slave node, this is due the fact that the slave ...
-1
votes
1answer
157 views

“Backup mysql database by copying the data file even when MYSQL server is running” solution! Is there any problem for this backup solution?

I am using MYSQL-5.0.27 I have 2 exact same MYSQL folder "mysql-5.0.27-win32". One in the Virtual Private Server (VPS) & the other in Local PC. At the beginning, these 2 folders are exactly the ...
-1
votes
1answer
49 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
-1
votes
1answer
719 views

In the domain of SQL Server backup, what is a backup set, backup device, backup media, backup media set, backup media family

I'm not a native English speaker and I've read the descriptions in BOL but still can't understand what exactly are they. Can anyone explain in an easy understand way? Thanks.
0
votes
0answers
182 views

Rackspace Cloud Databases: incremental backup

Rackspace Cloud Databases are a little bit special in that we do not have access to the bin_log file, they are not servers in the traditional sense. I do have a couple of Cloud Servers with them but I ...
0
votes
0answers
119 views

Tape rotation strategies

I am trying to find a tape rotation strategy that would be optimal under the following conditions: Backup Media Rotation strategy should support the following: Media Archives required ...
0
votes
0answers
286 views

How to do point in time recovery of binary log files into .sql file

I have written a shell script to do an incremental backup of MySQL database. For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory. For point-in-time recovery, Im ...
0
votes
0answers
297 views

Mysql Incremental Backup and point in time recovery

I'm writing a shell script using the concept of binary logs for point in time recovery. Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be ...
0
votes
0answers
52 views

How can I backup Oracle with Listener error

On my server that I have installed Oracle, I encounter a TNS Listener error and i couldn't connect Oracle. Is it possible to backup database with Only my user and password, without listener?