Questions tagged [dump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
life777eternal's user avatar
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 ...
Saeed Neamati's user avatar
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 ...
Dominique's user avatar
  • 521
-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 ...
Jopsiton's user avatar
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. ...
Quynh Anh's user avatar
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 ...
user avatar
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 ...
Mikhail T.'s user avatar
6 votes
2 answers
452 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 ...
Depth of Field's user avatar
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 ...
Minsc's user avatar
  • 33
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 ...
TurboProgram's user avatar
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 ...
André Carvalho's user avatar
-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 's user avatar
0 votes
1 answer
392 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 ...
weno's user avatar
  • 115
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> ...
Basj's user avatar
  • 171
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(...); ...
Kokizzu's user avatar
  • 1,363
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 ...
Fariman Kashani's user avatar
-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 > /...
Jekson's user avatar
  • 101
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. ...
rdrg109's user avatar
  • 131
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 ...
Nabero's user avatar
  • 13
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,
Samrat's user avatar
  • 1
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?...
showkey's user avatar
  • 334
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 ...
Alpha's user avatar
  • 153
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 ...
nullromo's user avatar
  • 101
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, ...
Eric's user avatar
  • 253
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 ...
Tanooki Mario's user avatar
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 ...
SQLpro's user avatar
  • 509
1 vote
1 answer
427 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 ...
Grizz's user avatar
  • 11
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 ...
TheDataGuy's user avatar
  • 1,940
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 ...
Gheorghe  Isac's user avatar
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 ...
Jędrzej Dudkiewicz's user avatar
0 votes
0 answers
361 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 ...
Gryu's user avatar
  • 285
3 votes
2 answers
4k 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 ...
lucazpinheiro's user avatar
1 vote
2 answers
345 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 \...
dquake's user avatar
  • 11
0 votes
0 answers
43 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?
xorben's 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=...
Sushant Gosavi's user avatar
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 ...
Patrick's user avatar
  • 171
6 votes
1 answer
8k 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 ...
Imanol Y.'s user avatar
  • 785
3 votes
1 answer
44 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 ...
Johan Falkenjack's user avatar
0 votes
2 answers
662 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
0 votes
1 answer
114 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 ...
Racer SQL's user avatar
  • 7,386
0 votes
1 answer
321 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 ...
Tornike's user avatar
  • 103
0 votes
1 answer
550 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 ...
pkaramol's user avatar
  • 201
4 votes
2 answers
21k 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 ...
Bhaskar Dabhi's user avatar
3 votes
1 answer
1k 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 ...
Nir's user avatar
  • 523
3 votes
1 answer
2k 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 ...
Sai Kishan's user avatar
0 votes
1 answer
586 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 ...
Someone's user avatar
  • 223
1 vote
0 answers
216 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 ...
san shrestha's user avatar
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 ...
Matheus Sant Anna de Oliveira's user avatar
4 votes
1 answer
4k 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-...
eri's user avatar
  • 143
1 vote
1 answer
542 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 ...
koye's user avatar
  • 13