Questions tagged [dump]
The dump tag has no usage guidance.
134
questions
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 ...
CommunityBot
- 1
6
votes
2
answers
385
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 ...
- 233
0
votes
0
answers
26
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 ...
- 1,417
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 ...
CommunityBot
- 1
3
votes
1
answer
586
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
0
votes
1
answer
43
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 ...
- 523
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 ...
CommunityBot
- 1
1
vote
2
answers
946
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
4
votes
2
answers
13k
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 ...
- 1
68
votes
9
answers
121k
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
- 11
-1
votes
2
answers
57
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 ...
- 101
32
votes
4
answers
45k
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.
- 111
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,...
CommunityBot
- 1
0
votes
0
answers
123
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. ...
- 25.1k
49
votes
1
answer
76k
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 ...
- 24.7k
2
votes
1
answer
157
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 ...
- 38.6k
3
votes
4
answers
13k
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
...
- 111
0
votes
2
answers
161
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 ...
- 7,664
2
votes
0
answers
61
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 ...
- 33
0
votes
2
answers
36k
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 ...
CommunityBot
- 1
0
votes
1
answer
210
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 ...
- 126
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,201
-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: ...
Miguel Guzmán
0
votes
1
answer
340
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 ...
- 8,259
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 ...
- 283
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> ...
- 6,261
3
votes
4
answers
39k
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 ...
- 3,425
1
vote
0
answers
478
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,353
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 ...
- 13.9k
-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 > /...
- 8,259
1
vote
1
answer
388
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 ...
CommunityBot
- 1
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. ...
- 35.1k
1
vote
1
answer
912
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 ...
- 47.8k
0
votes
0
answers
201
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,
- 1
9
votes
1
answer
740
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 ...
CommunityBot
- 1
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 ...
- 11
1
vote
1
answer
34
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?...
- 7,917
0
votes
2
answers
187
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 ...
- 101
2
votes
2
answers
975
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, ...
- 76.9k
0
votes
1
answer
890
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 (...
CommunityBot
- 1
1
vote
1
answer
616
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 ...
- 47.8k
2
votes
1
answer
222
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 ...
- 1,024
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=...
- 1,402
2
votes
1
answer
94
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 ...
- 4,353
0
votes
0
answers
321
views
How to import db-sample-schemas into Oracle's DB?
I need to import some sample dump file for educational and testing purposes. I've found the next dump file and tried to import it using:
imp testuser/oracle file=/home/oracle/PurchaseOrders.dmp
...
- 275
4
votes
2
answers
20k
views
How to export oracle database version 12.1.0.2.0 with expdp Release 12.2.0.1.0
I am running following command to dump my database
./expdp username/password@//host:port/database directory=/home/ubuntu/oracle/instantclient_12_2 dumpfile=dumpfilename.dmp content=METADATA_ONLY
and ...
CommunityBot
- 1