Skip to main content

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
0 votes
1 answer
29 views

Importing mysql file fails printing last line and I find ^@^@^@^@^@^@^@^@^@^ on that line

I am trying to import some relatively large databases, over 100 GB dump file. When I try to import the dump files with a command like: mysql -h localhost -u username -p dbname < backup.sql after ...
adrianTNT's user avatar
  • 194
0 votes
1 answer
30 views

Microsoft SQL Server Import Export Wizard on Remote SQL Server

Is it possible to run the SQL Server Import/Export Wizard purely on a remote server (e.g., from one database to another on the same remote server)? If I setup the source/destination connections in the ...
Phil C's user avatar
  • 103
0 votes
3 answers
264 views

MariaDB Crashes Every Time Restarted

OSX Sonoma, OSX Monterey Latest MariaDB from Homebrew (11.4.2-MariaDB, client 15.2 for osx10.17 (x86_64)) MariaDB won't start every time I restart the brew service or restart the computer. I ...
Penyo's user avatar
  • 1
0 votes
0 answers
21 views

I need help pulling info from a .txt file into a table in either access or excel

So.. I've tried both Excel and Access to do what I need but I don't know the programs well enough to get them to do what I want, if it's even possible. I have a hourly updating .txt file with ...
UmßraDivisio's user avatar
1 vote
1 answer
34 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
26 views

Why trying to enable NULL values in a MySQL timestamp field fails?

I imported the table delete_me from the following mysqldump's exported file -- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64) -- -- Host: 192.168.00.00 Database: main -- ----------------------...
0xC0DEGURU's user avatar
-1 votes
1 answer
22 views

POSTGRES : Data import

DB Version : 13.x Source table schema\ CREATE TABLE mig_bus_data mig_id SERIAL, mig_data JSONB Target table schema\ CREATE TABLE BUSINESS id UNIQUE SERIAL, data1 <TYPEx&...
CSP's user avatar
  • 11
0 votes
0 answers
28 views

Problems with minutes in timestamps when inserting data into InfluxDB via PowerShell

I am working with InfluxDB and trying to insert time series data via PowerShell. My goal is to insert data points with specific timestamps containing hours, minutes and seconds into InfluxDB. I am ...
michi's user avatar
  • 101
1 vote
0 answers
206 views

Why is the data in a varchar field exceeding the size limit?

I have an application that is copying data from one PostgreSQL database to another. For the most part, that application works exactly as expected. However, there is a comments column in one of the ...
G_Hosa_Phat's user avatar
1 vote
1 answer
191 views

How can I simplify the process of importing only changed data?

Background Two years ago, I asked a question about how to model a food's relationship with its nutrients. Today, that design has evolved. The biggest change is that whenever a food is updated, we ...
Check12's user avatar
  • 63
-1 votes
1 answer
63 views

Expecting "," or ")", found "nvarchar2"

Here is my SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023 OS=UBUNTU 20 I am trying to load data from csv file with the help of following code: OPTIONS (SKIP=1) LOAD DATA ...
Java_Beginner's user avatar
1 vote
1 answer
50 views

Is an import partially executed when mysql import errors during that import?

While importing a database I received a Duplicate Entry error. ERROR 1062 (23000) at line 2825: Duplicate entry 'homerow' for key 'PRIMARY' Are the import instructions up until line 2825 executed or ...
devunder's user avatar
  • 111
0 votes
0 answers
256 views

Trying to import large sql file in MySQL fails

I am trying to import an SQL file that is 685MB into MySQL. First I tried it through phpmyadmin - it failed. Then I tried through the command line with: mysql -u root -p database-name < file.sql ...
Petar Vasilev's user avatar
1 vote
1 answer
479 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
0 votes
1 answer
807 views

Importing CSV File into MySQL gives UnicodeDecodeError

I'm trying to import a CSV file into the insert tab of a MySQL database model. Importing the file gives the following error: Error during data import: UnicodeDecodeError("'ascii' codec can't ...
SlowlySwift's user avatar
0 votes
1 answer
698 views

How to increase ODBC Command Timeout When Using SQL Server Import/Export Tool

I am using ODBC driver to transfer data from Postgres to SQL Server https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-postgresql-data-source-sql-server-import-...
Imran Qadir Baksh - Baloch's user avatar
1 vote
1 answer
610 views

