database-backups are intended to preserve data by serializing database tables to a text format or exporting them to a binary format
database-backups are useful for archiving, upgrading, replicating, and migrating data
References
Questions tagged [database-backups]
1580 questions
0
votes
1 answer
Strategy to terminate database job from a remote program utilizing cron
I have not yet coded a potential solution to this, so before anyone asks I have zero code to back this up as I am trying to get a firm grip on the processing behind what needs to happen.
My problem is that I have an Oracle database that will be…
Woot4Moo
- 23,987
- 16
- 94
- 151
0
votes
3 answers
Keep GUI responsive during SQL Backup
VB.NET 2.0:
I'm issuing a backup command to a SQL server from a VB.NET application. I'm capturing the messages it sends out and appending them to a multiline textbox.
What I'm trying to do, though, is to allow the application to keep responding to…
John
- 2,653
- 4
- 36
- 57
0
votes
2 answers
Android concerns with restore database
Imagine the following scenario (I allow backup / restore from my app, I'm doing backup / restore white the entire file.db):
The user make backup of the database.
In the future I do an update on my application which has a new version of the…
weldsonandrade
- 606
- 1
- 9
- 25
0
votes
1 answer
Android how to make database backup?
I want to make database backup to my app, so I'm looking for the best way.
I should save a copy of the database and programatically make the backup?
Can make database backup with backup manager?
Any tips?
weldsonandrade
- 606
- 1
- 9
- 25
0
votes
1 answer
sql files not getting backed up
The following code does not throw any errors but the databases dont get backed up with new…
0
votes
1 answer
Comparing bz2 files in unix
I manage a number of databases on unix servers, and do daily backups of these databases using mysqldump. Since (some of) these databases are very large (20+Gb), I usually zip the backup .sql files using bzip2, to get compressed bz2 files.
As part of…
amaidment
- 6,942
- 5
- 52
- 88
0
votes
1 answer
how to take dump of a table in parts and save it on different server?
I have a DB server and it has a table of 90 GB. Now I want to take a back up of that table.
But DB is almost full and I cannot take back up into the same server.
Is there any way of taking backup using mysqldump -u username -ppassword dbname…
Manojkumar
- 1,351
- 5
- 35
- 63
0
votes
4 answers
Do I need to use addslashes() when backing up database?
I am using the code shown here, it uses addslashes() on the data fetched from the database before saving to file.
$row[$j] = addslashes($row[$j]);
My question is why and do I need to use this? I thought you would do this when saving to the database…
arbme
- 4,831
- 11
- 44
- 57
0
votes
0 answers
SQL Server backup fails when issued via PDO
I'm talking to an SQL server 2005 using PHP's PDO API:
$mssql = new PDO('dblib:host=foohost;dbname=foodb', 'foouser', 'foopassword');
Subsequently, I want to backup the database to a local file as shown in the code below - which then fails.
$query…
Dave Vogt
- 18,600
- 7
- 42
- 54
0
votes
2 answers
Binary Log MySQL
I have some binary log files from localhost but when i write
mysqlbinlog mysql-bin.000001 > statament.sql
or a text file it just returns gibberish i.e.
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET…
pengwin
- 85
- 9
0
votes
1 answer
Copy database between Heroku apps using multiple URLs
Our database on Heroku has grown to size which requies three pgbackups URLs to download. I know how to download this database backup to local computer, merge the parts together and do restore, but what to do if I want to copy database from one…
Paul
- 25,812
- 38
- 124
- 247
0
votes
2 answers
How to check size of directory and possibly delete last file
Possible Duplicate:
How do I get a directory size (files in the directory) in C#?
I have a program which makes SQL Server backups. After every run it creates a backup file.
But the files are accumulating.
I´d like to add method which will be…
VilemRousi
- 2,082
- 4
- 24
- 34
0
votes
3 answers
How to speed up php backup script?
I have been using a mysql db backup script in php and the backups take 21 hours my dbs. I want to use it as a daily backup script through cli and cron and was wondering if you guys could take a look at it and see if there is anyway I can optimize…
Aaron Nguyen
- 195
- 1
- 3
- 14
0
votes
1 answer
Redgate Sql Azure Backup Doesn't See Database
When I am configuring Redgate's Sql Azure Backup tool to restore a database, it doesn't let me choose anything from my local Sql Express instance. Any idea why?
Dusda
- 3,347
- 5
- 37
- 58
0
votes
1 answer
Amazon S3: automatic deletion of certain files with s3cmd
I need a script for s3cmd that sends the deletion command for some files in my Amazon S3 bucket. I know there's this method built-in but it's not useuful. Let's see why.
At the moment I have a script that backups my database every midnight and my…
MultiformeIngegno
- 6,959
- 15
- 60
- 119