Questions tagged [dump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
15 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 ...
2
votes
1answer
37 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
1answer
36 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
0answers
63 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 ...
1
vote
2answers
386 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
2answers
28 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 \...
0
votes
0answers
34 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?
0
votes
0answers
13 views

Mysql, dump all databases based on user privileges or owning

Question Is possible dump all databases based on users privileges or owning. I mean all databases, where user has all privileges, or is the owner. Example mysqldump --all-databases ...
0
votes
2answers
684 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=...
2
votes
1answer
1k 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 ...
3
votes
1answer
1k 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 ...
3
votes
1answer
34 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 ...
0
votes
2answers
250 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 ...
0
votes
1answer
65 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 ...
0
votes
1answer
62 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 ...
0
votes
1answer
102 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 ...
3
votes
2answers
9k 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 ...
1
vote
1answer
245 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 ...
3
votes
1answer
771 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 ...
0
votes
1answer
186 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 ...
0
votes
1answer
866 views

pg_restore: [archiver] could not find entry for ID 12

I'm trying to restore a dump (-Fd --data-only) from PostgreSQL v9.4.9, but I've come across the following error: pg_restore: [archiver] could not find entry for ID 12 Exactly the same happens if ...
1
vote
0answers
140 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 ...
0
votes
1answer
662 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 ...
2
votes
1answer
2k 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-...
1
vote
1answer
188 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 ...
1
vote
1answer
284 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 ...
-1
votes
2answers
4k 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=...
1
vote
1answer
6k 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,...
1
vote
1answer
277 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 ...
2
votes
2answers
4k 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 ...
2
votes
1answer
7k 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 ...
5
votes
1answer
906 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 ...
1
vote
1answer
7k 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. ...
1
vote
1answer
22k 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=...
0
votes
3answers
1k 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 ...
1
vote
1answer
7k 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 ...
2
votes
1answer
2k 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 ...
1
vote
1answer
12k 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 ...
0
votes
1answer
6k 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 ...
0
votes
1answer
362 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 (...
1
vote
0answers
239 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....
3
votes
1answer
390 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
0answers
213 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 ...
14
votes
2answers
14k views

how to track progress of a large postrgresql 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.
2
votes
1answer
852 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 ...
1
vote
0answers
2k 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?
1
vote
1answer
731 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 ?
0
votes
1answer
1k 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 ...
6
votes
4answers
27k 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, ...
0
votes
1answer
3k 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': ...