Tagged Questions
1
vote
1answer
1k views
Difference between database dump (export) and database backup?
What is the drawback using only EXP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between ...
3
votes
1answer
223 views
Backup a database with a huge number of tables
Is there a way to backup a PostgreSQL database with a huge number of tables?
An attempt with pg_dump for a database of about 28000 tables resulted in the following error message:
pg_dump: WARNING: ...
0
votes
2answers
2k views
Opening a .backup file for PostgreSQL
I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise.
In short, I have what I think is a ...
2
votes
3answers
546 views
How to detect a running mysqldump?
Here are the things I can't change:
We got a mySQL myISAM replication running a master and some slaves. One slave is being used for nightly backups using mysqldump. The backups is using heavy locks ...
