Top "Database-backups" questions

database-backups are intended to preserve data by serializing database tables to a text format or exporting them to a binary format

pg_dump vs pg_dumpall? which one to use to database backups?

I tried pg_dump and then on a separate machine I tried to import the sql and populate the database, …

postgresql database-backups
CouchDB dump to file and load from file

I cannot replicate between two couchdb servers, so I would like to dump to file from one server and load …

load couchdb backup dump database-backups
Downgrading SQL server 2008 to SQL Server 2005

Are there any issues backing up a database from SQL Server 2008, and then importing it into SQL Server 2005? I had …

sql-server-2005 sql-server-2008 database-backups downgrade
Is copying the /var/lib/mysql directory a good alternative to mysqldump?

Since I'm making a full backup of my entire debian system, I was thinking if having a copy of /var/…

mysql backup database-backups
Restore PostgreSQL db from backup without foreign key constraint issue

I have a postgresql db with about 85+ tables. I make backups regularly using pg_dump (via php-pgadmin) in copy mode …

postgresql database-backups
Database is in Transition state

Today I was trying to restore a database over an already existing database, I simply right clicked the database in …

sql-server sql-server-2008 database-backups database-restore
Big Database backup best practice

I maintain big MySQL database. I need to backup it every night, but the DB is active all the time. …

mysql database backup database-backups
How do I split a large MySQL backup file into multiple files?

I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB... Is there a …

mysql database-backups splitter
Database Mirroring / Postgres Streaming Replication

I am not a DBA; I'm the primary developer of an enterprise database based application. I'm currently specing out some …

postgresql streaming replication database-backups
Postgresql: backup all table structures but only a few data table

I have a database with some tables for the application settings, lists like users, departments, cities. I want the structure …

postgresql database-backups pg-dump