The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
2answers
369 views

How do I connect to a database with a blank password using a shell script?

## connect to mysql and source backup file ## USER="root" PASS="" mysql -u$USER -p$PASS database_name < backup.sql Above is my shell script which I used to source database but still its asking ...
0
votes
1answer
564 views

Is it possible to pipe the result of a mysqldump straight to rsync as the source argument?

Is it possible to pipe the result of a mysqldump straight to rsync as the source argument? Conceptually, I was thinking something like: mysqldump -u root -p database_to_backup > ...
5
votes
1answer
1k views

How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?

We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day. The problem is, the differential backups don't always seem to ...
4
votes
2answers
331 views

Can I manually reset the “internal status flag for a full database backup”?

We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day. This worked last weekend, however this weekend the differential ...
3
votes
2answers
1k views

Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?

I'm still struggling to understand SQL's backup jobs. We currently have a SQL Server 2005 instance using the FULL recovery model. We do a full database backup every week. BACKUP DATABASE ...
4
votes
2answers
1k views

SQL Server 2012 database backup successfully report but no backup file

I have created maintenance plan in SQL Server 2012. And every day, the maintenance plan should backup the database. There is no database backup file when I look in the folder where the backups must ...