Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [export]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 views

Data studio export csv file unicode

Hi I am trying to export a large data to csv excel file in data studio and the result is gibberish . it does not happen when I export to a regular excel file but i have limit of records that i can ...
user1715617's user avatar
0 votes
1 answer
47 views

Export from DB2 table to CSV with minimal client memory

How can I export a large volume of data from a DB2 database to a CSV file without consuming much client memory? Data volume : The result-set contains 100 Million Records, 14GB in size when written to ...
mew's user avatar
  • 1
1 vote
1 answer
17 views

How to import MySQL RAW Database files without connection error

unfortunately I did not create a 'dump' file with the backup (Data Export) process on MySQL Workbench 8.0.26. When I copy the old database files to the new Data directory, the server fails to start ...
life777eternal's user avatar
0 votes
0 answers
29 views

import db and users from mysql 5

There's a working Mysql 5 database that I want to import into a MariaDB on another machine, including tables, data, users and privileges. Is There a pretty simple way to do that? I'm not so expert in ...
Remigio's user avatar
0 votes
0 answers
12 views

What is a good mechanism to get production database data into other environments along with de identifying it

I am sure this is a solved problem and many people would have a great process already in place. How do I easily get data in my production server to other environments like staging and testing. We ...
George Joseph's user avatar
0 votes
1 answer
77 views

How to export db file from SQLLite

I have uploaded my csv file to https://sqliteonline.com/ and it is currently available as a table. I need to export this data to .db file to use it elsewhere. I tried exporting the table, but I only ...
User 19826's user avatar
0 votes
0 answers
28 views

Dump postgres table into a directory structure?

I have a table "templates" with about 150 records. Each record has various attributes, but the one of greatest interest is the "template" column, which is a text field that ...
Wildcard's user avatar
  • 588
1 vote
1 answer
392 views

TablePlus exporting without error but can not import it back

Exporting a table with 22,245 rows using TablePlus, after which TablePlus tells me "Export completed successfully". If I create a new database and try to import the file I just exported, I ...
Matt Welander's user avatar
1 vote
1 answer
704 views

How to export PostgreSQL database structure while ignoring objects created by PostGIS

I want to export the database structure from a PostgreSQL database. I want to include all tables, functions, etc., created by me but exclude everything created by database extensions like PostGIS. ...
Fido's user avatar
  • 111
0 votes
1 answer
192 views

How difficult and how much time should it take to export a DB to a flat file?

How difficult of a process is it to export a database to a flat-file? Should it take seconds, minutes, hours, or days to complete an export? I have no knowledge of the database structure, beyond the ...
pubb's user avatar
  • 11
0 votes
1 answer
214 views

Exporting via Phpmyadmin Charset

MySQL 5.7 I am exporting my db from my web host using phpmyadmin. This produces a single .sql file. When I check the export with Notepad+, there are special characters in the file. e.g. in my source ...
TheOrdinaryGeek's user avatar
1 vote
0 answers
178 views

How to export MySQL in a format accepted by DigitalOcean database clusters?

