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

learn more… | top users | synonyms (1)

0
votes
1answer
129 views

How do I load this SAS text file to SQL Server 2005

Every 3 months, I have to load several fixed-width text files into our SQL Server 2005 database. They can have anywhere from 5 to 798 columns (seriously) and the columns change pretty regularly. ...
1
vote
1answer
701 views

Mysql query hangs on import

I dumped all my databases in order to import them into a slave. mysqldump --all-databases > dump.sql The import seems to be very very slow. Checking the processlist, I saw a simple insert on a ...
1
vote
2answers
108 views

Creating index on large MySQL table taking forever

My table has 981 million rows and is about 30GB large. It is six columns: ID, Ticker, Date, Time, Price, Volume. The data was in text files and using LOAD DATA INFILE was actually quite painless and ...
-1
votes
1answer
156 views

Database size after importing the .sql file [closed]

I was about to import a .sql file into a database. The size of the sql file is 35GB, and the available size in our server is 10gb. At this point, can I import the sql file into the database? I'm not ...
1
vote
1answer
249 views

import text file getting command is not allowed with this MySQL version

here is my table CREATE TABLE cities ( country CHAR(2), city_ascii VARCHAR(100), city VARCHAR(255), region CHAR(2), population INT UNSIGNED, ...
0
votes
0answers
286 views

How to ensure MYSQL imports of .sql files properly retain foreign key relationships, constraints, etc

Recently, we restored a MySQL '*.sql' file on two separate brand new MySQL instances. The MySQL version is 5.5.40 running on CentOS 6.6. In one instance, everything restored fine. On the other, a ...
1
vote
1answer
819 views

How to update a huge MySQL table from a text file

I have a huge MySQL table with 1.3 TB data with InnoDB engine format. Now I have a text file containing updated values of 2.2 GB of records in the 1.3 TB of data. How do I proceed ? I am a newbie ...
5
votes
1answer
714 views

Get minimal logging when loading data into temporary tables

Even after reading The Data Loading Performance Guide , I am still unsure if its necessary to add the TABLOCK table hint to an empty temporary table, defined with a clustered index in order to get ...
0
votes
1answer
605 views

Importing a Foxpro Database

I have a Fox Pro database (one DBC and a bunch of DBF files) that I want to import into SQL via the Import and Export wizard. I downloaded the FoxPro ODBC driver. I managed to get to the screen that ...
0
votes
2answers
2k views

How to import DB with .sql extension into SQL Server 2012?

I have a database with .sql extension which is exported from server using putty. How to import this into SQL Server 2012 in Management Studio? It is not accepting .sql as database, throwing error. ...
0
votes
0answers
2k views

ERROR: relation “name” does not exist

I am trying to import a postgresql database table sent to me in phpPgAdmin, I am following the instruction from this import database But after doing so, several error appear, I also tried to import ...
0
votes
1answer
476 views

Import CSV file - dynamic path

I am trying to import a csv file dynamically. This works: BULK INSERT #CSV FROM 'C:\Users\MyName\Desktop\Players.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) I would like to ...
0
votes
1answer
454 views

PostgreSQL import XML to empty database, automatically create columns

The server is Linux but the development machine is Windows so I'm using psql command line. I tried \i C:/Users/John/Desktop/Parts.xml which did not work so either \i doesn't work with XML or I'm ...
0
votes
1answer
429 views

Increase in temporary tablespace while import

When i am importing some tables in my database, the temporary tablespace is getting full. This never happened earlier for other tables. Please help me know why this is happening and any solution for ...
0
votes
1answer
5k views

How to import large sql file in postgres?

Trying to import sql file around 8GB using these commands sudo -u postgres psql yourdb -f my_file.sql sudo -u postgres psql yourdb < my_file.sql sudo -u postgres cat my_file.sql | psql yourdb ...
2
votes
3answers
623 views

Creating a MySQL db from an Informix database

There is an existing database that was created in Informix. I would like to export it and then import it into MySQL. I tried to export it using dbschema and it created the dbase.sql file and several ...
2
votes
2answers
792 views

Importing CSV file using SQL Server Import and Export Wizard (SQL Server Express)

So I am having a heck of a time importing a CSV file. The ultimate goal is to create a repeatable process to import the file. The only way I've been able to import the file is in a roundabout way ...
0
votes
1answer
6k views

Importing a SQL Dump File through XAMPP's Command Line

A few days ago, I exported a .SQL dump file with all my databases, which is about 150MB. The thing is I cannot import it through phpMyAdmin since the file is way to big. I remembered there was ...
0
votes
2answers
131 views

Best way to update the content of large lookups tables

In our application we have a about 20 tables that contain lookup information (read only data that the application doesn't modify). Nightly we'd like to update this information by deleting all the ...
0
votes
1answer
374 views

Extract certain rows from table and import

I have a requirement to export / extract certain rows (matching some query) of some tables from one oracle database and import those rows in the respective tables of other database. both source and ...
1
vote
0answers
137 views

Importing CSV Files with Date Columns

I am working on a project that involves importing data via Apex's data workshop. Two of my columns contain dates in the format YYYY-MM-DD HH:MI:SS. Can anyone tell me how to get Apex to import these ...
2
votes
1answer
158 views

3 minutes to import 327Mo database

We do database import a lot of times per day on a server with those specs : Xeon E5-1620v2 4c/8t @ 3,8Ghz 32 Go DDR3 ECC 1600MHz Hard Drive 2x 3 To SATA3 MariaDB 10.14 with XtraDB Given a 327Mb ...
2
votes
1answer
911 views

ERROR 1297: Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER when importing data

I have the cluster built by one MGM Node and two data/sql nodes When importing data to an NDB node the importation crashes returning the following: ndb_2# mysql -u root -p db < data.sql Enter ...
0
votes
1answer
453 views

How to use imdpd to import data file into different schema including index from different tablespace as well

The original data pump file is generated by the schema which living in two tablespaces(OLD_SCHEMA_DAT and OLD_SCHEMA_IDX), if import back to the original tablespace, everything is fine, but when I use ...
1
vote
0answers
4k views

How can I load csv data into mongodb and choose the types I'd like to have created for each column? [closed]

I'm looking for a way to load csv data in mongodb and specify the types that I'd like to have created for each column? I've been using mongoimport but I find it quite painful because there doesn't ...
1
vote
2answers
315 views

How to monitor flat file for changes then run a SQL import job

I have a file that is a flat text file that needs to be imported into my SQL Server every day. The problem is that I have to wait for someone else to download and place the file before I can import ...
1
vote
1answer
2k views

Escaping delimiter in postgresql

I am trying to import data into postgres. Data fields are comma separated, strings may contain commas, in which case those are escaped: Data structure: create table v (a varchar); Data file: bus ...
1
vote
1answer
44 views

Easiest way of porting data into a database

Recently, I received a lot of information from one of my friends who made a quiz type program. He asked me to help port it into an Access database. His program places all the info in a grid; around ...
0
votes
0answers
177 views

Selectively load data using Oracle 11g r2 External Table Preprocessor

I am using the Preprocessor feature in Oracle 11g r2 to load several data files in a table. However, the raw files seem to have certain rows that shouldn't be imported with the rest. For example: ...
0
votes
2answers
2k views

How do I fix #1062 error received while importing EE database to localhost from remote server

I am trying to import a MySQL database into the localhost database that was exported from the remote database and I am receiving a #1062 error (which is weirdly in French!): #1062 - Duplicata du ...
0
votes
0answers
93 views

How to import data into Oracle 11g r2 daily

I need to batch load several log data files (comma delimited but they don't have a .csv extension in the file name) once each day into an Oracle database. I'm sure this is a very common use case, but ...
2
votes
2answers
1k views

Oracle Data Pump Import imports no records

When we do an Oracle Data Pump import of our database, it runs without significant errors. However, on one table Oracle reports that 0 records have been imported. Processing object type ...
1
vote
0answers
87 views

Import expanded csv file into mysql

I need to import a spreadsheet that was being viewed with the expand/collapse feature into mysql. As shown in the screenshot, when an item (WMIMCART1 in this case) is expanded, it shows more info ...
1
vote
1answer
12k views

SQL import data when both source and destination has data and identity column

I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. All the tables have primary key which is identity ...
3
votes
0answers
437 views

Ways to process XML into a relational structure in Postgres

I have a database that is comprised of ~10 tables, most of which have many-to-many relationships with each other (and an associated join table). I am inserting of the order 100k XML files into a raw ...
2
votes
2answers
89 views

How do you update a large MySQL table that's on a server?

I have an application on a web server. The PHP front end for the application queries a MySQL database which has a table that contains 60 million taken domain names. My application queries this ...
1
vote
1answer
2k views

Import multiple CSV fields into one MySQL field

I'm trying to import our CSV data log into our MySQL. The first two fields of the CSV are Date and Time, and I would like to combine that into one date time (which can be searched) onto MySQL. CSV: ...
0
votes
1answer
333 views

Import binary database file into postgres

I have a quite newbie question that I do not know if is possible or not: I had to format my computer, and the only way to keep my postgres database was accessing to data with my folder browser ...
1
vote
1answer
5k views

Oracle error 12154 while importing DMP file

My Setup I'm running Windows 7 64-bit, using Oracle DB 11g R2 for Windows 64-bit. I have Oracle SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed the ...
0
votes
1answer
2k views

mysql dump a table to remote host [closed]

i want to dump a table from localhost host (with public ip), here is the command so far, the command will be run on localhost mysqldump --opt --host localhost --user=username --password=password ...
0
votes
1answer
2k views

Import errors importing CSV to SQL Server table

I am using SQL Server 2014 Management Studio to import a very large .CSV file into a table. So far I have been trying to accomplish this by right-clicking on the database and selecting Import Data, ...
2
votes
1answer
51 views

Is it possible to import a single mysql database directory?

I am somewhat new to mysql. I created some databases recently and, to back them up, I just copied the folders with those database names in the mysql data directory (i.e containing only db.opt, .frm, ...
0
votes
2answers
569 views

CSV data export to SQL Database with double quote problems [closed]

I am trying to import data from falt files (.CSV) into SQL table. I am able to import them no problem but the data is coming with double quotes. What is the best way of resolving this problem? ...
0
votes
2answers
298 views

Split date time, with only time, into minutes and seconds

I'm creating an Access database from an excel file that contains metadata about vhs tapes and DVDs. The person who created the excel file had the running times as a date/time field in minutes:seconds. ...
7
votes
3answers
3k views

InnoDB import performance

I'm struggling with bulk importing a quite big InnoDB-Table consisting of roughly 10 Million rows (or 7GB) (which for me is the biggest table I've worked with so far). I did some research how to ...
0
votes
2answers
517 views

How to import into database when records contain multi-line data [closed]

I am setting up a new database and I want to import lots of data from multiple spreadsheet files. One of the fields in these documents contains an array of data, each item declared on seperate rows as ...
1
vote
1answer
603 views

Load csv into MySQL database programmatically

I know about LOAD DATA INFILE command -- however, this requires that we already have the table with appropriate columns in place. When I have csv with hundreds of columns, it is not feasible to type ...
0
votes
0answers
31 views

Disable procedures for data load in MySql using Innodb engine

I have a database with an integrated ledger for a multi-unit company. As we bring new units into the database we load their existing ledger data into ours. Unfortunately the existing procedures on the ...
0
votes
0answers
91 views

How best to export from Oracle Ent Ed (EE) to Oracle Express Edition (XE)?

I am aware that Oracle Ent Ed (EE) has more functionality than Oracle Express Ed (XE). But I would like to do a FULL export from EE to XE. Is this even possible? The only solution I can assume will ...
0
votes
1answer
687 views

Restore an oracle dmp file

I've been given an oracle DMP file that was created on a solaris system which I need to restore to a windows system. I've created the DB with the correct blocksize, but when I try and do the restore ...