Questions tagged [dump]
The dump tag has no usage guidance.
26
questions with no upvoted or accepted answers
3
votes
1
answer
589
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 ...
3
votes
0
answers
916
views
How to do a pgdump with strings encoded?
When I perform a dump with pg_dump tool, with a "flat" sql format, pg_dump create a regular sql file but the restoration with pg_restore fails because the strings are not escaped.
For example, single ...
- 331
2
votes
1
answer
168
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
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
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 ...
- 181
1
vote
2
answers
957
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
1
vote
0
answers
481
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,363
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
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 ...
1
vote
0
answers
307
views
How to import sqlite from plain text dump?
This excellent XKCD article about color-poll data at the very end mentions:
If you have ideas and want to analyze these results further, I’ve posted the raw data as an SQLite dump here (84 MB .tar....
- 11
1
vote
0
answers
3k
views
How to export views and import it in other DB?
I am trying to export the database and everything is fine but I am not able to export the VIEWS.
Is it possible to export the views from sql queries and import it?
- 141
1
vote
0
answers
217
views
Is there any option to import specific databases from all databases dump
Is there any option to import only required databases from a all database back up .
- 11
1
vote
0
answers
4k
views
pg_restore and psql asks password for restoring dump file
This will be probably extreme novice question but I want to restore a .backup dump file. I have tried the following command:
pg_restore -i -h localhost -p 5432 -U postgres -d old_db -v C:/blabla/bla....
- 145
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 ...
- 141
1
vote
1
answer
1k
views
Escape characters in Oracle dump
When I take a dump of a particular table which has CLOB data type, the resulting dump doesn't handle escaping of special characters.
I get ' un escaped, so insert statements won't work.
Any ways to ...
- 123
0
votes
0
answers
32
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
0
answers
129
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. ...
0
votes
1
answer
212
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
0
votes
0
answers
206
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
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
0
answers
327
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
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
0
answers
291
views
Why can't I export this schema?
This is strictly a test system.
Command I'm executing is:
expdp XXXXX/XXXXX schemas=someSchema directory=DUMPDIR dumpfile=dump.dmp logfile=explog.txt
Environment settings:
ORACLE_SID=ORCL
...
- 147
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 ...
- 101
-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: ...