I am struggling with importing my databases to Digital Ocean database clusters. They have a setting that requires the primary key to be defined in the CREATE TABLE statement, but all my tools (...
Matt Welander's user avatar
1 vote
0 answers
187 views

How to use mongoexport with a dynamic variable for date on windows batch file?

Here is my working script: mongoexport --db db1 --collection Transaction --out C:\Users\Admin\transactionstats.json --query="{"PaymentDate":{"$gte":{"$date":"...
JRA's user avatar
  • 149
-1 votes
2 answers
104 views

How to increment as 001,002 etc In SQL Server

i have created an sp to export scripts i stored in a table to text files. What this sp do is if I give 100 as count then each file will have 100 scripts from the table. i am saving the file name as ...
Subin Benny's user avatar
1 vote
0 answers
319 views

Cannot access pg_largeobject table although I am the lomowner

I am looking for the best way on how to export data from the pg_largeobject table. I don't really understand what's the best way. I don't have access to the superuser, thus a pg_dump doesn't seem to ...
Chris's user avatar
  • 11
3 votes
3 answers
15k views

In SQL Server, how do I save the results of a query to a txt file?

In SQL Server, how do I export the results of a query to a txt file. I tried tools>options>results to file. But this appears to have saved the Messages the query generated instead of the Results ...
Jimbo's user avatar
  • 65
0 votes
1 answer
476 views

SQL query to script all objects from a database in order

i have a script to get all objects (functions ,views ,triggers and procedures from a database . I need to create this in another database . The problem is some procedures may have another procedures ...
Viz Krishna's user avatar
1 vote
0 answers
18 views

Incorrect values after export xml from DB for table bigint(20)

This below is part of my script code for export data from table to xml. query: $query = "SELECT p.id, p.slug, p.sku, p.price, p.vat_rate, p.stock, p.brand, p.ean, p.gender, pd.title, pd....
Marcin Wierzycki's user avatar
2 votes
2 answers
2k views

Unexpected newlines in json output in Postgresql

I'm squashing a datastructure to JSON objects using the PostgreSQL Json functions, however, there are unexpected newlines in the output. Basically, it creates JSON objects and put them in a list. This ...
Rob Audenaerde's user avatar
1 vote
1 answer
2k views

Saving output from INNER JOIN into a new table in MySQL

So I have a query in MySQL with an INNER JOIN which goes as follows: SELECT * FROM `distributors` INNER JOIN `manufacturers` WHERE distributors.manufacturer_id = manufacturers.manufacturer_id How do ...
Syed M. Sannan's user avatar
0 votes
1 answer
530 views

Exporting FoxPro DBF Files

I am attempting to export data stored by a client's Visual FoxPro database to be used in a MySQL context. The data given is a folder of .dbf, .cdx, and .tbk files, as well as a few .dct, .dcx, and ....
Eli's user avatar
  • 101
1 vote
3 answers
1k views

How can I export all of the Tables from a given Database in SQL Server to tab separated files?

I tried using SSMS but it only lets me export one file at a time and I'd prefer not to create an SSIS package. Is it possible to do this in PowerShell? I need the headers of each table in the file as ...
JTD2021's user avatar
  • 37
0 votes
1 answer
163 views

SQL Server export data from synonyms table to excel

I tried to export synonyms table from my server database to excel using SMSS, I choose database, then I choose export, and manage source and dest, then I choose Excel File and I rename sheet 1 to name ...
Fajrul Aulia's user avatar
0 votes
1 answer
36 views

Is it safe to export and then import encrypted database information in Oracle SQLdeveloper?

I'd like to perform some tests in a database by deleting the content of certain tables and then restoring the content they previosuly had once the test is finished. But problem is that these tables ...
mylket's user avatar
  • 103
0 votes
1 answer
280 views

Db2 - load LOB data returns error SQL3025N A parameter specifying a filename or path is not valid

I would like to learn how to load LOB data from files. I have a table with two columns: ID INTEGER DATA CLOB I can normaly export data with: export to c:\data\data.txt of del lobs to c:\data\ ...
folow's user avatar
  • 339
1 vote
1 answer
352 views

How do I bulk export data from an RDBMS without killing performance?

I'm building an app that lets the user export their data. When they click the Export button, we need to do a SELECT * WHERE user_id =, save it to a CSV file, and download it. There may be hundreds of ...
Kartick Vaddadi's user avatar
0 votes
1 answer
76 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 ...
Simullacra's user avatar
0 votes
1 answer
2k 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 ...
jrdba123's user avatar
3 votes
1 answer
86 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. ...
starholme's user avatar
0 votes
1 answer
6k 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 ...
jrdba123's user avatar
0 votes
0 answers
331 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 ...
TheRealChx101's user avatar
2 votes
1 answer
16k 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 ...
Dave's user avatar
  • 703
-2 votes
1 answer
124 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 "&...
Carlos's user avatar
  • 1
1 vote
1 answer
478 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 ---------- ...
Huskie69's user avatar
  • 137
0 votes
0 answers
601 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 ...
Huskie69's user avatar
  • 137
2 votes
1 answer
5k 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 ...
Eric Swiggum's user avatar
0 votes
1 answer
180 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
156 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 -...
SPlatten's user avatar
  • 149
0 votes
2 answers
3k 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 ...
alexandredelcol's user avatar
3 votes
2 answers
6k views

Export Postgres sequences only

Is there a way using PG_DUMP or any other commands to export only sequences from an existing database?
Benjamin's user avatar
  • 231
2 votes
3 answers
5k 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 ...
Pooya Estakhri's user avatar
0 votes
0 answers
426 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 ...
WoodrowShigeru's user avatar
0 votes
0 answers
841 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 ...
SPlatten's user avatar
  • 149
0 votes
1 answer
747 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 ...
Carl Patenaude Poulin's user avatar
1 vote
4 answers
2k 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 ...
Peter_K's user avatar
  • 11
0 votes
2 answers
610 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:...
JRA's user avatar
  • 149
3 votes
2 answers
2k 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 ...
SqlNightOwl's user avatar
1 vote
1 answer
708 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 ...
K8sN0v1c3's user avatar
0 votes
1 answer
736 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 ...
Nir's user avatar
  • 533
1 vote
1 answer
2k 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 ...
ConanTheGerbil's user avatar

1
2 3 4 5
7