The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
1k 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 ...
10
votes
1answer
6k views

postgresql: how do I dump and restore roles for a cluster?

Where are roles stored in a cluster, and how do I dump them? I did a pg_dump of a db and then loaded it into a different cluster, but I get a lot of these errors: psql:mydump.sql:3621: ERROR: role ...
0
votes
2answers
37 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 ...
0
votes
1answer
56 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
64 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 ...
2
votes
2answers
471 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
344 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 ...
4
votes
1answer
3k 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
21 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
21 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 .
0
votes
1answer
619 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 ...
2
votes
2answers
111 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
167 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
48 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 ...
0
votes
6answers
13k 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 ...
4
votes
2answers
8k views

DROP PROCEDURE IF EXISTS not included in mysqldump

I'm dumping my stored procedures only using the following command: mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt databasename -u username -p > outputfile.sql but the ...
0
votes
0answers
44 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
2answers
8k views

Opening a .backup file for PostgreSQL

I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise. In short, I have what I think is a ...
0
votes
1answer
44 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. ...
7
votes
1answer
9k views

Dump only the Stored Procedures in MySQL

I need to dump only the stored procedures : no data, no table creation. How can I do this using mysqldump?
0
votes
1answer
1k 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 ...
0
votes
1answer
688 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: ...
1
vote
1answer
264 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
239 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 ...
0
votes
1answer
2k 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/ ...
3
votes
1answer
509 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 ...
1
vote
1answer
2k 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 ...
2
votes
2answers
759 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 ...
3
votes
1answer
1k 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 ...
1
vote
0answers
556 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 ...
4
votes
3answers
8k views

Import Oracle full dump file to fresh Oracle installation

I am importing a Oracle dump fill created on a AIX Oracle 9.2 installation with a Full Export option to a Windows Oracle 10.2.0.4 on Windows 2008 R2 x64. I want to import the file to a clean ...
0
votes
0answers
271 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 ...
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?
6
votes
2answers
350 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
1answer
378 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 ...
1
vote
0answers
830 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 ...
3
votes
1answer
908 views

Dump PostgreSQL schema with foreign keys and referenced data

The official PostgreSQL documentation states that pg_dump can use the --schema=SCHEMA option to selectively dump a given schema. However according to the same documentation (read Note on ...
0
votes
1answer
1k 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
305 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 ...
5
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: ...
1
vote
0answers
467 views

How to dump an advanced revelation database?

Retail store I work with has an ancient inventory/accounting/receiving system that is based off Advanced Revelation. They run the DOS and Windows clients. I'd like to get a dump of their data to ...
1
vote
1answer
650 views

How mysqldump replaces special characters during dumping records?

i am trying to dump a particular row using java. So that i retrieve the data by using record sets and i manually written sql script code by appending the dynamic records. But my problem is i could ...
12
votes
5answers
26k views

MySQL server has gone away obstructing import of large dumps

I am trying to import a large sql dump (2GB) to my local mysql on my mac. I have been able to do this in the past (I was using MAMP), but now I get a ERROR 2006 (HY000) at line 7758: MySQL server ...
1
vote
0answers
773 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 ...
2
votes
3answers
3k views

How to detect a running mysqldump?

Here are the things I can't change: We got a mySQL myISAM replication running a master and some slaves. One slave is being used for nightly backups using mysqldump. The backups is using heavy locks ...
3
votes
1answer
115 views

MySQL - Partially restore binary log

I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500. How can I do that?
1
vote
1answer
2k views

I would like to launch a pg_dump command from a remote computer

I would like to launch the command: pg_dump.exe -h 255.255.255.255 -p 5432 -U postgres -F p -a -v -f "test.db.dump" mydb from a remote computer. Both the database and the remote computer are under xp. ...
0
votes
1answer
265 views

postgresql dump and load — need to dump “postgres” db also?

If I pg_dump a db from an 8.4 cluster, and then load it into a different 9.1 cluster, do I need to pg_dump and restore the 'postgres' db as well? (I'm not familiar with what is contained in the ...
3
votes
1answer
782 views

MySQLDump wrong dump

i'm trying to generate a dump from my database but when i try to load the dump file it gives me an error. What should i do ? My MySQL ( loader) version is mysql "Ver 14.14 Distrib 5.1.57, for ...
0
votes
1answer
468 views

How to extract a whole database schema using only ODBC access?

I need to migrate an old proprietary database (custom database based on a Btrieve engine) to a newer system . All I have to access this database is an ODBC driver that works pretty well. When I ...