Questions tagged [dump]
The dump tag has no usage guidance.
134
questions
-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=...
- 17
2
votes
1
answer
12k
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,...
- 4,757
1
vote
1
answer
387
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 ...
- 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 ...
- 133
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 ...
- 141
6
votes
1
answer
3k
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 ...
- 61
2
votes
1
answer
9k
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. ...
- 141
0
votes
2
answers
36k
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=...
- 152
0
votes
3
answers
2k
views
Issue in DB export
I've scheduled to export my database at every midnight via Windows Task Scheduler. This was properly exported for so long. But, recently in some days, export is not happening as required. The logs are ...
- 141
1
vote
1
answer
11k
views
Difference in database dump file size
Actually I am bit confused with my database export, while i exporting it shows "Total estimation using BLOCKS method: 20.83 GB" But my DB export dump is only 6 GB. Few days back we deleted some ...
- 152
3
votes
2
answers
6k
views
Sequence number shows a lower value after dump file import
I'm using Oracle 11g database in which I have more than 12 schema's consisting of many tables. I've created sequences for primary keys to these tables. I've also created synonyms to refer my ...
- 152
1
vote
1
answer
17k
views
How do I disable foreign key constraints in my Postgres dump file?
I’m using Postgres 9.5. I have created a dump file of INSERTs for three of my tables. To avoid getting foreign key errors, I added the below to the top and bottom of my file (the “…” is where all ...
- 643
0
votes
1
answer
11k
views
How do I export Postgres data in "Insert ... on conflict" format instead of "cp" format?
I’m using Postgres 9.5 on Mac Sierra. I want to export some records from my local db and import them into a db on a Linux machine (also running PostGres 9.5). I’m using this command to export data ...
- 643
0
votes
1
answer
892
views
SQL log directory has too much dump file
My SQL Server 2014 is automatically creating SQL dump file. It is generating automatically to take all the spaces and hangs over the database.
Error: 8310, Severity: 16, State: 1.
Cannot create (...
- 121
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
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 ...
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
32
votes
4
answers
45k
views
how to track progress of a large postgres dump
Is there a way to see the progress of a pg_dump operation on a big db (ie > 1GB)? adding the -v option just dumps text on the screen, but doesn't give me much meaningful tracking information.
- 423
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
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
1
answer
1k
views
mysql restore specific date data from a dump file
I have mysql [version 5.6] database dump file. I want to restore only one day data from that dump file.
Anyone has any clue ?
- 21
0
votes
1
answer
2k
views
Dump specific tables from DB2 database
Is there any command line tool that I can use on a DB2 database to dump a specific set of tables?
The problem is that I work in an application that its database tables was created in an existing ...
- 183
10
votes
4
answers
38k
views
Dump Oracle database into a textual SQL script
I am thinking on what mysqldump or pg_dump are doing. So, they dump an active database into a textual file containing the SQL queries, which reproduce this whole database. In MySQL and in PostgreSQL, ...
- 2,057
0
votes
1
answer
7k
views
incompatibility of max_allowed_packet in mysql
I have a client and I want to dump a row such as :
$ mysqldump -uroot -p pahlevan_azad mp_posts --where="id='655'" --max-allowed-packet=1024 > dump.sql
Warning: option 'max_allowed_packet': ...
- 113
4
votes
1
answer
2k
views
Mongodb incremental oplog Dump not working
I am not able to take an incremental oplog dump. I am not getting any error messages the connection happens fine and also there is a operation recorded(shows up in db.currentOp()), but still nothing ...
0
votes
1
answer
7k
views
Mysqldump.exe Unknown option --no-beep
When I try to run the command :
"C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin\mysqldump.exe" -u root -p******* my_database > backups/my_database_backup_20151221121320.sql
it says
mysqldump:...
0
votes
1
answer
2k
views
Number of rows in SQL dump [closed]
Is there any way to check how many rows are in an SQL dump file? I have a large 32GB dump, and wanted to check how many rows are in the file.
I am using a windows machine with a MySQL server,
Thanks!...
- 1
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
0
votes
2
answers
214
views
Is dmp file suitable despite ORA-01555 'snapshop too old' warnings?
Well, the title of the question is self-explanatory.
Export finished successfully with warnings.
Log shows several ORA-01555 snapshot too old errors.
- Is it OK to use that dmp file to perform an ...
- 713
6
votes
1
answer
4k
views
pg_restore warning column X has type unknown
I'm doing a dump from PostgreSQL 9.1 and restoring on PostgreSQL 9.4 and getting this warning
pg_restore: WARNING: column "foobar" has type "unknown"
DETAIL: Proceeding with relation creation ...
- 1,355
4
votes
1
answer
2k
views
Why does an sqlite3 .dump and restore result in a smaller database file size?
I have a really naive question about database file sizes. I started out with a 1.2M SQLite database, dumped it to a SQL file, and then restored it to a new database. The restored database file was ...
- 345
3
votes
2
answers
1k
views
I really can't get rid of these conditional statements in mysqldump?
My mysqldump DDL file is filled with tons of this:
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `my_trigger`...
I've searched to no avail for an option to silence this.
...
- 275
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
4
votes
2
answers
1k
views
An easy way to select one db dump from multiple db MySQL dump
In an urgent situation another person made a backup of all the databases from my webserver to one *.sql file (MySQL dump). Now I have a ~700 Mb file with about 20 different databases. As I only need ...
2
votes
1
answer
2k
views
PostgreSQL - partial dump of large objects (pg_largeobject table)
Context : Our web-app is like a collaboration platform where you can share files, appointments, survey and so on. An instance of this web-app is divided in communities, each one is independent to each ...
- 283
68
votes
9
answers
121k
views
Export Postgres table as json
Is there a way to export postgres table data as json to a file? I need the output to be line by line, like:
{'id':1,'name':'David'}
{'id':2,'name':'James'}
...
EDIT: postgres version: 9.3.4
- 1,749
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
1
vote
1
answer
244
views
How can i make dump of big mysql table? [closed]
I have server with db(36Gb data), only mysql access. When i'm trying to use mysqldump utility, i get connection timeout(or something like this).
I doesn't have ssh access for copy /var/mysql/data.
It'...
- 111
1
vote
1
answer
6k
views
Expdp with metadata_only gives way too large dump. Why?
There is an oracle 11g schema with amount of data about 700 Gb. There are tables/indexes only in that schema, no procedures/packages.
Doing expdp on that schema
expdp schemas=TheSchema directory=dir ...
- 111
0
votes
1
answer
9k
views
Export data tables from SQLPlus [duplicate]
Is there any way to export data from an Oracle SQLPlus console, without using the exp or expdp commands? I don't have sysdba privileges.
I'm not a real Oracle guru so I'm using Navicat to export but ...
- 101
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
1
vote
1
answer
935
views
Postgres database dump and restore on different database [closed]
I have two Postgres databases on the same server, which have the same schemas.
The goal is to have DB1 as the production and DB2, as the database that will receive all the data that is migrated from a ...
- 121
2
votes
1
answer
2k
views
Oracle dump to csv and keep NULL as empty string
I have the following sql file:
SET COLSEP ';'
SET ECHO OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET PAGESIZE 32766 -- Maximum number we can set.
-- i.e there will be duplication of ...
- 141
0
votes
2
answers
5k
views
Export, based on query, into INSERT text file
I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
- 433
2
votes
2
answers
950
views
Restore large MySQL dump thorugh EasyPHP
I am trying to upload large files on easyphp but as there is limitation on this software and large databases cannot be uploaded. Is there some other software that allows to import large databases? ...
stella
0
votes
1
answer
4k
views
SYS.DBMS_INTERNAL_LOGSTDBY causes error on dump import
I'm having problems importing a dump into an Oracle XE Database.
The import worked for several other people, so I can assume that the dump is not corrupt.
In ran the following command:
C:\Users\...
- 101
1
vote
1
answer
6k
views
Importing Oracle database from dump where source db filesystem has changed
I'm migrating a database from one server to other. In the migration process we changed the filesystem structure from :
/appli2/oradata05/HISTO/
/appli2/oradata06/HISTO/
/appli2/oraredolog01/HISTO/
/...
2
votes
1
answer
1k
views
Why does importing a MySQL dump cause so many I/O?
I imported 100 SQL-format dump files. The total size was 20 GB. The resulting .ibd files after the import had a total size of 40 GB. mysqld.exe wrote 1.1 TB and read 120 GB on the disk. Why so many I/...
- 2,033
4
votes
2
answers
8k
views
How to create a blank version of a PostgreSQL database
I've been using pgAdmin to create a database and test it.
I'm at a point now where I need to install this db on different servers. I've been using pg_dump to do this and I've been able to muddle my ...
- 751
7
votes
1
answer
7k
views
How to change temporary directory for pg_dump?
I'm running out of space from my hard drive which has a 18GB PostgreSQL database.
When I try pg_dump to a different drive, PostgreSQL creates temporary files on the disk it's dumping from, so I run ...
- 325