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
2 answers
best practice for backup MySQL InnoDB tables?
What is the best practice for backing up MySQL InnoDB tables? (for myisam I use backuppc)
How can I do a backup and how can I restore it?
Thank you.
user3535392
- 23
- 5
0
votes
2 answers
Cassandra restore database to a newer version
I get backup from keyspace of the cassandra 1.2.4.When i restore the snapshot in version 2.0.5 of cassandra , I can't start service of cassandra.
I get this error:
could not access pidfile for Cassandra
When repair permissions of the directories of…
Hosein Masbough
- 431
- 1
- 4
- 19
0
votes
1 answer
oracle RMAN backup partitions
I have some partitioned tables based on the date of insertion of row.
I want to take back up of only a select partitions from the database using RMAN.
Is that possible ?
After taking the backup, can I delete those partitions from the database.
user2531191
- 579
- 10
- 27
0
votes
1 answer
How to backup a remote database phpMyAdmin in Java?
How do I backup a database that is running on phpMyAdmin through Java?
Thanks
user2269663
- 23
- 1
- 4
0
votes
0 answers
How to backup and restore MS SQL database with QT
My QT program is connected to a sql server which contains with many databases. How can I back up a specific database and all its tables and existing entries to my local drive? I am trying to make a button backup to the database I want to a file and…
user3400882
- 3
- 2
0
votes
1 answer
Affect of db availability during backups
How can we know if you database is available while the backup jobs are running ? Do backups affect the availability of the databases ?
Please let me know
Thanks
user3063530
- 79
- 1
- 2
- 11
0
votes
0 answers
Taking export backup of a database only upto certain date
I have an oracle database(10 g edition). I want to take the export backup of the database upto some particular date. The backup should contain all the upto that specific date. Is there any way to perform the operation?
0
votes
1 answer
How to restore and backup database
I need to restore the MySQL database that I used which is a service based database, when I click the button 'RESTORE DATABASE'. I'm using VB.Net 2010. I already did a research for any solution, but I can't come up with any idea how to make it work.…
user3105280
- 15
- 4
0
votes
1 answer
Pass a parameter from one batch file to another batch file
I have two batch files.
First extracts date from and creates folder in \YEAR\MONTH\DATE format.
@echo off
setlocal enabledelayedexpansion
:: Extract date fields
for /f "tokens=1-4 delims=/-. " %%i in ('date /t') do (
set v1=%%i& set…
vrun
- 3
- 3
0
votes
4 answers
MySQL database backup using PHP
I have used the following to check if exec() is enabled on my server:
public function exec_enabled() {
$disabled = explode(',', ini_get('disable_functions'));
return !in_array('exec', $disabled);
}
And I found out that it was enabled on my…
Kamran Ahmed
- 11,809
- 23
- 69
- 101
0
votes
0 answers
Update data between databases sqlite - ios
Here's my case
I've to replace my car company database file with a new one because of some structural changes.
The newer car company table (in the database) has some addition companies compared with the old one.
car company
( id,
companyname,
…
Pham Hoan
- 2,107
- 2
- 20
- 34
0
votes
0 answers
pg_basebackup PostgreSQL statement fails
I am trying to execute pg_basebackup command to take base backup but I do not see a success statement when I execute the command. Is there anything else where I went wrong?
pg_basebackup -h127.0.0.1 -U owner -D backup -Ft -z -P
0
votes
1 answer
how to backup some specific table from db and save the .sql to some location in my computer , using php code?
I need to take a backup of some selected tables in database.I have a form in my php page ,when clicking submit button on the form then the backup of selected table is stored to my computer as .sql or .sql zip file.
(eg: if db1 is my database name…
user3264607
0
votes
0 answers
mysqldump file - create table command not being executed
Background Information
While doing a backup / restore with mysql, I noticed that the restored database was missing a bunch of tables.
Code:
To create the dump file, this is the command that is being used:
mysqldump --databases widgetdb --master-data…
dot
- 14,928
- 41
- 110
- 218
0
votes
2 answers
How to backup and restore PostgreSQL Database in VB.NET with devart's dotconnect For PostgreSQL?
I am using dotConnect to connect to Postgres in my vb.net project. If anyone using this then provide a method to backup and restore using pgdump in a custom format i.e. mydatabase.backup, i have tried pgdump to backup but its backups the DB in .dmp…
user3223401