The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
19 views

Is it possible which documents couldn't be dumped using “mongodump”?

I am removing historical data from a collection in MongoDB (3.2), but first I need a backup of it. The choice has fallen, a simple combination of: mongodump --db myDatabase --collection myCollection ...
1
vote
1answer
13 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
30 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 ...
0
votes
4answers
91 views

How to 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
71 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': ...
1
vote
0answers
62 views

mongodump monitoring (with exit codes)

This is how we monitor backups with mongodump. Exit code and mail if not 0. Mailing is reliable in our environment. mongodump -h $RANDOM_SECONDARY -u $BACKUP_USER -p $BACKUP_PASSWD --out ...
0
votes
0answers
36 views

mysqldump: restored by mistake with no backup

While trying to take a mysqldump on a database, we have by mistake run a restore command mysql -u -p abc.sql <abc.sql. This has resulted in the abc database going back to a state 5 days back when ...
3
votes
1answer
101 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
1answer
103 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 ...
2
votes
0answers
48 views

How to read sql-server dump without sql-server [closed]

I have a binary sql-server dump and I don't have sql-server instance. I use Ubuntu machine. How can I convert sql-server dump into mysql dump or something other readable format without installation ...
0
votes
0answers
15 views

PostgreSQL dump import only imprts tables and not data

I'm trying to import a postgreSQL dump into my DB. The dump is saved in a .sql file. I use the following command : psql -U postgres -d dhris < dbDump.sql and the table was created before. The ...
0
votes
0answers
43 views

How to get Cassendra database dump with data

I need to get a dump(with data) from a remote Cassandra database. I was able to get database schema via following command. How can i get all data in the keyspace? I'm using Cassandra 1.1.9. echo -e ...
0
votes
0answers
159 views

Mysql dump import shows error 1556 (HY000) “you can't use locks with log tables”

I'm trying to setup a replication slave for an existent MySQL server. Therefore I dumped all data from the master like this: mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob ...
0
votes
0answers
24 views

Best way to generate backups with 'INSERT ON DUPLICATE KEY UPDATE'

I have been using HeidiSQL to generate MySQL backups using 'REPLACE INTO' however have recently come across the problem this causes with foreign keys & have been told using to use 'INSERT ON ...
0
votes
1answer
67 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, ...
0
votes
0answers
170 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 ...
0
votes
2answers
58 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 ...
1
vote
1answer
260 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 ...
3
votes
1answer
289 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 ...
1
vote
1answer
53 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. ...
1
vote
0answers
55 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 .
2
votes
2answers
206 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 ...
1
vote
1answer
312 views

PostgreSQL - partial dump of large orbjects (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 ...
0
votes
0answers
55 views

How I optimize data dump in oracle 11g

I've an Oracle 11g Database, now the data is very huge, I've an approximately 858 Object in 1 schema and i have 20 Schema, and it's about approx 20 TB in size. I've tried using Navicat Premium v11 to ...
1
vote
0answers
68 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 ...
0
votes
1answer
53 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. ...
0
votes
1answer
2k 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 ...
0
votes
1answer
3k 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 ...
1
vote
1answer
330 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 ...
1
vote
1answer
397 views

Oracle dump to csv an 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 ...
0
votes
1answer
2k 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 ...
2
votes
2answers
568 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? ...
0
votes
1answer
1k 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: ...
0
votes
1answer
3k 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/ ...
0
votes
1answer
418 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 ...
2
votes
2answers
1k 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 ...
4
votes
1answer
2k views

How to change temporary directory for pg_dump?

I'm running out of space from my harddrive which has a 18GB PostgreSQl databse. When I try pg_dump to a different drive, PostgreSQL creates temporary files on the disk it's dumping from, so I run out ...
0
votes
0answers
318 views

Error restoring a MySQL dump file

I have an error when I try to restore a dumped file from the same server and version of MySQL. I used this to produce the dump: exec('mysqldump --user=... --password=.. --host=localhost data_base ...
4
votes
1answer
4k views

Postgres Dump To TXT File

Is there a way to convert a Postgres dump file to a text file? I'm experiencing issues getting the dump to the proper file location of I would just restore from the dump file and then export to text. ...
1
vote
1answer
3k views

What to look for in bad pg_dump log

We want to programmatically detect errors in cron scheduled pg_dumps. Apart from cheking whether or not the log file ends in "pg_dump: saving database definition": What other tell-tale string can I ...
0
votes
3answers
1k views

Importing 40 gb mysql file via phpmyadmin

I have a 40 GB MySQL dump file. Can anyone give me the idea how to import the file via phpmyadmin?
1
vote
1answer
534 views

Any way to estimate the required space for a SQL dump file?

I want to import a Wikipedia XML dump file into MySQL. The uncompressed XML dump file is 65GB. Does this mean I should free up almost 64GB in the MySQL data path? Is there any way to estimate the ...
7
votes
2answers
395 views

Exporting database Oracle 7.3 on Windows NT 3.51

How to take dump files on Oracle7.3 running on Windows NT 3.51? Should you stand in the Orant/bin folder and run one of the programs there like> exp73 SYSTEM/password@[dbinstance] FULL=Y ...
1
vote
0answers
1k 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 ...
0
votes
6answers
16k views

How can I convert an Oracle dump file into SQL Server?

I want to ask about converting Oracle dump files (.dmp) into SQL Server files (.bak) where during conversion I don't have to be connected to any database server. I've searched for related ...
0
votes
1answer
2k views

Moving data between Oracle and PostgreSQL

For a future project I need to use the following setup: Some small (offline) data boxes (colleting data over the time) fill PostgreSQL databases. (Summing up to about 1 TB a year. For time to time, I ...
1
vote
1answer
322 views

MySQL Dump all rountines except one

We want to export a large amount of tables and routines and we've do this often. Each database, table and routine should be dumped with one exception: a procedure with a specific name. So I was ...
1
vote
0answers
699 views

Powershell to dump database schema to text file

I want to be able to dump a database schema to a sql text file using Powershell. I want this because our DBAs want to be able to do a diff on the file that is committed to SVN. They won't execute it ...
3
votes
1answer
617 views

pg_dump freezes on windows service application

I have a system running over Tomcat which executes a backup batch job every day, it calls pg_dump.exe from Java and stores its output to an SQL file. When I'm executing Tomcat from the shell, it ...
6
votes
1answer
3k views

Backup a database with a huge number of tables

Is there a way to backup a PostgreSQL database with a huge number of tables? An attempt with pg_dump for a database of about 28000 tables resulted in the following error message: pg_dump: WARNING: ...