Questions tagged [import]

The import of data is the automated or semi-automated input of data sets between different software applications.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
16 views

Import 5gb sql file into MYSQL database

i have exported sql file using mysql dump from a database and i am trying to import this big 5gb file into anohter mysql database. I am using mysql -u username -p -h hostname <file.sql command ...
user avatar
0 votes
1 answer
30 views

0 rows from the .csv (semi colon) are imported into MySQL Workbench

I am trying to import the .csv below (columns and 3 first records in txt in differenet blockquotes) into MySQL Workbench using the Table Data Import Wizard. I have tried many ways and realized that ...
user avatar
0 votes
0 answers
11 views

Importing a database with the exact same schema as the destination database

I am working in Access with a fairly simply relational database. I want to import another database of the EXACT same schema, but when I use Access' import tool the software creates extra tables (...
user avatar
3 votes
1 answer
57 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
2 votes
1 answer
421 views

Date not being imported from csv in proper format in MySQL

I am new to MySQL, so kindly explain your answers in a simple way! I have a csv file which has 2 date columns. I want to import the csv into MySQL and I am using the following method: Create an empty ...
user avatar
  • 121
16 votes
5 answers
2k views

Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?

In importing data to SQL server, one can often not account for how large the imported string fields will be. Can I just lazily keep using a large value for the char field definitions, and does it have ...
user avatar
  • 329
1 vote
1 answer
536 views

unterminated CSV quoted field when to import csv data file into postgresql

