Tagged Questions

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

learn more… | top users | synonyms

0
votes
2answers
13 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 ...
0
votes
1answer
41 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
36 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
22 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
27 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 ...
0
votes
0answers
28 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
48 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 ...
0
votes
1answer
37 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
46 views

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

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
56 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 ...
0
votes
1answer
18 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
2answers
52 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 ...
1
vote
0answers
37 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
votes
1answer
358 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
63 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
57 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
67 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
39 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
184 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
214 views

mysql dump a table to remote host

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
142 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
26 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
123 views

CSV data export to SQL Database with double quote problems

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
75 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. ...
5
votes
3answers
235 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
1answer
106 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
16 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
44 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
101 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 ...
0
votes
1answer
55 views

Why is it necessary to type “host” before the imp command when I'm using SQL*Plus to import a dmp file into Oracle?

In SQL*Plus, I'm connected to an Oracle 11g database. When I type imp help=y It gives me SP2-0042: unknown command "imp help=y" - rest of line ignored. But when I type host imp help=y it ...
0
votes
0answers
20 views

View dependency error

I am going to import a lot of views from my old mysql server. There is a lot of dependencies between views and tables and other views. MySQL does not allow creating a view if its referenced queries ...
0
votes
0answers
26 views

Import CSV script executes and returns NULL on localhost

I have been running this import script on localhost to import CSV fields to my database. The script executes and returns the rows as NULL and no data is inserted. It would be great to get another set ...
3
votes
0answers
69 views

Using Import Wizard with Access - No null values

I am trying to import a table from Access to SSMS using the Import Wizard but when I do the resulting table has a lot of empty strings instead of the NULL values that I am expecting. How do I make ...
1
vote
1answer
100 views

Import using pgAdmin3 produces ERROR: duplicate key value violates unique constraint

I am importing from the GUI a CSV file into a table. I have created the following table: CREATE TABLE jira_tickets.daqa_rpt_tbl ( daqa_report_id bigint NOT NULL DEFAULT ...
0
votes
0answers
70 views

Match unique id's on import- csv to sql

I have a csv file that I would like to import into a phpMyAdmin database (Wordpress). The CSV file is formatted as shown below: list-id | post_title | slider | ...
0
votes
1answer
322 views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
0
votes
0answers
31 views

Trying to import an addressbook

I'm trying to import a .sql-file that I got by converting an .dbf-file. The problem is this line: INSERT INTO address values ('', '', 'Dekanat', '', 'Fachhochschule Hildesheim/Holzminden/Göttingen', ...
2
votes
1answer
323 views

Why would the size of MySQL MyISAM table indexes (aka MYI file) not match after mysqldump import?

I've been archiving some MySQL (version 5.0.96) MyISAM tables locally and deleting from my server after checking the data. Every time the process has been pretty similar and comes off mostly without a ...
0
votes
1answer
105 views

Moving the IBM Informix IFMXDATA directory to another machine

I'm a total newbie when it comes to Informix DBs, and I'm stuck with what looks like files that contain an Informix database. I'd like to know if it's possible to add or import these files into an ...
1
vote
0answers
3k views

Importing a different character set export dump into another DB instance

I am trying to import a given dump file using oracle imp utility. However; I am facing the following issues. C:\Users\AD>imp DB_USER/*****@dev1 file=C:\test\db42312.dmp log=C:\test\import2.log ...
1
vote
0answers
309 views

Importing bulk csv file to oracle database

I am going to import a bulk csv file to oracle database. This file contains around 200m records. I was wondering what is the best way of importing this file? I check the performance of SQL developer ...
1
vote
1answer
183 views

Import 10 Billion Rows, Daily [closed]

I need to import 10 billion rows into a database, daily. SSIS, doesn't seem like its cutting it, and I'm starting to think that writing some kind of custom C/C++ code might be an option (I don't much ...
0
votes
0answers
991 views

Importing dump file contents to another DB with different schema using Oracle Data Pump

I asked this question in stackoverflow but no one was able to answer it so am trying my luck here if anyone knew what am talking about. Here is the link original question. What i wanted to do is to ...
1
vote
1answer
128 views

LOAD DATA INFILE decline in performance

Query for insert: LOCK TABLE tbl WRITE; ALTER TABLE tbl DISABLE KEYS; load data local infile "E:/One.txt" into table tbl fields terminated by "\t" lines terminated by "\n" (user_id, sexid, cityid); ...
0
votes
0answers
80 views

MySQL import gets slower and slower until it virtually grinds to a halt, what can I do to maintain constant speeds?

I'm importing a large set of sql data into a MySQL (MariaDB 5.5) database, the files are from 200mb to 3g. I'm importing it one after the other, and it starts importing at speeds around 1MiB/s to ...
1
vote
1answer
293 views

Generate INSERT statement from SELECT query

I have two databases, in first database I have a table called zoom_city and in the second database I have a table called courrier_city. The SQL for each is below: CREATE TABLE IF NOT EXISTS ...
0
votes
2answers
770 views

Where .dmp file is restored after import in oracle?

I am new to oracle and I have abc.dmp file at c:\abc.dmp location. I want to import this abc.dmp file. I am using the following command. c:\>imp system/mypassword file=c:\abc.dmp full=y I am ...
0
votes
1answer
142 views

How to export oracle 11g database partially

I have a huge oracle test database whose size is more than 100 GB. I want to export only 1% of all the data and import it into my local database to have a local replica of that application. Is it ...
0
votes
2answers
195 views

How to generate error log file while executing a .sql file in terminal

I just started learning coding 2 week ago and I am in a middle of an issue that I am not really able to find online, SO i though why not ask. I am trying to import Import a MySql DB of around 8 Gigs ...
0
votes
1answer
1k views

SQL Server error importing an Excel sheet

I am facing a problem while loading & importing an Excel sheet into a SQL Server database. The error is The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an ...