I made a dump of my db using dumpdata and it created a 500mb json file now I am trying to use loaddata to restore the db, but seems like Django tries to load the entire file into memory before app...

I started using Managed Backups on my SQL server. It has been working well for over a year. It seems to backup the dbs once a week, and take incrementals every 2 hours. A month ago, we changed our...

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error: $ >mysql -u root -p -h localhost -D database...

Im trying to write a query that will tell me how much time a restore (full or log) has taken on SQL server 2008. I can run this query to find out how much time the backup took: select database_na...

I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a "bak" file. I do this by overwriting an existing database. In the "Options" page, there is a check-box ...

For some reason I have to uninstall SQL Server 2008 R2 but before that I copied two files (.mdf and .ldf) of my database from C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQL2008\MSS...

How to insert the resultset given by the commands RESTORE FILELISTONLY RESTORE HEADERONLY RESTORE VERIFYONLY into an automatically generated temp table ? I would like to use a technique similar...

I am using Postgres for a django project and I am currently implementing a database backup/restore system that as simple as possible performs a pg_dump when the user clicks backup and then pg_resto...

I am trying to run a classic asp project on visual studio and therefore I am trying to restore a database. I cannot seem to find the .bak file when trying to restore it. It wasn't visible in the C-...

I have a dump file with a .SQL extension (in fact it is a plain-text SQL file). I want to restore it into my created databases. I am using pgAdmin III, and when I use its "Restore Wizard" it does n...

I made daily backups of a postgresql DB using the command /usr/bin/pg_basebackup -D $outdir -Ft -x -z -w -R -v Now I want to restore this DB on another server. I used the description on https://...

I am new for psql. I got from my server data.dump file. I need to restore it in my local. I tried these commands. i) psql -U postgres dbname -f servicedb.dump Error: psql: warning: extra command...

I did backup on database on different server and that has different role than I need, with this command: pg_dump -Fc db_name -f db_name.dump Then I copied backup to another server where I need t...

Due to high i/o cost we want to migrate from aurora(Postgres engine) to Postgres. Is there any way to do this. If no is rebuilding the entire dataset is the only option?

I want to create a database snapshot and restore database to it every time a unit test is run. I am able to create snapshot but while restoring it, I encounter the error below while doing it. M...

I'm moving a large (~80GB) database from its testbed into what will be its production environment. We're working on Windows servers. This is the first time we've worked with MySQL and we're still l...

I'm trying to restore a backup from a .bak file to a local database server and keep getting the error message. An exception occurred while executing a Transact-SQL statement or batch.(Microsoft....

I have a file with .bak extension. How can I import this file data to a database in SQL Server?

RESTORE DATABASE Tes FROM DISK = '{7522204E-0256-47B3-9864-137D6D1FD449}6' WITH MOVE 'Test' TO 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\Tes.mdf', MOVE 'Test_log' ...

I was able to recover the database folder of MySQL server 5.5 of the corrupted operating system (Windows XP) at C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data\ ...

I have an empty database: DB_Clients And I want to restore the database from a .bak file: OldDBClients.bak This is the path: C:\OldDBClients.bak And this is my script: USE [master] GO R...

I'm not very fluent with SQL Server commands. I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path. I can do: restore filelis...

I am trying to restore the directory dump of mongodb. i am doing mongorestore --db mydb --drop path/to/mydb/dump But both does not able to restore the state of my dump. Any new records are vis...

I'm trying to write an automated backup and restore T-SQL scripts. I've done BACKUP part but I'm struggling on RESTORE. When I run following statement on SS Management Studio; EXEC('RESTORE FILE...

The following command in a cmd window sqlcmd -S. -Usa -Ppass -dmaster -Q "RESTORE DATABASE [MYDATABASE] FROM DISK = 'D:\SQL Server\MYDATABASE.BAK' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10&...