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
43 views

Oracle 12c to 19c Internal Schema Export & Import

I want to exp & imp operations for APEX users from Oracle Database 12cR1 to 19c. Data Pump Utility can't do that. When I try to export by using following parfile and command: DUMPFILE=APEX.dmp ...
0
votes
0answers
21 views

How to move/copy a CSV file saved in /var/lib/mysql-files without root on a shared hosting server

I'm working with a server that I'm helping someone with to extract data from their database. The database server is no a shared hosting plan as is very very slow to run queries. Query that takes 3 ...
0
votes
1answer
55 views

Export Postgres data without superuser privileges

I'm using Postgres 14 on CentOS 7. I would like to export a single table's worth of data but I don't have superuser privileges. Unsurprisingly, I get this error myapp=> COPY myapp_currencyprice ...
-3
votes
1answer
26 views

Sql 2008 export table csv with headers and data

I need to export a table in SQL Server 2008 with headers and data delimited with | ( pipes ), but some information inside of this table have , ( comma ) and CR or LR, it's possible to put it a "&...
1
vote
1answer
26 views

EXPDP - why is block estimate significantly larger than segment size?

I'm exporting one specific table for a schema which I thought was a relatively small 5.4 GB SQL> select bytes/1024/1024 MB from user_segments where segment_name='TABLENAME'; MB ---------- ...
0
votes
0answers
29 views

Export DataPump - ORA-01555 Snapshot too old

I'm trying to export a customer's production database (schema) for problem solving. During export, I'm getting the following: Estimate in progress using BLOCKS method... Processing object type ...
3
votes
1answer
314 views

What is the best way to export/extract varbinary images in a SQL Server database to flat file via t sql, anything better than sp_OA methods?

I've been tasked to extract images saved in SQL Server (as varbinary) to flat files via t-sql. I haven't done ETL work for over a decade and I can't recall any other method of doing this via t-sql ...
0
votes
1answer
16 views

SQL Server backup file 15GB is empty when downclick trying to export single table from this sep4 a weekly backup

SQL Server backup file 15GB no Backupset selected to be restored? is empty when downclick trying to export single table from see attached why is that is it permissions? seeTheBackupScreenShot
1
vote
1answer
37 views

Exporting database using mysql command line

I am using mysql to export a database from my application, the options I have so far: --skip-comments --compact --lock-tables=false --add-drop-database --host=localhost --user=trainer --password=XXXX -...
0
votes
2answers
350 views

MySQL Dump only views, triggers, events and procedures

how are you? I need to generate a file with all triggers, events, procedures from a server's databases and tried the two commands below mysqldump -u root -p --all-databases --host=127.0.0.1 --no-data ...
1
vote
2answers
547 views

Export Postgres sequences only

Is there a way using PG_DUMP or any other commands to export only sequences from an existing database?
2
votes
3answers
742 views

Export and import a table without a specific column

I'm trying to export a table with an Auto Increment rowid column and then import it in another server. Considering that the column is primary key and can't accept duplicate keys if i import rows after ...
0
votes
0answers
135 views

Force double quotes in phpMyAdmin export dump

I have a varchar column in my table but when I export it in phpMyAdmin (4.6.6deb5ubuntu0.5), the values are quoted with single quotes. How do I force double quotes? I don't see a setting. CREATE TABLE ...
0
votes
0answers
149 views

HeidiSQL, how to export user definition

I am using MariaDB version 10.5.9.0 on Windows version 10.0.19041.928 with HeidiSQL version 11.0.0.5919 I have exported the database structure which includes the tables, stored procedures and data. I ...
0
votes
1answer
201 views

Take a "slice" of a SQL Server database: for all tables, get only the rows that join (directly or indirectly) to a specific row

For audit purposes, I'm trying to obtain a copy/export of a DB but including only the rows from each table that have relevance to a small collection of rows in some table. So every row of every table ...
1
vote
4answers
342 views

How to write and read files from client machine SQL Server 2019

I need to prepare a stored procedure which export as many files as many tables I have in schema, but files need to be written on local machine on specific path e.g. C:\Temp\ not on SQL Server ...
0
votes
1answer
155 views

How to use mongoexport in count?

I want to get the count of all rows in a single collection into an output file. What is the correct way of doing this Here is what I did but I am encountering an error. mongoexport --host 10.1.0.1:...
2
votes
2answers
575 views

Database Mail has incorrect encoding of CSV attachment

I have a procedure that generates a resultset, which I attach as a CSV file attachment in sp_sendmail. However, the resulting file is encoded UCS-2 LE BOM (according to notepad++). This causes the ...
1
vote
1answer
236 views

MongoDB + Compass exporting strings and numbers "columns" with value of 1 as "true"(boolean) and 2 or null as "false" to CSV

When I export my MongoDB collection to a CSV, the String and Number "column" data types values are converted to "true" for 1 and "false" for 2 and null - how do I retain ...
0
votes
1answer
59 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 ...
1
vote
1answer
743 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
539 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
1answer
880 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) ...
-1
votes
1answer
596 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
105 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
451 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
2k 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
284 views

Datapump not working 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
693 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
198 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
2answers
917 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
86 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
96 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 ...
3
votes
1answer
556 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
227 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
878 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
241 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
3k 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
3k 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
30 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
50 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
53 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
31 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
3k 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
190 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
79 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
1k 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
344 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
179 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 ...

1
2 3 4 5 6