Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
3
votes
1answer
898 views
How large will a MySQL database be relative to the dump file?
I'm restoring a ~52GB dump to a MySQL database. The ibdata1 file has already exceeded the size of the dump file and the restore is still incomplete. Is there any way to estimate the final size of the ...
9
votes
3answers
2k views
Is it possible to restore sql-server bak and shrink the log at the same time?
We have a bak file from a client that we have transferred to our developer offices for problem investigation. The backup is currently 25GB and the restored database is about the same size however it ...
3
votes
2answers
221 views
Getting recovered db files to work on rebuilt server
I've had to rebuild my server and have tried to copy the database files from the old drive to /var/lib/mysql/. I have restarted apache and run 'show databases', this list all the databases. I have ...
2
votes
2answers
1k views
Restore Database script
I have a live database which i would like to create a backup and restore script that will take the "live" database every night, create a back, then drop the existing "testing" database (if any) and ...
5
votes
1answer
3k views
Cannot connect to DB2 database after restoring an offline backup
This is for DB2 9.7 Enterprise Server Edition on AIX.
I had a full, offline backup taken of several databases within our instance in a performance environment.
I wanted to restore these databases to ...
3
votes
2answers
205 views
How to wait for PostgreSQL to be startable / restorable?
I'm testing a PostgreSQL 8.2.1 to 9.2 upgrade on a virtual machine running a custom Linux distro. The upgrade procedure is as follows:
Start the pg service
Vacuum all DBs (not sure if this is ...
1
vote
1answer
316 views
DB2 Online Restore but Without Roll Forward?
I read a lot of documentations for db2 restore but I could not find how to perform online restore from the last database backup but without roll forwarding of logs?
I will appreciate command ...
1
vote
0answers
96 views
pg_dump dumps casts after views using them [closed]
My small but annoying problem is that the regular backups of a database of ours always list the user-defined casts after those views that would make use of them. For this reason I have to maintain a ...
1
vote
1answer
2k views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
0
votes
2answers
178 views
Restore the latest backup on the database
We have a stored proc which takes the backup from a database to the specified location. Sometimes the backup process runs more than once. It causes having more than one backup set on the same file ...
-1
votes
1answer
47 views
Restore oracle database from DBF files [closed]
I have a list of DBF oracle files and I need to rebuild a database from these files, but I am a little newbie in oracle db administration
http://s9.postimg.org/mxmx0g73j/Untitled.jpg