Create a table : CREATE TABLE num ( id serial NOT NULL , adsh VARCHAR(20) NOT NULL, tag VARCHAR(256) NOT NULL, version VARCHAR(20) NOT NULL, coreg VARCHAR(256), ddate date NOT ...
user avatar
  • 126
0 votes
1 answer
749 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
1 answer
229 views

How do I import CSV UUID data into Postgres on the command line?

I'm using PostGres 10. I have this table > \d myapp_currencyprice; Table "public.myapp_currencyprice" Column | Type | Modifiers ----------------...
user avatar
  • 575
0 votes
1 answer
142 views

importing bacpac file using sql package

How can I specify Database maximum size when importing bacpac file using sql package? The maximum size of 32GB is auto-sizing, but my actual DB size is over 35GB. Can I get to use DatabaseMaximumSize=(...
user avatar
0 votes
1 answer
540 views

Why do I get #2006 MySQL server has gone away and how can I fix this?

What I'm doing is I'm trying to restore MySQL tables from frm and ibd files. Most of the tables have been restored successfully. I do it like this: mysqlfrm --diagnostic "C:/<path_to_frm>/...
user avatar
1 vote
1 answer
70 views

MySQL importing csv file by Data import wizard

I tried importing a CSV file in MySQL via the data import wizard. My CSV file has 70,000 records but only 61 are imported. I tried checking the CSV file, recreating the file from source, and changing ...
user avatar
  • 11
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
2 votes
1 answer
235 views

View SQL Code Behind Flat File Import Wizard?

Is there a way to view and copy the code that the "Import Flat File to SQL" Wizard ultimately uses, after I have gone through all the steps (chosen file, set up data types for my columns, ...
user avatar
  • 23
1 vote
1 answer
75 views

Mysql (win) Is it possible to get databases from multiple drives in the same time?

My question would be, is there any way to read the mysql data folder from different drives in the same time (Windows) ? For example: I have 1TB database from the drive C:, and another 1TB from the ...
user avatar
4 votes
1 answer
3k views

Parsing DATE while copying csv file into PostgreSQL table

I have a long series of .csv files, which I want to import into a local database. I believe my query is correct, but there are some problems in parsing DATE and TIMESTAMP columns. PostgreSQL reads ...
user avatar
0 votes
1 answer
287 views

Most efficient method to import bulk JSON data from different sources in postgresql?

I need to import data from thousands of URLs, here is an example of the data: [{"date":"20201006T120000Z","uri":"secret","val":"1765.756"},{...
user avatar
3 votes
1 answer
1k views

ORA-39014 import in Oracle 19c from DMP file of Oracle12c

I have been testing out expdp/impdp of databases from 12c to 19c( newly created database) but one db have game me this error: nohup impdp system/****@CKLPROD CONTENT=METADATA_ONLY PARALLEL=4 DIRECTORY=...
user avatar
0 votes
2 answers
262 views

SqlPackage importing of very large bacpacs to Azure

I want to import a database from a .bacpac file to a SQL Server in Azure. I read the document. It says that there is a flag called DatabaseMaximumSize=(INT32). I wanted to know if there's a limit that ...
user avatar
0 votes
1 answer
61 views

Importing files with a mix of decimal separators

Using SQL Server Management Studio 18.3 I want to import data (semicolon separated text file) that has some columns with dot as decimal separator, and some with comma as decimal separator. I can't ...
user avatar
  • 3
1 vote
1 answer
295 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
1 vote
3 answers
805 views

Japanese characters in VARCHAR column using Japanese_Unicode_CI_AS

I am loading a table with the Japanese names from CSV file that are changing into question marks into SQL Table. The table that is storing these values is a varchar column. I understand that the ...
user avatar
0 votes
2 answers
479 views

importing postgres tar file throws parallel not supported in postgres 12

I'm trying to import a db that someone sent me: testdb.tar (43GB size) First I've imported using: pg_restore --host localhost --port 5432 --username postgres --dbname testdb --role postgres --no-...
user avatar
  • 123
1 vote
0 answers
31 views

oralce import joinning 2 tables using query

Is it possible to join 2 tables inside the query in oracle while importing ? I have a dump for 2 tables tab1 and tab2. and I am trying to query on 1 of the tables: Directory=backup DUMPFILE=twotables....
user avatar
  • 115
0 votes
0 answers
139 views

mysqlimport and avoiding table lock

I reviewed the question & answer here (mysqlimport locks all tables system wide) but I seem to still be stuck on this. I am standing up a new master/slave pair of 5.7 servers, and have already ...
user avatar
  • 37
-1 votes
1 answer
670 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
5 votes
2 answers
3k views

How to Skip Existing Data While Restoring mysqldump File?

I use this query to import data using MySQL Dump (Command Prompt / Command Line) mysql -u root -p database_name < database_name.sql I want to import the large database (only new deltas) as of now ...
user avatar
0 votes
1 answer
388 views

Large MySQL import stuck at "Waiting for table flush"

Two weeks ago (!) I started a large import (dump sql file is 540GB). Now the import is stuck at this state: "show processlist" shows: Command = "Field List", State="Waiting ...
user avatar
  • 23
0 votes
1 answer
560 views

Windows 10, SQLServer Express (2019), Excel 2016 import to SQLServer error Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

Environment: Workstation: 16GB RAM. 500MB SSD Windows 10 Pro (64-bit) Microsoft Office 2010? 2016? (Home/Student?) Not sure how to tell exactly. Office reports the version as 18.2005.1191.0 ; Excel ...
user avatar
1 vote
1 answer
682 views

mysql: slow import

I have a 83GB compressed .sql.gz file that I'm importing. The DB size on the source server (the size of the folder) was 240GB. I'm importing it on a Amazon cloud server, with 2CPUs, 4GM RAM and SSD ...
user avatar
  • 23
1 vote
1 answer
245 views

Copy csv file into different schema [closed]

I need to import data from a csv file which from database a schema a into another database b schema b. I used the pgAdmin running the export and when I import the data using the same tool pgAdmin and/...
user avatar
  • 21
0 votes
2 answers
67 views

How Are SQL Server Clients Connecting?

I am asking two questions in this post. If I see activity in netstat with port 1433 for an unnamed instance, whose tcp addresses are not enabled, what does that mean? What is the preferred way to ...
user avatar
1 vote
2 answers
990 views

How can I force the MySQL client to output to stdout or a log file when importing a SQL file?

Let's say I am importing a small SQL file using the MySQL client like so: mysql < 10k-file.sql The mysql client does not output anything. How can I force it to show how many rows are affected for ...
user avatar
  • 111
1 vote
0 answers
3k views

Persistent problems importing CSV files via pgAdmin 4 to PostgreSQL 12 on Mac OS - Failing with Exit Code -6

I've been trying for several days to import CSV files into a PostgreSQL 12 database hosted on Mac OS 10.15.5, using the Import/Export tool in pgAdmin 4. I am consistently getting an error message ...
user avatar
0 votes
0 answers
911 views

Attempted to import .csv into mySQL using workbench, but only imports 7 rows?

To start, I'm still a relative SQL noob so this question could have an obvious answer that I'm just missing. I'm trying to start a big practice project in my spare time using a dataset which has ~...
user avatar
  • 1
0 votes
1 answer
1k views

MS SQL Server: Import Flat File with auto-increment ID

So I've downloaded a sample database. It originally didn't have an ID column so I inserted one in through Excel. Anyways, I went through DatabaseName > Tasks > Import Flat File and the usual ...
user avatar
1 vote
1 answer
22k views

PostgreSQL: date/time field value out of range

Software: Linux cjz-eshop1-p 5.4.0-33-generic #37-Ubuntu SMP Thu May 21 12:53:59 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux psql (PostgreSQL) 12.3 (Ubuntu 12.3-1.pgdg18.04+1) I am getting errors due to ...
user avatar
  • 153
2 votes
0 answers
435 views

Data-tier .bacpac import keeps failing

Within a container, I have SqlServer running in a docker container. It was created like so: docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=$1" -p 1433:1433 --name sql1 -v sql1-sqlvolume:/var/opt/...
user avatar
  • 121
0 votes
2 answers
3k views

How to import multiple CSV files to a postgres table using pgadmin or other method?

I'm looking to import a folder of over 100+ csv files into one table on PostgreSQL using pgadmin. I have the following script but is there a way to change the file path to all csvs? COPY schema.table ...
user avatar
0 votes
1 answer
253 views

How can I monitor the import progress of a large CSV File in mysql?

I am trying to import an existing CSV file into my database and I want to see the progress. I usually use pipe viewer when I do my sql files but for csv files I cannot figure out how to do it. I use ...
user avatar
0 votes
2 answers
5k views

Data truncation: Incorrect datetime value: '7/21/15' for column 'announced_on' at row 1

I am importing a flat file into a table in DBeaver v7.0.2. When I attempt to import, it's throwing an error for date field formatted as mm/dd/yy. The date column in the table is defined with ...
user avatar
  • 129
1 vote
1 answer
2k views

MySQL Workbench: I need to update values in a table based on values from a csv

Newbie Problem, but I've tried creating a new table and importing the csv to that then updating, but I have been having trouble with that, any guidance would be greatly appreciated. I have a csv file ...
user avatar
0 votes
1 answer
866 views

Can't find any tables after psql dump import from pgexercises.com [closed]

I'm trying to import the database used for the PostgreSQL exercises at pgexercises.com. I ran the following command as recommended, and it went through without errors and even showing Inserts with ...
user avatar
0 votes
0 answers
218 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
1 answer
53 views

How extract cldr timezones from xml file to store in a DB table? [closed]

In our DB, I need each location to be associated with a "timezone". These timezones are in https://github.com/unicode-org/cldr/blob/release-36-1/common/supplemental/metaZones.xml I want to make a ...
user avatar
0 votes
1 answer
175 views

Error import postgres database

I have a databse dump db.sql.schema I import it using psql -U user dbname < ~/db.sql.schema After import in my DB I see table mytable but not mytable_id_seq. # \d mytable Table mytable ...
user avatar
  • 103
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
  • 422
0 votes
1 answer
48 views

How can I import multiple .xlsx and .xls files into multiple tables in Access?

I have 100 .xslx and .xls files with different formats and I need to import them all separately into Access keeping their original file names intact. Folder example: C:\Users\username\Desktop\...
user avatar
0 votes
1 answer
117 views

Filemaker Database. How to import to one table then copy information to a different table and populate realted tables

I'm using filemaker to create a union membership database, the problem i'm having is that you can't import files into related tables. Basically i'm trying to figure out how I could import an excel ...
user avatar
8 votes
2 answers
4k views

Shall I use enum when are too many "categories" with PostgreSQL?

Problem I plan to load a CSV with more 10 million records into PostgreSQL v12.1, one of its columns has "categorical" values, so creating an enumerated type for it seems to be a good choice, but it ...
user avatar
  • 325

1
2 3 4 5
11