Questions tagged [dump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
277 views

How to (pg_)restore selected tables with all indexes?

I would like to restore selected (currently after -t) tables including all indexes without making a definition after -I - because indexes are changing, new ones are created, old ones may expire. What ...
0 votes
1 answer
2k views

ORA-31626: job does not exist during schema export

I'm exporting schema with following command - expdp system/[email protected]:1521/orcl schemas=schema-name directory=test_dir dumpfile=Schema.dmp logfile=SchemaLog.log but it results into ...
1 vote
1 answer
16 views

How to import MySQL RAW Database files without connection error

unfortunately I did not create a 'dump' file with the backup (Data Export) process on MySQL Workbench 8.0.26. When I copy the old database files to the new Data directory, the server fails to start ...
1 vote
1 answer
1k views

Restoring dump(backup): ERROR 1022 (23000) at line 44: Can't write; duplicate key in table

I'm doing tests to change a current table from my InnoDB database to Archive, but I had a problem trying to restore a dump after the change. After several tests, the problem is related to the value ...
3 votes
1 answer
605 views

investigate contents of a sqlite3 file

I have created a new, clean firefox profile from scratch, and added couple of bookmarks. These, I have learned, are stored in places.sqlite file inside the profile directory. This file seems to be too ...
2 votes
1 answer
2k views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
1 vote
1 answer
2k views

How do I import a dump for a deleted tablespace?

I'm trying to import a database dump, however I am encountering this error: ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error: ORA-00959: tablespace '_$deleted$5$0' does not ...
0 votes
1 answer
1k views

Restore .dmp file into csv

We have asked our clients for certain data in a csv file format and we just got a .dmp file. I have been trying to open it using MySQL as if it were .dump but it doesn't work. I have seen other ...
1 vote
2 answers
1k views

Problem importing a Dump on MariaDB (Ubuntu 20.04.4 LTS)

I am writing this post because I cannot import a dump on MariaDB (Version 15.1) using Ubuntu 20.04.4 LTS. I did this dump a few weeks ago and now trying to import it using the command mysql -u root -p ...
0 votes
3 answers
5k views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
6 votes
2 answers
453 views

SQL Server generating sporadic Memory Dumps

We're running a 2014 SQL Server. For the past couple of years, the server generates memory dumps with no rhyme or reason, every 2-7 days, locking up most processes, and forcing us to restart the SQL ...
0 votes
0 answers
141 views

ERROR 4078 (HY000) at line 167956: Illegal parameter data types uuid and int for operation '='

I'm using this command to backup all of my MariaDB databases and gzip them all: mariadb-dump -pPassword --all-databases --routines --events --single-transaction | gzip -c > dump.sql.gz Then I copy ...
0 votes
1 answer
73 views

humanly readable dump of an SQL-Server database

I am looking for data, but I don't know the name of the table, neither of the column. As you might know, it's possible to create the backup of an SQL-Server database. Launching a grep on that backup ...
4 votes
2 answers
14k views

What to look for in bad pg_dump log

We want to programmatically detect errors in cron scheduled pg_dumps. Apart from cheking whether or not the log file ends in "pg_dump: saving database definition": What other tell-tale string can I ...
71 votes
9 answers
125k views

Export Postgres table as json

Is there a way to export postgres table data as json to a file? I need the output to be line by line, like: {'id':1,'name':'David'} {'id':2,'name':'James'} ... EDIT: postgres version: 9.3.4
-1 votes
2 answers
101 views

How can I make a huge (140Gb) sql dump of a MariaDB database?

I need to make a dump to my database with approx. 140 Gb. Can I just run the command to the whole database? Do you know if there are some limits for the dumps? Dumping remotely. I need this dump to ...
35 votes
4 answers
49k views

how to track progress of a large postgres dump

Is there a way to see the progress of a pg_dump operation on a big db (ie > 1GB)? adding the -v option just dumps text on the screen, but doesn't give me much meaningful tracking information.
2 votes
1 answer
12k views

Non-yielding Scheduler Error with dump caused by heavy queries on SQL 2016

After bringing our databases to new servers with new hardware and new os (2012 server) and new SQL Server version (2016 sp1) we face the following issue: During nightly reporting database update runs,...
0 votes
0 answers
198 views

Why am I getting the error "Object ... was not found" when importing a dump?

I want to import a dump file but I have this error: Import: Release 19.0.0.0.0 - Production on Wed Feb 22 07:56:35 2023 Version 19.16.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. ...
49 votes
1 answer
78k views

Dump only the Stored Procedures in MySQL

I need to dump only the stored procedures : no data, no table creation. How can I do this using mysqldump?
3 votes
2 answers
6k views

Sequence number shows a lower value after dump file import

I'm using Oracle 11g database in which I have more than 12 schema's consisting of many tables. I've created sequences for primary keys to these tables. I've also created synonyms to refer my ...
4 votes
4 answers
14k views

Why is Microsoft SQL Server creating a ton of dump files?

How to determine what is causing Microsoft SQL Server to create dump files over and over taking up 170 GB of disk space? How do I troubleshoot what is causing the dumps? The path of the dump files is ...
0 votes
2 answers
189 views

Can Oracle dump to stdout?

We're automating the nightly transfer of several databases from production into a "T-1" (or "yesterday") environment. It takes a while currently: the source server has to dump the ...
2 votes
0 answers
77 views

Mysql shell seems not to dump deterministically. How can I minimise data transfer when rsyncing subsequent dumps?

What I'm trying to do is generate a full dump of my database using mysql shell, like so: util.dumpSchemas(["my_db"], "outdir", {threads:88, bytesPerChunk: "256M"}) And ...
0 votes
2 answers
37k views

Encountering "Snapshot too old" error during execution of expdp command

As am facing an issue while performing expdp command in my production db.(Oracle 11g in windows enviornment) cmd> expdp 'sys/123@PROD as sysdba' DUMPFILE=BACKUP_02082017_BACKUP.dmp LOGFILE=...
4 votes
1 answer
5k views

Database size twice as large after mysql dump and re-import

After exporting and re-importing a mysql database, the size of the database on disk appears to be quadrupling in size. Any ideas why this my be? This is occurring when importing the sql dump right ...
0 votes
1 answer
224 views

Best way to run performance tests in a production PostgreSQL 13 database?

First, I'm asking this question because I'm studying to be a DBA. Recently I learned a lot about database locking, and then some questions arouse in my mind. Suppose I'm a DBA, I'm in charge of a huge ...
1 vote
6 answers
36k views

How can I convert an Oracle dump file into SQL Server?

I want to ask about converting Oracle dump files (.dmp) into SQL Server files (.bak) where during conversion I don't have to be connected to any database server. I've searched for related ...
-2 votes
1 answer
3k views

pg_dump - aborting because of server version mismatch

El error se genero tratando de generar el DUMP: pg_dump -h 192.168.0.56 --no-owner -U user name_db > /var/tmp/dump.sql Output: pg_dump: server version: 12.3; pg_dump version: 9.2.24 pg_dump: ...
user avatar
0 votes
1 answer
393 views

Should databases be dumped to SQL format or custom archive?

I am wondering, what is the industry standard regarding dump formats, when making and storing the database dumps? Is it better to dump it to a custom-format compressed and unreadable archive, or just ...
2 votes
1 answer
2k views

PostgreSQL - partial dump of large objects (pg_largeobject table)

Context : Our web-app is like a collaboration platform where you can share files, appointments, survey and so on. An instance of this web-app is divided in communities, each one is independent to each ...
3 votes
4 answers
2k views

How to import only a specific database from a .sql file?

I have a file dump.sql with many databases in it: mydb1, mydb2, mydb3, etc. How to import only mydb3 and not the other databases? Won't: mysql> create database mydb3; mysql> use mydb3; mysql> ...
3 votes
4 answers
40k views

Opening a .backup file for PostgreSQL

I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise. In short, I have what I think is a ...
1 vote
0 answers
541 views

pg_dump with proper table dependency analysis?

Is it possible to dump then recreate with proper table analysis, so for example if table A depends on table B, then table B will be dumped first, then the table A something like CREATE TABLE B(...); ...
1 vote
1 answer
1k views

mysql - import only data from full dump?

I have a full dump from database A. I want to import only the data of this dump into database B. Database B's structure is the same as database A only it misses some tables. How can I do this? The ...
-1 votes
1 answer
1k views

Postgresql: restore database from dump sql file error [closed]

There is a database that runs in the docker container . I need to make a local copy of this database. To do this I use the command docker exec -t 5a5c84157ffe pg_dumpall -c -U postgres | gzip > /...
1 vote
1 answer
428 views

Why is the schema/structure dump so slow? [closed]

I'm using Rails 6 with activerecord-oracle_enhanced-adapter adapter for Oracle 11 XE database. At the beginning of the project I was working with Postgres, but due to customer requirements I had to ...
3 votes
1 answer
1k views

What are the benefits of using XML over CSV files in regards to data dumps? [closed]

Prologue I've noticed that one benefit of using CSV over XML for data dumps is the fact that fewer disk space is used. See minimal working example below. Let's suppose we have the following dataset. ...
1 vote
1 answer
1k views

pg_dump while inserting data

I need to dump some tables of my postgres database and I am scared of getting inconsistent data.The database is verly large and the dump lasts some minutes. On my research I found a command to dump ...
0 votes
0 answers
231 views

Remove inserted data from wrong dump file

I often backup my mysql db. But recently I have imported wrong dump file. Is there any way to revert the situation? BR,
9 votes
1 answer
777 views

2019 Enterprise - NOLOCK without NOLOCK, page latch time-out on tempdb and finally a dump [closed]

We have a very strange problem with a new SQL Server 2019 on 2 new physical machines: Infrastructure: Starting a new installation of SQL Server 2019 Enterprise (15.0.2000.5 / X64 on Windows Server ...
3 votes
2 answers
2k views

How to dump an advanced revelation database? [closed]

Retail store I work with has an ancient inventory/accounting/receiving system that is based off Advanced Revelation. They run the DOS and Windows clients. I'd like to get a dump of their data to ...
1 vote
1 answer
36 views

dump selected result with fields name

It is simple to dump select result into a file: select * from table_name into outfile result.txt; The result.txt contains records ,but no fields in it,how can dump selected result with fields name?...
0 votes
2 answers
209 views

Can't Dump Database Because MS SQL Server Management Studio Won't Show Any Databases If 1 Is Permission Denied

I am logged into SQL Server Management Studio with an account that has access to multiple databases, but not DB_123. As shown in the picture below, clicking to expand the "Databases" folder ...
2 votes
2 answers
1k views

Mysql dump as small bulk insert

In mysql (8.0), there is a table with over 10 million rows, I want to dump it as bulk insert sql. I wish each insert sql contains maybe 1k or 10k rows, so that could execute the sql file quickly, ...
0 votes
1 answer
916 views

SQL log directory has too much dump file

My SQL Server 2014 is automatically creating SQL dump file. It is generating automatically to take all the spaces and hangs over the database. Error: 8310, Severity: 16, State: 1. Cannot create (...
1 vote
1 answer
709 views

PostgreSQL Generate create Foreign keys from information_schema or pg_constraint

Recently on a testing infrastructure, to restore multiple tables (via copy command) I dropped all the foreign keys. I have restored this database schema dump into a different database before dropping ...
2 votes
1 answer
233 views

Large MySQL database dump/restore [closed]

Got a quite interesting task: Have to dump mysql databases from AWS and restore on a private cloud. Databases are quite big: 160GB, 120GB and 21GB each db.sql dump - all 3 in the same aurora rds ...
0 votes
2 answers
2k views

Tablespace 'XXX_SML_INDEX' does not exist using impdb

I am new in oracle. I am trying to import an Oracle database from one machine to another by using a dump file. I'm using the below command for the import impdp MOBILETEST/MOBILETEST directory=...
2 votes
1 answer
104 views

SQL Server - dump schema into separate files keeping installation order

While dumping SQL Server's schema, I have these two options: single file or multiple files. Single file is good because is can be used to install schema on clean server - parents are installed before ...