1
vote
1answer
17 views

Postgresql: missing data after crash

I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8 It looks like all my postgresql databases were reverted to the state ...
0
votes
1answer
87 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 ...
2
votes
1answer
212 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 [ ...
0
votes
1answer
313 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
5answers
438 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
1
vote
3answers
171 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
0
votes
4answers
681 views

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
0
votes
1answer
296 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...