Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [dump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
71 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 ...
user avatar
0 votes
1 answer
40 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 ...
user avatar
-2 votes
1 answer
231 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
39 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 ...
user avatar
  • 115
3 votes
4 answers
738 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> ...
user avatar
  • 161
0 votes
0 answers
117 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(...); ...
user avatar
  • 1,199
1 vote
1 answer
114 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 ...
user avatar
-1 votes
1 answer
99 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 > /...
user avatar
  • 101
1 vote
1 answer
81 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. ...
user avatar
  • 111
1 vote
1 answer
103 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 ...
user avatar
  • 13
0 votes
0 answers
26 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,
user avatar
  • 1
1 vote
1 answer
20 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?...
user avatar
  • 126
0 votes
1 answer
981 views

ORA-31626: job does not exist during schema export

I'm exporting schema with following command - expdp system/system@xxx.xxx.xxx.xxx:1521/orcl schemas=schema-name directory=test_dir dumpfile=Schema.dmp logfile=SchemaLog.log but it results into ...
user avatar
  • 153
0 votes
2 answers
70 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 ...
user avatar
  • 101
2 votes
2 answers
346 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, ...
user avatar
  • 179
1 vote
3 answers
6k 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 ...
user avatar
9 votes
1 answer
457 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 ...
user avatar
  • 382
1 vote
1 answer
261 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 ...
user avatar
  • 11
1 vote
1 answer
111 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 ...
user avatar
  • 1,688
2 votes
1 answer
83 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 ...
user avatar
2 votes
1 answer
49 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 ...
user avatar
0 votes
0 answers
197 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 ...
user avatar
  • 273
2 votes
2 answers
3k views

How to restore a .backup file from a single table on postgres?

I have a .backup dump from a single table, but it didn't work restore like a normal backup from an entire db. I'm creating this backup file with the following batch script bin\pg_dump -h localhost -p ...
user avatar
1 vote
2 answers
88 views

does pg_dumpall run vacuum?

Can someone confirm if pg_dumpall does a vacuum? I cannot explain the size differences between a local and dumped database but thinking duplicate/rewritten entries are ignored 350mb inside psql with \...
user avatar
  • 11
0 votes
0 answers
34 views

ORACLE timed Datapump on Linux? (No crontab)

what is the best way to create a timed Datapump Dump of a PDB on a Linux System? No Crontab. And how do I implement it?
user avatar
  • 1
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=...
user avatar
3 votes
1 answer
3k 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 ...
user avatar
  • 141
6 votes
1 answer
4k views

Fastest way to extract full table in Postgres

I'm trying to dump a table with 50M records to a file, and my goal is to reduce the time in which this action is performed. I usually use the COPY metrics TO 'metrics.csv' DELIMITER ',' CSV; This ...
user avatar
  • 767
3 votes
1 answer
37 views

Lock database in time

I'm currently working with prototyping some stuff with a dump of a MySQL (5.7) database where much of the data is time dependent. Most of the queries I write use the NOW() function and the results ...
user avatar
0 votes
2 answers
452 views

Cannot restore postgres dump file

When i try to restore a database from a dump file using the following command: \i C:/pathname/dumpfile.txt from within my sql shell, it runs the first few lines of the dump file and then I get the ...
user avatar
  • 11
0 votes
1 answer
70 views

Question about Dumps in Oracle (REMAP_SCHEMA)

To export a dumpfile, I can: EXPDP system/Password@TNS DUMPFILE=FileName.dmp Schemas=TheSchemaIWantToDump DIRECTORY=dumpdir So, let's say I want to restore this DMP file, but with a different ...
user avatar
  • 7,100
0 votes
1 answer
202 views

Copy Table from one MySQL server to another

Is there a way to copy or export a large table from MySQL server to postgres without affecting servers performance. I mean the table is very large and using mysqldump or any select query has bad ...
user avatar
  • 103
0 votes
1 answer
221 views

Multiple concurrent sql dumps in mysql

My question is whether it is safe to perform multiple dumps at the same time in mysql, i.e. running: mysql -u root -p database1 < database1.sql mysql -u root -p database2 < database2.sql on ...
user avatar
  • 171
4 votes
2 answers
17k 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 ...
user avatar
1 vote
1 answer
526 views

Change pg_dump directory output to table name instead of object number

pg_dump -F d will result in multiple <number>.dat.gz files which represent the object number in the database. I wish pg_dump create those files in the format <table name>.dat.gz instead so ...
user avatar
  • 383
3 votes
1 answer
1k views

Is it possible to backup a subset of a database in Microsoft SQL Server?

Using Microsoft SQL Server, is there a way to backup a subset of a production database? I only want the database structure, and a very small amount of transaction data for a few selected tables. I ...
user avatar
0 votes
1 answer
381 views

MySQL verify backups [duplicate]

There's standalone MySQL server 5.5 with no slaves. Daily dump is created using mydumper tool. Is there any way to verify created dump (all tables are created, integrity, etc.) without restoring ...
user avatar
  • 113
1 vote
0 answers
161 views

MySql could not restore whole dump file

MySql cluster is unable to restore whole dump file. Error: MaxNoOfConcurrentOperations and increase MaxNoOfAttributes This is the command I tried: mysql -u username -p create database ...
user avatar
0 votes
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 ...
user avatar
4 votes
1 answer
3k views

Parsing COPY's binary format to access a tsrange

How is tsrange stored in binary? For example create table CREATE TABLE public.test (t tsrange); INSERT INTO test VALUES ('[2010-01-01 14:30, 2010-01-01 15:30)'); INSERT INTO test VALUES ('[2011-01-...
user avatar
  • 143
1 vote
1 answer
286 views

How do I get the GRANT statements for a specified schema?

Is there a way to generate the GRANT statements that have been run on a schema in PostgreSQL, for example if myUser has been granted usage on mySchema the script would generate GRANT USAGE ON SCHEMA ...
user avatar
  • 13
1 vote
1 answer
328 views

Need help on expdp and impdp concept [closed]

I have a multiple databases i.e (database1,database2) and i need to export a table from database1 to database2 . Here are the commands i tried expdp hr/oracle@oracle tables=emp directory = ora ...
user avatar
-1 votes
2 answers
5k views

ORA-01555:Snapshot too old error during execution of expdp command [duplicate]

After performing expdp command in production database (Oracle 11g - linux): expdp abc/123 DIRECTORY=data_pump DUMPFILE=SA10_%u.dmp LOGFILE=SA10.log TABLES="abc"."/1FE/019" PARALLEL=4 CONTENT=...
user avatar
  • 17
1 vote
1 answer
10k 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,...
user avatar
  • 4,595
1 vote
1 answer
358 views

Importing CouchBase dump to BigQuery

After creating a CouchBase dump and copying it to a Google Storage bucket I tried importing the data to BigQuery. I failed miserably, apparently the design.json or the files that appear in the same ...
user avatar
  • 121
3 votes
2 answers
5k views

Recovering data from SQLite .db File Data

To give a bit of background, I was looking for the occurrence of specific text from within multiple SQLite DB files. I initially tried a simple grep of the text on the multiple files and grep found ...
user avatar
  • 33
2 votes
1 answer
9k views

Restore/import tables from unsuccessful database dump file

I'm in an urgent need of restoring a backup dump taken three weeks ago which was not completed successfully. I'm using Oracle 11g database in nonarchive log mode. The export command used was as ...
user avatar
  • 121
5 votes
1 answer
2k views

PostgreSQL auto-vacuum: "skipped frozen" pages causing massive bloating

I am having a problem with a table I am using for a forum where people can add their products. Everytime a user loads a page, the "online timestamp" of the user gets updated (a PHP line prevents it ...
user avatar
1 vote
1 answer
8k views

Datapump export taking too much time to complete

I've scheduled to take a backup of my oracle11g database, daily at 11pm via Windows Task Scheduler. At this time, I'm not letting my database to go down. Also, my database is in noarchivelog mode. ...
user avatar
  • 121
0 votes
2 answers
30k 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=...
user avatar
  • 152