Questions tagged [dump]
The dump tag has no usage guidance.
134
questions
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
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
-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 ...
- 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. ...
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 ...
Bartłomiej Kanabus
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 ...
- 136
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
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
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 ...
- 11
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
-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: ...
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 ...
- 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> ...
- 161
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 ...
- 139
-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 > /...
- 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. ...
- 131
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 ...
- 13
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
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?...
- 284
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 ...
- 153
0
votes
2
answers
186
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, ...
- 253
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
...
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 ...
- 445
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 ...
- 11
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 ...
- 1,910
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 ...
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 ...
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
2
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 ...
1
vote
2
answers
296
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 \...
- 11
0
votes
0
answers
42
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?
- 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=...
- 101
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 ...
- 161
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 ...
- 775
3
votes
1
answer
41
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 ...
- 133
0
votes
2
answers
638
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 ...
user169425
0
votes
1
answer
108
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 ...
- 7,374
0
votes
1
answer
312
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 ...
- 103
0
votes
1
answer
485
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 ...
- 201
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 ...
- 141
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 ...
- 513
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 ...
- 31
0
votes
1
answer
556
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 ...
- 113
1
vote
0
answers
210
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 ...
- 11
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 ...
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-...
- 143
1
vote
1
answer
493
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 ...
- 13
1
vote
1
answer
389
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 ...
- 133