Questions tagged [export]

The process and means of extracting data from a database for use elsewhere.

Filter by
Sorted by
Tagged with
0
votes
1answer
12 views

MySQL: carriage-return in query breaks my import

I use simple echo "select * from tab" | mysql --batch --quick --skip-column-names .... > /tmp/file from mysql to get data. Then, import to postgres using \copy tab FROM /tmp/file ...
0
votes
1answer
55 views

Using pg_dump on a view always produces an empty file

I want to export a subset of a tables rows using pg_dump (using powershell on windows). The simplest way seems to be to create a view with an appropriate WHERE clause. However, when I run pg_dump on ...
0
votes
1answer
22 views

Oracle - Delete dmp files from ASM diskgroup

I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it. ASMCMD> ls exp1.dmp exp2.dmp exp3.dmp exp4.dmp ASMCMD> pwd +DATA/EXP How ...
0
votes
0answers
119 views

How to export data from multiple tables to csv from remote postgres server (AWS RDS) to local machine?

I need to export data in CSV format from many (undertimined amount) tables from a remote postgres (aws RDS PostgreSQL 10.6) server to a local machine. When the server was in its own machine (AWS EC2) ...
0
votes
1answer
42 views

Oracle 11gR2 - Export - Import (expdp, impdp) How To Exclude A Table Partiton And This Table's Indexes

I have a table partition (135GB) and index partition on this table (total=150GB) and I want to exclude owner schema of this table and indexes with excluding this table partition and it's indexes. What ...
1
vote
1answer
19 views

PMA export with all attributes in CREATE TABLE

