Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [export]

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

0
votes
1answer
11 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
12 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
48 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 ...
0
votes
0answers
19 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
33 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
88 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
63 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
35 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
18 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
487 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 ...
0
votes
1answer
242 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
131 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
70 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 ...
0
votes
1answer
174 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
59 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
131 views

Exporting a Database schema and triggers

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 ...
0
votes
0answers
32 views

Import MySQL Dump into Database Table with Another Table Name [duplicate]

I have exported the selected records from a table using mysqldump using --no-create-info and --where options. But the dump contains a statement like INSERT INTO `table_name` VALUES I cannot ...
7
votes
2answers
708 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
40 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
31 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
76 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
176 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/...
0
votes
0answers
54 views

“fast” way to export oracle database remotely

this is first time i use Oracle database, and i want to export database in my vps remotely to my local computer, i just try to export with Navicat, but it seem's take too long for large data (4M Rows),...
0
votes
2answers
48 views

Filesystem copying inactive DBs on active MySQL server

My question is related to this question and answer: Copying datadir directory enough for backing up a database with InnoDB tables? I want to use a filesystem copy on a whole DB without shutting down ...
1
vote
1answer
271 views

Pass .csv file as parameter file for expdp Oracle 11.2.0.4.0

Can we use .csv file as parameter file for expdp ? Ex: expdp scott/xxx@dev parameter=table_full.csv Thanks
0
votes
1answer
281 views

ORA-31114: XDB configuration has been deleted or is corrupted

ORA-31114: XDB configuration has been deleted or is corrupted How to recreate the XDB configuration? Do I need to remove the existing component first? By the way I can't run UTLRP scritp for the ...
1
vote
2answers
186 views

Partial copy of huge database

I have started working in a project which has a big database, around 300GB. For security reasons I can not access database from my local web app. So I need to copy last 100,000 from each table. To ...
0
votes
3answers
118 views

Error while exporting data to flat file from database using sqlplus in UNIX

Trying to export data from a table to .dat file in a unix script using the SPOOL command. However on execution only ~17k data is exported to file out of 91K data with an error in end of the file : ...
2
votes
1answer
253 views

Storing the last updated date of a row in a different table

I need to do a daily export of all of the new rows or updated rows from a legacy database into the new database. The problem I am running into is that not all of the tables on the legacy database ...
2
votes
1answer
4k views

Oracle 12c export and import schema with different data tablespace and index tablespace

Suppose that I exported the schema objects from my Oracle 12c database using the original export utility as below: exp userid=<export_schema_name>/<export_schema_password>@<db_string&...
1
vote
1answer
41 views

MS Access: Issue with Autonumbers in the export

I have a question that might be trivial to solve, but I have spent some time on it and didn't manage to solve it. I am working on a database in MS Access, in which I keep track of the specifications ...
1
vote
3answers
4k views

SQL Server: SSMS “Save Results As” creates CSV that Excel mangles

Using the Save Results As option, shown below. CSV looks good! But when Excel opens/imports it: Long strings are mangled as numbers (if the data is largely numeric) Dates are not detected properly ...
0
votes
2answers
371 views

How to export data from a SQL Server database with hundreds of tables and timestamp columns?

I have a SQL Server database with hundreds of tables and they all have timestamp columns. I don't have access to backups or the server's file system. To use the export data wizard, I have to go into ...
1
vote
1answer
235 views

What is the 131072 in the call to lo_open()

ByteA to BLOB conversions typically make a call to lo_open(), CREATE OR REPLACE FUNCTION make_lo(bytea) RETURNS oid AS $$ DECLARE loid oid; fd integer; bytes integer; BEGIN loid := lo_creat(-...
0
votes
2answers
276 views

update table with data from other table in remote oracle db

I have table X from remote Oracle DB A, and table Y in local Oracle DB B. The data in Y is a partial copy of the data in X (X has some columns that aren't needed in Y; the columns I need in Y have ...
0
votes
2answers
6k views

Oracle: spool data to different files depending on where condition (loop)

I am trying to get my way around something like this declare filename varchar2(100); begin for condition in (select fieldN from mytable) loop filename := 'data_for_value'||condition.fieldN||'...
6
votes
2answers
933 views

Very large SQL Server 2016 result sets (over 75 GB) to a CSV file?

What is the best way to get very large SQL Server 2016 result sets (over 75 GB) to a CSV file? The engineers need this output to look for correlations. The bcp route for a 73.5 GB file filled up ...
2
votes
1answer
2k views

Import Oracle .dmp with error 1659, unable to allocate MINEXTENTS beyond 3 in tablespace SYSTEM

I'm trying to importing an Oracle DUMP file (v10.2) into Oracle Express 11.2.0.2.0. I was getting some schema errors and resoled them by following other posts here. Now I'm getting this error and I'm ...
-1
votes
2answers
3k views

ORA-01555:Snapshot too old error during execution of expdp command [duplicate]

After performing expdp command in production database (Oracle 11g - linux): expdp abc/123 DIRECTORY=data_pump DUMPFILE=SA10_%u.dmp LOGFILE=SA10.log TABLES="abc"."/1FE/019" PARALLEL=4 CONTENT=...
0
votes
2answers
321 views

MySQL Import & Replace via CSV

I have a MySQL database table named items with 10,000+ records. Of these records, I would like to export only records where item_isbn IS NULL. SELECT * FROM Items WHERE item_isbn IS NULL produces a ...
0
votes
1answer
306 views

Any program / command to see a preview of .sql dump file?

If I have [multiple] .sql dump files, is there a command or tool that would allow me to see a preview of the file ? e.g: db-preview backup.sql tables (40) ---------- - users (1200) -...
6
votes
1answer
886 views

Postgres 9.6 export the database structure as pdf [closed]

Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.
0
votes
3answers
495 views

How to export some rows of multiple tables linked between them according to one column value?

I'm not sure my question is clear so let's me rephrase it. I have three tables organized like that: I want to make a dump of these tables but I'm not interested by all the rows, I just want those who ...
1
vote
1answer
62 views

Objective, SQL Server 2005 and exporting data using **bcp**

I was tasked w/ getting data out of an obsolete document management system running on top of an instance of MS SQL Server. Trying to export > 30000 documents through the app is not an option, as it ...
5
votes
1answer
803 views

Informix DB export to Microsoft SQL Server 2016

I have an Informix Database and a Microsoft SQL Server 2016. My task is to dump the whole Informix Database and export it to the Microsoft SQL Server Database. I installed the Informix SDK 4.5. I ...
2
votes
0answers
247 views

Export SQL View to CSV flat file. SSIS job stuck

I created a database view with the desired data and format. I used SQL Server Import and Export wizard to create a flat file export procedure and saved it to SSIS package. The data exports correctly ...
-3
votes
1answer
85 views

How to view and export database content? [closed]

I'm trying to view the actual entries, not the backend identifiers. > db.<collection>.find({"_id": "486b4ca55b144b119f4551417c5798c8"}).pretty() { "_id" : "...
1
vote
1answer
712 views

Microsoft Access database to FileMaker Pro

I have all my customer details in Microsoft Access. I want to transfer all this data to FileMaker Pro. I hope there is a way to do this. If so please help me.
4
votes
1answer
3k views

How to export database structure from Firebird?

I'm doing replication and I need to export db structure from one Firebird db (dialect 3) into another. I've seen a couple tools like IBPump and FBExport, however all I can find is how to export all ...
2
votes
3answers
2k views

Copy whole database from SQL Server to SQL Server using linked server

I am using SQL Server 2014 Management Studio installed in my system. And using linked server I have connected to a linked server. Now here I need to copy whole database from linked server to my ...