Questions tagged [dump]

The tag has no usage guidance.

26 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
1 answer
605 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 ...
Martin Vegter's user avatar
3 votes
0 answers
937 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 ...
Rémi B.'s user avatar
  • 351
2 votes
1 answer
279 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
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
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 ...
Björn's user avatar
  • 181
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
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
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
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
1 vote
0 answers
318 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....
iLie's user avatar
  • 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?
Joomler's user avatar
  • 141
1 vote
0 answers
218 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 .
Preity's user avatar
  • 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....
mctuna's user avatar
  • 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 ...
Rudy's user avatar
  • 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 ...
Hero's user avatar
  • 123
0 votes
0 answers
142 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
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
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
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
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
0 answers
362 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
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
0 answers
300 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 ...
user447607's user avatar
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 ...
User981636'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