The database-backup tag has no wiki summary.
-1
votes
2answers
45 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 ...
1
vote
1answer
72 views
Backing up a 400-500 GB database on MySQL/Amazon RDS?
We have an Amazon RDS small instance for a MySQL datawarehousing database.
Database size will be around 400-500 GB very shortly.
What is the best way to backup our database?
Can it be done ...
0
votes
2answers
48 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
188 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 ...
3
votes
2answers
131 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 ...
1
vote
2answers
104 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
262 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 ...