How to import CSV files into MariaDB in a secure and performant way?

We have a PHP based web application that allows the upload of CSV files. These CSV files with up to 2.5 million rows are to be imported into a table in a MariaDB. How can we make this import secure ...
Ste2play's user avatar
1 vote
1 answer
932 views

LOAD DATA LOCAL INFILE with specifying first column as auto-increment value

LOAD DATA LOCAL INFILE 'index.csv' INSERT INTO TABLE `aws_pricing` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 6 LINES; Thing is, my table ...
anjanesh's user avatar
  • 279
0 votes
1 answer
302 views

Import big mongodb bson archive > 300Mb

I've installed mongodb the next way on Ubuntu 20.04: wget -qO - https://www.mongodb.org/static/pgp/server-6.0.asc | sudo apt-key add - echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/...
Gryu's user avatar
  • 285
2 votes
1 answer
523 views

SELECT COUNT() returns ReadFailure after importing data from another cluster

I've cloned one cluster to another with these steps: Copy table files on each source node from /var/lib/cassandra/data/keyspace/table/snapshots... to /location/snaps/ Run sstableloader on each ...
dba_db2_dse's user avatar
0 votes
0 answers
1k views

Postgresql import csv failing on quoted \r\n

This is my first question here and I'm new to Postgres as well. I'm trying to import a csv file into an existing table that has an identical structure. Using the PgAdmin4 Import/Export data... I get ...
JHerbst's user avatar
0 votes
0 answers
285 views

Why am I getting the error "Object ... was not found" when importing a dump?

I want to import a dump file but I have this error: Import: Release 19.0.0.0.0 - Production on Wed Feb 22 07:56:35 2023 Version 19.16.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. ...
Quynh Anh's user avatar
1 vote
0 answers
189 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
0 votes
1 answer
37 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
281 views

Importing working MariaDB innodb dump into new database and receiving Error 1071 Key too long

Old server is MariaDB 10.6 New server is MariaDB 10.3 I mysqldump the old DB which is still the master copy and functioning. I made sure the new server DB is set to InnoDB (like the old one) using ...
postuple's user avatar
1 vote
2 answers
563 views

dbatools import csv help!

Is there a way I can import csv files with the proper data types into MSSQL table using PS dba tools? I'm using this below command but all I get is a table and all the columns are nvarchar(max): ...
SAKA UK's user avatar
  • 100
0 votes
1 answer
2k views

#1064 - SQL syntax Error while trying to import

DROP TABLE IF EXISTS `migration_versions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migration_versions` ( `version` ...
J. Scott Elblein's user avatar
-3 votes
1 answer
493 views

Import 5gb sql file into MYSQL database [duplicate]

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 ...
deep.er's user avatar
0 votes
1 answer
2k 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 ...
transmod_kdtk's user avatar
3 votes
1 answer
104 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
2 votes
1 answer
8k 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 ...
spectre's user avatar
  • 121
18 votes
5 answers
5k 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 ...
user55570's user avatar
  • 369
1 vote
1 answer
5k 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 ...
showkey's user avatar
  • 334
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
1 vote
1 answer
2k 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 ----------------...
Dave's user avatar
  • 723
0 votes
1 answer
414 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=(...
Cho Wai Tun's user avatar
0 votes
1 answer
1k 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>/...
JConstantine's user avatar
3 votes
1 answer
368 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 ...
Namu N's user avatar
  • 31
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
2 votes
1 answer
2k 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, ...
NatY's user avatar
  • 23
1 vote
1 answer
437 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 ...
carouselcarousel's user avatar
7 votes
1 answer
12k 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 ...
baggiponte's user avatar
0 votes
1 answer
3k 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"},{...
Lautaro Aguilera's user avatar
3 votes
1 answer
5k 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=...
Mary Ann's user avatar
1 vote
2 answers
906 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 ...
CodeMonkey's user avatar
0 votes
1 answer
276 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 ...
kgbviz's user avatar
  • 3
1 vote
1 answer
721 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
1 vote
3 answers
3k 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 ...
Nitesh Parasher's user avatar
0 votes
2 answers
1k 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-...
catalin's user avatar
  • 123
1 vote
0 answers
40 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....
moudiz's user avatar
  • 115

1
2 3 4 5
11