Questions tagged [export]

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

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

Out of disk space while dropping columns from a mysql table

So, my setup is a little weird. I've got a laptop with 250 GB of memory and a table with roughly 100 million rows (InnoDB), which occupies around 130 GB of memory. The thing is, this table includes ...
user avatar
0 votes
1 answer
61 views

Oracle 11gR2 - Expdp Full Database With Exclude Some Table Data

We will migrate our database using datapump. It will be full database export with exclude some table's datas. But we want to do a different operation for 2 different tables. We want to export the data ...
user avatar
0 votes
0 answers
39 views

SQL Server Database Migration from old data type to new SQL Server with new data type (VLDB)

I have a database sized 25+ TB. There are objects (almost all tables has) with nvarchar data typed columns with partitions. Recently we realized there is no necessity for maintaining nvarchar data ...
user avatar
3 votes
1 answer
61 views

How can I transfer the entire content of several tables to another database, not in the same network?

I have a set of 12 tables, about 4 million rows total, that I need to move four times per year. The database server they are coming from can NOT directly talk to the server that they are moving to. ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
0 votes
0 answers
55 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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
  • 605
-3 votes
1 answer
38 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 "&...
user avatar
  • 1
1 vote
1 answer
63 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 ---------- ...
user avatar
  • 137
0 votes
0 answers
109 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 ...
user avatar
  • 137
3 votes
1 answer
820 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 ...
user avatar
0 votes
1 answer
26 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
user avatar
1 vote
1 answer
57 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 -...
user avatar
  • 149
0 votes
2 answers
788 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 ...
user avatar
2 votes
2 answers
1k views

Export Postgres sequences only

Is there a way using PG_DUMP or any other commands to export only sequences from an existing database?
user avatar
  • 221
2 votes
3 answers
1k 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 ...
user avatar
0 votes
0 answers
182 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 ...
user avatar
0 votes
0 answers
305 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 ...
user avatar
  • 149
0 votes
1 answer
299 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 ...
user avatar
1 vote
4 answers
438 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 ...
user avatar
  • 11
0 votes
1 answer
240 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:...
user avatar
  • 59
2 votes
2 answers
799 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 ...
user avatar
1 vote
1 answer
317 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 ...
user avatar
0 votes
1 answer
106 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 ...
user avatar
  • 393
1 vote
1 answer
961 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 ...
user avatar
0 votes
1 answer
734 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 ...
user avatar
  • 25
0 votes
1 answer
1k 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) ...
user avatar
-1 votes
1 answer
696 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 ...
user avatar
  • 25
1 vote
1 answer
120 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` ...
user avatar
1 vote
0 answers
604 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 ...
user avatar
0 votes
1 answer
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 ...
user avatar
0 votes
1 answer
371 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 ...
user avatar
  • 508
1 vote
1 answer
806 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 ...
user avatar
  • 175
0 votes
0 answers
228 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 ...
user avatar
0 votes
2 answers
1k 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....
user avatar
  • 442
1 vote
3 answers
105 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(...
user avatar
1 vote
1 answer
147 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 ...
user avatar
  • 24.6k
4 votes
1 answer
688 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:...
user avatar
  • 141
0 votes
1 answer
283 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');...
user avatar
  • 103
0 votes
0 answers
983 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 ...
user avatar
0 votes
1 answer
280 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 ...
user avatar
0 votes
0 answers
35 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?
user avatar
  • 1
0 votes
1 answer
4k 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 ...
user avatar
  • 153
1 vote
1 answer
4k 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 ...
user avatar
  • 21
0 votes
1 answer
37 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 ...
user avatar
0 votes
0 answers
56 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 ...
user avatar
  • 139
3 votes
1 answer
54 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 ...
user avatar
  • 192
1 vote
0 answers
35 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 ...
user avatar
0 votes
2 answers
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]}, ...
user avatar
0 votes
1 answer
198 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 =&...
user avatar
  • 121

1
2 3 4 5 6