This is the default PMA output of an export: CREATE TABLE `foo` ( `id` int(11) UNSIGNED NOT NULL, `fk_id` int(11) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `foo` ...
1
vote
0answers
51 views

Export and split QUERY results in multiple files

I would like to know if it's possible to export and split query results in multiple files. Let's assume I have a query returning 100 results and I want to save the results in 5 different csv files (20 ...
0
votes
1answer
56 views

Oracle DB : Export only table data from from all tables of given schemas

Scenario : I want to export all data(or rows) from all tables from given schemas let say s1, s2, s3 from oracle DB installed on unix server(U1) . This data has to imported on another oracle DB ...
0
votes
1answer
82 views

Datapump not working with parallel in RAC environment

Some minutes ago I've tried to do an export but I get the following error (AIX system): Additional information: 3 ORA-31693: Table data object "XX"."TABLE_NAME" failed to load/unload and is being ...
1
vote
1answer
110 views

What is the best way to include a large amount of configuration data in a SQL project?

I have a BIDS SQL Server Database Project with a database that I publish dynamically to various servers (SQL2016). It initially starts blank and everything is parameterized. Everything is in Azure ...
0
votes
0answers
19 views

Export the table results into a text file automatically using sql developer

I have a table with contents as below +-----------+-------+ | Name | Value | +-----------+-------+ | IHA_NAME | Rexon | | IHA_Value | 65 | +-----------+-------+ I want to export this data ...
0
votes
0answers
71 views

Exporting from Oracle Cloud, importing on local database

I am currently experiemting with oracle databases. I have a free tier at Oracle Cloud, with a free instance of autonomous database. As I like to have my backups locally I did an export, basically ...
0
votes
0answers
33 views

Mongo compass import csv with accentuation

I'm trying to solve the following problem ... When trying to import data from a csv file into my collection, it happens that in the database some words with accents are left with question marks. ...
0
votes
2answers
239 views

mysqlimport imports NULL values unwantedly as int 0

I would like to understand how to create a decent back-up file by using mysql and mysqlimport. I know that I can use mysqldump and mysql, but I'm learning to use the combination: mysql and mysqlimport....
1
vote
3answers
73 views

Output a table as well-formed, indented JSON

I have a table dictionary and its structure is: create table dictionary ( id integer, first_level_key character varying(50), key_name character varying(50), key_value_en character varying(...
0
votes
1answer
34 views

Is there a way to specify which schema the database task “Export Data-tier Application” exports for the other entities besides the tables?

I noticed in the Export Data-tier Application database task, you can specify which schema to export data from in regards to tables, but I also want to exclude certain schemas for the other object ...
0
votes
0answers
48 views

Is there any official prometheus exporter for PostgreSQL now?

On the prometheus' Github page, it has exporters for MySQL, Consul, HAProxy, etc, but didn't find one for PostgreSQL. https://github.com/prometheus This is a way to do that: https://medium.com/@...
2
votes
1answer
222 views

MS Azure remote back up with SqlPackage

I wanted to do an export of a .bacpac file from MS Azure database, from local machine, with command like this: sqlpackage.exe /Action:Export /ssn:tcp:<ServerName>.database.windows.net,1433 /sdn:...
0
votes
1answer
97 views

DB2: how to export data file and own by db2inst1 via ADMIN_CMD

There is some requirement that I need to run the export command in Java via JDBC. Hence below is the command I execute CALL SYSPROC.ADMIN_CMD('EXPORT TO /tmp/header.csv OF DEL SELECT * FROM MYTABLE');...
0
votes
0answers
468 views

exceeds the maximum allowed database size when export database oracle 18c

I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues ORA-12954: The request exceeds the maximum allowed database size ...
0
votes
1answer
117 views

deadlock detected during oracle expdp

I have an Oracle 11g and I wanted to export all my shcema objects, with this command: expdp as '/ as sysdba' directory=DIR dumpfile=DWH%U.dmp logfile=DWH.log filesize=40000m parallel=32 schemas=DWH ...
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
1answer
1k views

Postgresql, export to json

Version: PostgreSQL 11.4 (Ubuntu 11.4-1.pgdg19.04+1). Question: Is possible export to json file? Something like csv export. COPY ( SQL ) TO stdout DELIMITER '"' csv; Thanks. Update: Or can I add ...
1
vote
1answer
2k views

exporting a sql view to a csv file

Whilst I can just about script to pull data via queries, I'm finding it very difficult to figure out how to export the results of a query to a .csv file and save in a network storage location (novice ...
0
votes
1answer
28 views

Will exporting tables in one db server to another db server release space in server?

Our production db server mount points are 95% full.There are a few tables which are not required. Hence if I export those tables to our test db server and drop those tables, will it release space in ...
0
votes
0answers
46 views

How to copy/export part of my SQL database

So I have this huge live SQL database. I want to do some testing so I thought to export it, however, it is around 200 GB which is impossible to export. I thought maybe I export the schema of it and ...
3
votes
1answer
52 views

What kind of database is this schema for, and how can I open it?

For sentimental reasons, I'm trying to export my text messages from an old feature phone (LG Cosmos 2, circa 2011) to a flat file (CSV or the like). I was able to successfully transfer the entire ...
1
vote
0answers
22 views

Custom Export from power BI service

I'm trying to make a custom button that exports filtered tables to a csv and downloads them to my computer. I am aware that you can do this with the '...' button but this functionality is for other ...
0
votes
2answers
2k views

MongoDB CSV Export: One Array/Column & Array Index on rows, or vice versa

I have a MongoDB schema that looks like this: const batchSchema = mongoose.Schema({ _id: mongoose.Schema.Types.ObjectId, time: {type: [Number]}, tmp: {type: [Number]}, hum: {type: [Number]}, ...
0
votes
1answer
156 views

Use data from Mysql to ElasticSearch with Logstash

I'm using logstash for use my mysql database in ElasticSearch My conf is the next. input { jdbc { jdbc_connection_string => "jdbc:mysql://[ip]:3306/nextline_dev" jdbc_user =&...
1
vote
0answers
59 views

All columns of all views defined as “1” in phpmyadmin export

MySQL 5.7.24, phpmyadmin 4.8.3 phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg: show create view v_contacts returns CREATE ALGORITHM=UNDEFINED DEFINER=`...
-1
votes
1answer
754 views

What are the advantages and disadvantages of using a embedded sql database? [closed]

What are the advantages and disadvantages of using an embedded SQL database instead of MySQL server? I am a web developer and I'm planning to develop an application for the shop, without investing my ...
3
votes
0answers
243 views

Does Google CloudSQL Export function lock tables?

In order to create more 'data recovery' points than the standard automatic backup policy allows, I'm going to run a cron which will export sql dumps out of my CloudSQL instances at intervals ...
0
votes
1answer
89 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
2answers
377 views

Get Headers from SQL Table

I am looking for a way to dynamically get the headers from a table without having to write them (select 'header1' as "header1"...., 'header50' as "header50" from MyTable) It doesn't work above a ...
2
votes
1answer
576 views

How to copy a tablespace to another database without using Data Pump in Oracle 11G

I have a database on a legacy system that has some data that needs to be exported to another environment. Everything I need is contained in one tablespace. Unfortunately, I am unable to use Data Pump ...
1
vote
0answers
124 views

Can pg_dump be broken into batches for large DBs?

I have a fairly huge DB and pg_dump croaks on me when I try to export it to a single file. Is there a way to do it in batches, whereby each batch would cover a segment of tables and export the schema/...
1
vote
0answers
34 views

How to fully dump mySQL database via workbench?

I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
1
vote
1answer
8k views

How to automate CSV-exports of queries in PL/SQL Developer (Oracle)?

I'm no pro in Oracle or PL/SQL Developer (I mostly use and admin mySQL and MS SQL Server). I'm not an admin of any sort, but have read access to many tables in Oracle via PL/SQL Developer. I need ...
-1
votes
1answer
2k views

Export all SSIS packages from SSISDB

We have quite a few SSIS packages on SQL Server 2012 deployed to SSISDB, you can right-click on a project and select 'Export' saved as an *ispac file, however, is there a script to Export All Projects ...
1
vote
1answer
3k views

How to export user with tables and tablespace oracle

I'm a newbie to Oracle World. I have to export, from computer A, tables and their data, to computer B. So, my question is: is there a way to export user, tablespace, tables and their data with one ...
-1
votes
1answer
120 views

How to update the first row in the exported query from sqlcmd

I am trying to find an easy way of updating the first row in the export of a sqlcmd query to CT_EVENT,,,,,,,,,,,,,,,,,,,,,,,,. I found this article in stack overflow which builds the csv format. I've ...
-1
votes
1answer
509 views

MySQL user export PASSWORD is showing up as <secret>

I am trying to export all users from old MySQL server to new. All the methods that I tried shows the PASSWORD as <secret> pt-show-grants phpMyAdmin 4.8.1 https://serverfault.com/questions/...
2
votes
1answer
61 views

How to export base and discover its structure

We are with a small problem at work. Our DBA decided to go around the world on a journey of self-discovery. I really love the idea and wish the best for him. The only detail is that he left without ...
0
votes
1answer
512 views

Exporting a Database schema and triggers [duplicate]

I have a small problem at work. Our DBA went on a journey of self-discovery ... I am very happy for him and I hope he finds what he is looking for. But he left us without any information about how the ...
7
votes
2answers
2k views

How to back up an entire database to text files

If it’s stupid and it works, it’s still stupid. The hullabaloo about GDPR got me thinking - if you had to go into your backups and modify/delete data, how would you do it? Cracking open a .bak file ...
0
votes
1answer
77 views

Is there any scenario where a exported (.sql) database dump could be bigger in size, than the database itself?

I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider. For some reason this other ...
1
vote
0answers
36 views

Replace oldSchema with newSchema in functions

I exported a database called oldDatabase using pg_dump in directory format. This database contains a schema, tables and functions owned by oldRole. These functions contain SQL statements like ...
1
vote
1answer
305 views

How to query large sets of data using server resources to the max

I am planning of retrieving large amounts of data (100+ million rows) from SQL Server to Azure Data Lake Store and I need it to be done in shortest time possible. I would like to ensure that when I ...
0
votes
1answer
324 views

Import database from MSSQL export dump on Ubuntu localhost

I have an export file from an online database server that I need to use to generate the database locally on my system. I'm running MSSQL 2017 on Ubuntu 16.04. The export file has Program(application/...

1
2 3 4 5 6