Questions tagged [export]
The process and means of extracting data from a database for use elsewhere.
303
questions
0
votes
1
answer
29
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 ...
- 103
0
votes
0
answers
18
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 ...
- 588
1
vote
1
answer
151
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 ...
- 141
1
vote
1
answer
190
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. ...
- 111
0
votes
1
answer
94
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 ...
- 11
0
votes
1
answer
168
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 ...
- 177
1
vote
0
answers
140
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 (...
- 141
1
vote
0
answers
158
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":"...
- 129
-1
votes
2
answers
65
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 ...
- 57
1
vote
0
answers
220
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 ...
- 11
3
votes
3
answers
9k
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 ...
- 65
0
votes
1
answer
281
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 ...
- 89
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....
2
votes
2
answers
1k
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 ...
- 203
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 ...
- 123
0
votes
1
answer
410
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 ....
- 101
1
vote
3
answers
803
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 ...
- 37
0
votes
1
answer
111
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 ...
0
votes
1
answer
28
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 ...
- 103
0
votes
1
answer
221
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\ ...
- 325
1
vote
1
answer
223
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 ...
- 113
0
votes
1
answer
75
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 ...
- 111
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 ...
- 29
3
votes
1
answer
78
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. ...
- 41
0
votes
1
answer
5k
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
...
- 29
0
votes
0
answers
290
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 ...
- 111
2
votes
1
answer
13k
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 ...
- 643
-2
votes
1
answer
110
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
1
vote
1
answer
389
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
----------
...
- 137
0
votes
0
answers
466
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 ...
- 137
2
votes
1
answer
4k
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 ...
- 609
0
votes
1
answer
155
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
Padraig O'Hara
1
vote
1
answer
131
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
-...
- 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
...
3
votes
2
answers
5k
views
Export Postgres sequences only
Is there a way using PG_DUMP or any other commands to export only sequences from an existing database?
- 231
2
votes
3
answers
4k
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 ...
- 149
0
votes
0
answers
384
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 ...
- 101
0
votes
0
answers
768
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 ...
- 149
0
votes
1
answer
674
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
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 ...
- 11
0
votes
2
answers
536
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:...
- 129
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 ...
- 45
1
vote
1
answer
646
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 ...
- 21
0
votes
1
answer
620
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 ...
- 513
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 ...
- 1,125
1
vote
1
answer
2k
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 can I ...
- 55
0
votes
1
answer
2k
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
1
answer
1k
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 ...
- 55
1
vote
1
answer
175
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`
...
- 679
1
vote
0
answers
1k
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 ...
- 31